topic Re: Text between from the right side in QlikView

Text between from the right side

Mon, 31 Aug 2015 14:30:43 GMT

Hello all,

as you can read in the title, how can I to the text between function from the right side?

Example:

c:\\Folder\Sub\Sub2\File1.txt

c:\\Folder\Sub\Sub3\Sub7\File2.txt

c:\\Folder\Sub\Sub2\File3.txt

I need to get a column with values like this:

Table:

File1,

File2,

File3.

Is there a way to do this?

Thanks in advance

Re: Text between from the right side

Gysbert_Wassenaar — Mon, 31 Aug 2015 14:32:23 GMT

subfield(subfield('c:\\Folder\Sub\Sub2\File1.txt', '\', -1),'.',1)

Re: Text between from the right side

sunny_talwar — Mon, 31 Aug 2015 14:32:56 GMT

Try this may be:

Replace(SubField(FieldName, '\', -1), '.txt', '')

Update:

Script:

Table:

LOAD *,

Replace(SubField(FieldName, '\', -1), '.txt', '') as NewFieldName;

LOAD * Inline [

FieldName

c:\\Folder\Sub\Sub2\File1.txt

c:\\Folder\Sub\Sub3\Sub7\File2.txt

c:\\Folder\Sub\Sub2\File3.txt

];

Output:

Re: Text between from the right side

Mon, 31 Aug 2015 15:05:23 GMT

The script is like this.

T1:

LOAD * Inline [

data

c:\\Folder\Sub\Sub2\File1.txt

c:\\Folder\Sub\Sub3\Sub7\File2.txt

c:\\Folder\Sub\Sub2\File3.txt

];

T2:

LOAD *,

SubField(SubField(data,'\',-1),'.',1) AS FILE

Resident T1;

DROP Table T1;

see the attached qvw