apichana
Contributor III
2021-03-31
11:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
2 Solutions
Accepted Solutions
rwunderlich
Partner Ambassador/MVP
2021-04-01
12:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Lisa_P
Employee
2021-04-01
12:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 Replies
rwunderlich
Partner Ambassador/MVP
2021-04-01
12:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
TextBetween(PR_No, "SR", "_")
-Rob
Lisa_P
Employee
2021-04-01
12:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Here is one way:
TextBetween(PR_No, 'SR', '_')
apichana
Contributor III
2021-04-01
02:04 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Lisa,
It works !! Thank you so much.
800 Views
apichana
Contributor III
2021-04-01
02:05 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works. Thank you so much.
794 Views