Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@Ankhi you can use :
mid(Field,FindOneOf(Field,'-')+1) as New_Field
output:
@Ankhi you can use :
mid(Field,FindOneOf(Field,'-')+1) as New_Field
output:
Thanks a lot Taoufiq..It worked. 🙂