Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sean1994
Contributor
Contributor

How can I exclude everything after multiple symbols ?

I got values like:

Name
Ben( sa) weld
Sam : 1weld
Tom (us) : Climb

How would I get?

Name
Ben
Sam
Tom
2 Replies
sunny_talwar

Try this

Table:

LOAD *,

Trim(Left(Name, FindOneOf(Name, '`~!@#$%^&*()_+=-}{][":;/.,<>?' & Chr(39))-1)) as New_Name;

LOAD * INLINE [

    Name

    Ben( sa) weld

    Sam : 1weld

    Tom (us) : Climb

];

sasiparupudi1
Master III
Master III

T2:

Load

F1,

If((Index(F1,':')>0 and Index(F1,')')>0),SubField(SubField(F1,':',1),'(',1),

If((Index(F1,':')=0 and Index(F1,')')>0),Trim(SubField(F1,'(',1)),

If((Index(F1,':')>0 and Index(F1,')')=0),Trim(SubField(F1,':',1)),F1))) As Name

  Inline

[

F1

Ben( sa) weld

Sam : 1weld

Tom (us) : Climb

];