Creating a variable by searching a text field

[jerryr125]

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 · Accepted solution]

Hi,

maybe try with this expression for variable Field2

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

[jerryr125]

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 · Accepted solution]

Ok got it !

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

Thank you for the lead ! Jerry