topic Re: FileName in Water Cooler

FileName

Tue, 13 Mar 2012 05:28:46 GMT

I Have a file name FY07 CU_Consultancy and

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

kamalqlik — Tue, 13 Mar 2012 06:16:06 GMT

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 — Tue, 13 Mar 2012 06:39:01 GMT

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