Searching Pattern in Data

[bdgeddam9]

Hi i have data as follows and basically need data before "@" and after "/"

us/us 2013/us@2018/uk

[sunny_talwar]

Since '/' repeats multiple times, which one do you want to consider? In essence what is the string that you would like to pull out?

[sunny_talwar]

One option can be to try this

=TextBetween('us/us 2013/us@2018/uk', '/', '@')

[sunny_talwar]

Or this

=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)

[bdgeddam9]

Hi Thanks Sunny.

I am looking for "us" .I think either of functions gives answer

[sunny_talwar · Accepted solution]

This gives us

=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)

[bdgeddam9]

using text function this will give aswer :

=TextBetween('us/us 2013/us@2018/uk', '/', '@',2)