Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to trim particular place onwords

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

2 Replies
kamalqlik
Partner
Partner

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
Master II
Master II

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

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