topic Re: Creating a variable by searching a text field in App Development

Creating a variable by searching a text field

jerryr125 — Thu, 07 Nov 2019 15:05:58 GMT

Hi - I am not sure if the following can be done or not.

I am looking to do the following to create a variable (example Field1) automatically populated with the following:

* Search through another text variable (example Field2) and find the string ABC #: within the text

* Once it finds ABC #: string it captures the ten characters after the ABC #: string and populates Field1 with that string of ten characters:

Example: Field2 contains a bunch of characters.

"Hello world text text text ABC #:1234567890 more text more text more text'

Field one would contain '1234567890' (even 'ABC #:1234567890' is fine).

Thoughts ? Jerry

StarinieriG — Thu, 07 Nov 2019 16:06:49 GMT

Hi,

maybe try with this expression for variable Field2

=TextBetween($(Field1),'ABC #:',' ')

jerryr125 — Fri, 08 Nov 2019 12:33:39 GMT

Hi - thank you for your help.

I did a test with a simple string of text:

=TextBetween('MaterialTest','at','Te')

Works great !

The question now is how do I get to work with a field ?

Thoughts ? Jerry

jerryr125 — Fri, 08 Nov 2019 12:35:49 GMT

Ok got it !

=TextBetween(fieldname,'at','Te')

Thank you for the lead ! Jerry