How to Split the data and display required value from the Column in Qlikview Script

[shabarish0587]

Hi Folks,

               I am facing one issue. i have a column like Tag. In this column i need to display middle value. i need to remove unwanted data. i tried using subfield. but i am not getting expected output. can anyone help me on this.

For eg: I have a value like this {NameImplement_ref/tag/123456}  and i am expecting like this Implement. I need to remove {Name and also _ref/tag/123456} only between whatever i have the value i need to display . can anyone help me on this.  i am sharing sample spreadsheet

Expected Output:

[MayilVahanan · Accepted solution]

Hi 

Try like below

Temp:
Load *, TextBetween(Tag, 'Name', '_ref') as ExpTag;
LOAD ID,
Project,
SubField(Tag, ',') as Tag
FROM
[D:\Qlik\Com\Tag_Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
OP:
Load ID, Project, Concat(Tag, ',') as Tag, Concat(ExpTag, ',') as ExpTag Resident Temp Group by ID, Project;

DROP Table Temp;

O/P:

[shabarish0587]

Thank you Mayil Vahanan