Find and Replace in a Loop

[Sanjay_TVA]

HI ,

I have two sources, one contains records along with state, the second source is a lookup file which contains all the information along with states, districts, so and so.

What I need to do is from the source I have to take state column and match up with the lookup state column and get the districts which are in that state alone for that particular record and then use find and replace it with that address column to get that corresponding districts.

The Source File:

The Lookup File:

For each records I have to do it in a looping manner and take that respective districts alone for consideration and then find and replace for that group alone for each records.

P.S: I cannot use all the districts for find and replace because it affects the integrity of the data and I tried unique in lookup and find and replace but that doesn't work too!

[Sanjay_TVA]

Instead of using a  a formula tool with regex pattern we can also use another find and replace to generate states based on lookup.

This one works good but did not matchup the loop question? This workflow gets states and districts and then joined to match up the integrity of data but what I need is instead of this method is there anyway for that find and replace to use particular districts for single records based on the found state and repeat the process for every records.

Sorry for complexity level !😶

[Sanjay_TVA]

Hi Team ,

I have a new idea in mind as you see I have grouped the states and concat the districts in a single row to save up the space.

 

Now all I have to do is just check whether that district is present in address, I tried find and replace ,contains nothing is matching!! 

Is there anyway to partial match separated by commas.?