Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
plz help me
how to trim the values particular place onwords
i know left,right,index,substring
give the expression for below one
field
aaa123
bs234
2345
hsg
weh-we
jdhjj_rt
sgd*12
i need to delete after special character onwords
and
i need to delete particular place onwords
Hi Khushi,
You have to write if condition for each,as they are special character in each case.For number you can use purge char and so that.
Regards
Kamal
left(YourField,findoneof(YourField, '!#%$^*&()_-+=,><')-1)
or put the string of special characters into a variable and use the variable.