Subfield Query

[Zara]

I have a dimension called Text and I want to pull out specific words, example of the output of the field below –

Vendor Changed from 'Customer 1' to 'Customer 2'

I want to isolate everything between the ‘'' i.e. customer 1 and customer 2.

I’ve used text between, right, len, index etc before but I always put the delimiter in single quote marks. How do you add the delimiter into a formula when the delimiter is a ' -  as ''' isn’t working.

=TextBetween([Text],',',1)

[Lisa_P · Accepted solution]

Replace the ' in the expression to the Unicode representation chr(39)= apostrophe

=TextBetween(Text, chr(39) ,chr(39), 1 )

if you go for 2 it will pull out the to, so to get the Customer 2 you need to ask for 3

[Zara]

Thank you so much Lisa, this has been doing my head in for days.