bdgeddam9
Contributor
2018-07-26
10:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Searching Pattern in Data
Hi i have data as follows and basically need data before "@" and after "/"
us/us 2013/us@2018/uk
1,176 Views
1 Solution
Accepted Solutions
sunny_talwar
MVP
2018-07-27
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This gives us
=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)
1,112 Views
6 Replies
sunny_talwar
MVP
2018-07-26
11:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Since '/' repeats multiple times, which one do you want to consider? In essence what is the string that you would like to pull out?
1,112 Views
sunny_talwar
MVP
2018-07-26
11:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
One option can be to try this
=TextBetween('us/us 2013/us@2018/uk', '/', '@')
sunny_talwar
MVP
2018-07-26
11:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or this
=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)
1,112 Views
bdgeddam9
Contributor
2018-07-27
08:40 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Thanks Sunny.
I am looking for "us" .I think either of functions gives answer
1,112 Views
sunny_talwar
MVP
2018-07-27
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This gives us
=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)
1,113 Views
bdgeddam9
Contributor
2018-07-27
09:10 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
using text function this will give aswer :
=TextBetween('us/us 2013/us@2018/uk', '/', '@',2)
1,112 Views