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

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

Expression

Accepted answers

binu_acs

@Saravanan13 updated the workflow

Country_271123.yxmd

All comments

binu_acs

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

Country_271123.yxmd

Saravanan13

@binu_acs

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

binu_acs

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

Saravanan13

@binu_acs

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

binu_acs

@Saravanan13 Try the updated the workflow

Country_271123.yxmd

Saravanan13

@binu_acs

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

binu_acs

@Saravanan13 updated the workflow

Country_271123.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703