Find a word in the whole table

[remi]

Hello all,

Want to search for a string of characters that begin always with a certain 3 characters but may vary in size.

e.g. IN-1; IN-99, IN-5644 etc, and also this type of info is in different columns that might have a different name or number (when you import the data it might have the same column name followed by _x, x is a number).

Is there any way to check the entire table for IN- or a big chunk of columns?

Thank you in advance!

[v-yulgu-msft · Accepted solution]

Hi @remi,

You can use Text.StartsWith to check if a value begins with "IN-".

=Text.StartsWith([A],"IN-")

For your requirement that to find specific text across multiple columns in whole table, what is the desired result if found? Can you show us an example?

Regards,

Yuliana Gu

[remi]

hello @v-yulgu-msft,

did it with a merge of all the columns in followed by a search of the IN-  with a fixed end, still looking for that dynamic size 

find chg0 = var BeginText = SEARCH("IN-", Data[Merged],1,BLANK())

RETURN IF(ISBLANK(BeginText),BLANK(), MID(Data[Merged], BeginText, 6))