Question Regarding String function with Alphanumeric value

[hspatil31]

Dear All,

I am having following file.
90101595958_CHQLV_FCF--%A_27092008_D.xls

From that file i want cut vlue FCF and i want to store that 'FCF' value in one variable. Can anybody suggest me how to do it.

Thnks and Regards
Harish Patil

 

[MattP]

Is the value you want to cut always in the same position? Are the file names following a naming convention of some sort?

 

[hspatil31]

Regarding cut the string

Dear Freind,

sch_name = Replace(Txt_Filepath.Text.Trim.ToUpper.Substring(Txt_Filepath.Text.Trim.LastIndexOf("\") + 1), ".XLS", "")

In sch_name get the file name 90101595958_CHQLV_FCF--%A_27092008_D.

Now i want from this file FCF cut and store in another variable.

Like scm_file = FCF

Can u plz tell me how to do it ?

Thanks nd Regards
Harish Patil