How can I exclude everything after multiple symbols ?

[Anonymous]

I got values like:

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

How would I get?

Name
Ben
Sam
Tom

[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]

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

];