search for a string match in the whole column for each item from another column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have a workflow where I have DATA column containing document number and TEXT column with a string where this document number can be found as a part of a string. I need to check all the fields in column TEXT to check if in the string I can find document number from column DATA.
I am not searching for line by line check but the whole TEXT column range for each cell in column DATA.
I would appreciate if anyone could help on that.
Best Regards
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @u1070365,
You need to use this formula:
FindString( [TEXT],[DATA])
You will get 0 if you got a match and -1 if not.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
in addition to @Emil_Kos 's solution - you can use a filter tool with a Contains function
That would filter out all the rows that have this particular text in them.
e.g. contains([my field], 'Cat')
