cancel
Showing results for 
Search instead for 
Did you mean: 

Text Mapping Function

silentbull
Participant
0 Kudos

Hi

I am getting a data as 'TEST1234.csv' from source and I would want to map only the contents before the .csv.

Should i use replacestring for this or any other mapping function.

Regards

Sam

Accepted Solutions (0)

Answers (3)

Answers (3)

nidhi_srivastava22
Active Contributor
0 Kudos

Hi,

You can use replaceString as suggested by Ramesh.

You can also use other function like Substring & Trim.

Thanks,

Nidhi

former_member213558
Active Participant
0 Kudos

you can use replace string. it should work.

fyr .

maheswarareddykonda
Active Contributor
0 Kudos

Hi,

If you are sure always extension(.csv) would come then you can use replace function, otherwise i would suggest go with substring function some thing like below

first you have to find the length of the data using function(length ) and use the index function to find which place that " . " symbol then do substring to get only name