topic Re: How can I exclude everything after multiple symbols ? in QlikView

How can I exclude everything after multiple symbols ?

Anonymous — Tue, 08 May 2018 04:08:20 GMT

I got values like:

How would I get?

sunny_talwar — Tue, 08 May 2018 11:44:55 GMT

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 — Tue, 08 May 2018 11:55:49 GMT

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

[

Ben( sa) weld

Sam : 1weld

Tom (us) : Climb

];