topic Re: Subfield Query in App Development

Subfield Query

Zara — Wed, 27 Oct 2021 17:41:47 GMT

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)

Re: Subfield Query

Lisa_P — Thu, 28 Oct 2021 03:56:05 GMT

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

Re: Subfield Query

Zara — Thu, 28 Oct 2021 09:20:51 GMT

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