Qlikview Extract Strings after Special characters

[Ankhi]

Hi All,

I need a help to extract a portion of the text .

 I have a field which has values like 

1500 - Anglian Utility - Monitoring

I want to  create another field pulling only  'Anglian Utility - Monitoring' i.e anything after the 1st special character '-'

in load script.

Can you please help?

Thanks in advance.

Ankhi

[Taoufiq_Zarra · Accepted solution]

@Ankhi  you can use :

mid(Field,FindOneOf(Field,'-')+1) as New_Field

output:

[Ankhi]

Thanks a lot Taoufiq..It worked. 🙂