Replace values from existing list if the values have a close match

[Saravanan13]

Hello all,

I am working on validating data from pdf extract. The extract has issues when the document is handwritten. 

I want to keep common countries as a text input whenever the PDF extract value is close match  to common country list then the value should be replaced.

lets consider value in "expected value" as common country list. Can anyone assist on this.

PDF Extract	Expected value
HONG KONG G	HONG KONG
SINGAPORE E	SINGAPORE
CHINA AA	CHINA
INDONESIA AAAI	INDONESIA

[binuacs]

@Saravanan13 use the find and replace tool for this use-case

[Saravanan13]

@binuacs 

My apologies, There is a zip code along with the country. I need the output as expected value. Can you help..

PDF Extract	Expected value
HONG KONG G 5555	HONG KONG 5555
SINGAPORE E 33333	SINGAPORE 33333
CHINA AA 22222	CHINA 22222
INDONESIA AAAI 11111	INDONESIA 11111

[Saravanan13]

 sometimes even address will be there the extract, I need output as expected value

PDF Extract	Expected value
NO 9 HONG KONG G 5555	NO 9 HONG KONG 5555
SUITE 100 SINGAPORE E 33333	SUITE 100 SINGAPORE 33333
BLDG NO 111 CHINA AA 22222	BLDG NO 111 CHINA 22222
INDONESIA AAAI 11111	INDONESIA 11111

[binuacs]

@Saravanan13 In all the above scenario the find and replace should work, can you try?

[Saravanan13]

@binuacs 

I am getting only the country name replaced, I need rest of the fields as well

[Deano478]

You will need to use multiple Find and replace tools with different criteria as @binuacs said to accomplish this

[binuacs]

@Saravanan13 Try the updated the workflow

[Saravanan13]

@binuacs 

Thanks for the reply , It works perfectly but for one row, I have only country name, for that output is not accurate.

Can you help.

Pdf Extract	Expected output
NO 9 HONG KONG G 5555	NO 9 HONG KONG 5555
SUITE 100 SINGAPORE E 33333	SUITE 100 SINGAPORE 33333
BLDG NO 111 CHINA AA 22222	BLDG NO 111 CHINA 22222
INDONESIA AAAI 11111	INDONESIA 11111
HONGKONG G	HONGKONG G

[binuacs · Accepted solution]

@Saravanan13 updated the workflow