Trim dedicated String

[abhaysingh]

Hi Guys,

I have field in which values are like below

jaipur

imp. jaipur

Bearings

imp. Bearings

i want to exclude imp. from the values.. how can i achieve it

thanks

[abhaysingh]

Thanks for help,

I this if i want to replace two values simultaneously than?

say e.g.

box/stell

i want to show only Box as output?

thanks in advance

[avinashelite]

if you have all the values as / separate than then try with subfield(field_name,'/',1) as new_field

[PrashantSangle]

Hi,

try like

if(match(fieldName,'imp.'),replace(fieldName,'imp.',''),if(match(fieldName,'/stell'),replace(fieldName,'/stell','')))

or

if you have all the values as / separate than then try what avinash suggested.

Regards