Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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
Thank you so much Lisa, this has been doing my head in for days.