Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

FileName

I Have a file name FY07 CU_Consultancy and

i want to take out FY07 , CU and Consultancy from the above filename?????????

1 Solution

Accepted Solutions
kamalqlik
Partner - Specialist
Partner - Specialist

Hi Manish....hwz you...

I am attaching the application for your problem.

You have to use the string functions in either backend or frontend.

I have attached the application.

Hope this help you.

Regards

Kamal Naithani

View solution in original post

2 Replies
kamalqlik
Partner - Specialist
Partner - Specialist

Hi Manish....hwz you...

I am attaching the application for your problem.

You have to use the string functions in either backend or frontend.

I have attached the application.

Hope this help you.

Regards

Kamal Naithani

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try with this Subfield

     SubField('FY07 CU_Consultancy',' ',1) returns FY07

     SubField(SubField('FY07 CU_Consultancy',' ',2),'_',1) returns CU

     SubField('FY07 CU_Consultancy','_',2) returns Consultancy

Hope it helps

Celambarasan