How to cut some word

[apichana]

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.

[rwunderlich · Accepted solution]

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

-Rob

[Lisa_P · Accepted solution]

Here is one way:

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

[apichana]

Hi Lisa, 

It works !! Thank you so much. 

[apichana]

It works. Thank you so much.