How to trim particular place onwords

[#1]

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

[kamalqlik]

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

[m_woolf]

left(YourField,findoneof(YourField, '!#%$^*&()_-+=,><')-1)

or put the string of special characters into a variable and use the variable.