Help

Automation To Find Exact String from Long Text List

Topic Labels: Automations
Solved
Jump to Solution
738 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Anthony_Cassel
4 - Data Explorer
4 - Data Explorer

I am trying to make a linking automation. Our records in Table 1 do not all exactly match records in Table 2. I am using an Long Text field to create a list of other numbers I would like the automation to look for when linking.

Anthony_Cassel_0-1683811018150.png

The problem is that using the Find Records function has the options to find a record that "is"(which wont work because im using a list) or "contains"(which will find records that dont exactly match. EX: 2118-1 will match with 2118-1.1 or 2118-11) Is there any ways around this?

Anthony_Cassel_1-1683811108914.png

 

 

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

The Find records action with "contains" is behaving as designed.

The workaround is to have a delimiter around your search string and to include that delimiter in your search.

For example, it looks like most (but not all) of your IDs are followed by a comma. If you could add a comma directly after all of the IDs, including the last one, you could then search for "contains" and include the comma. 

I actually don't like a comma in this case. I prefer to use two delimiters: one at the beginning and another at the end: [2118-1][2118-1.1][2118-11]. Then I have a formula field that tacks on the delimiters to the ID and use that formula field in the Find records.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

The Find records action with "contains" is behaving as designed.

The workaround is to have a delimiter around your search string and to include that delimiter in your search.

For example, it looks like most (but not all) of your IDs are followed by a comma. If you could add a comma directly after all of the IDs, including the last one, you could then search for "contains" and include the comma. 

I actually don't like a comma in this case. I prefer to use two delimiters: one at the beginning and another at the end: [2118-1][2118-1.1][2118-11]. Then I have a formula field that tacks on the delimiters to the ID and use that formula field in the Find records.

I think that would actually work perfectly. Youre a genius. I will give that a go. Thanks a ton.