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: 
apichana
Contributor III
Contributor III

How to cut some word

Hi, 

 I have a PR_No. as below and I would like to create a new field SR-No which cut SR out and have only "207145"  , Please advise the syntax. Thank you.

apichana_1-1617247083421.png

 

 

2 Solutions

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

TextBetween(PR_No, "SR", "_")

-Rob

View solution in original post

Lisa_P
Employee
Employee

Here is one way:

TextBetween(PR_No, 'SR', '_')

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

TextBetween(PR_No, "SR", "_")

-Rob

Lisa_P
Employee
Employee

Here is one way:

TextBetween(PR_No, 'SR', '_')

apichana
Contributor III
Contributor III
Author

Hi Lisa, 

It works !! Thank you so much. 

apichana
Contributor III
Contributor III
Author

It works. Thank you so much.