Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankhi
Creator
Creator

Qlikview Extract Strings after Special characters

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

1 Solution

Accepted Solutions
Taoufiq_Zarra

@Ankhi  you can use :

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

 

output:

Taoufiq_Zarra_0-1620736741454.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@Ankhi  you can use :

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

 

output:

Taoufiq_Zarra_0-1620736741454.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Ankhi
Creator
Creator
Author

Thanks a lot Taoufiq..It worked. 🙂