topic Selecting text from a field if certain phrase is present in field. in App Development

Selecting text from a field if certain phrase is present in field.

JorisV — Tue, 22 Mar 2022 13:20:06 GMT

Hi All,

I'm loading a column that contains fields with quite an extensive amount of text.

I only want to show this field if it cointains the word memory.

Example (this is a single field, no separte columns, as it's part of an email):

memory: 4079640
scanner_type: Onbekend
scanner_firmware: Onbekend
scanner_dateofmanufacture: xxxxxxxxx
system serialnumber: xxxxxxxxx
scanner_serialnumber: xxxxxxxx

Then I want to select:

memory: 4079640
scanner_type: Onbekend
scanner_firmware: Onbekend

and only display these three lines. Can anybody

help with the expression for this?

Thanks in advance,

Joris

Re: Selecting text from a field if certain phrase is present in field.

hic — Tue, 22 Mar 2022 13:43:55 GMT

If it's in the script and you want to load records where "Field" contains 'memory' I would use

Load ... From ... Where Index(Lower(Field),'memory') ;

But what is the logic around the other two records? Is it the two lines that come right after this row? If so, you could use

Load * Where AcceptedRow or Peek(AcceptedRow) or Peek(AcceptedRow,-2);
Load ... , Index(Lower(Field),'memory') as AcceptedRow From ... ;

Re: Selecting text from a field if certain phrase is present in field.

Or — Tue, 22 Mar 2022 13:53:49 GMT

The first aspect doesn't seem problematic - seems like you need to use WildMatch(YourField,'*Memory*').

As for the second, without knowing anything about why you're keeping these specific lines, or what the structure of the contents are, it's not really possible to suggest the correct formula. Based strictly on your single example, you could perhaps use:

'Memory: ' & TextBetween(YourField,'Memory','scanner_dateofmanufacture')