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 |
解決済! 解決策の投稿を見る。
@Saravanan13 use the find and replace tool for this use-case
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 |
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 |
@Saravanan13 In all the above scenario the find and replace should work, can you try?
You will need to use multiple Find and replace tools with different criteria as @binuacs said to accomplish this
@Saravanan13 Try the updated the workflow
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 |
@Saravanan13 updated the workflow