I need to scrap data from a text file which looks like junk[but it is actually data extracted from OCR ID card].Now I want to transform it to structured Excel file with the Name,ID card number,Nationality etc..Plz help me in this

United Arab Emirates
Resident Identity Card
المتحدة العربية الإمارات دولة
مقيم هوية بطاقة
ID Number / الهوية رقم
784-1986-3293540-3
اوباكو لوبيز الإسم:رينى
:Name Renee Lopez Opaco
الفلبين الجنسية:
:Nationality Philippines
م
.

Hi @Anu_B

Welcome to our UiPath Forum! :slight_smile:

You should try some regex manipulations, maybe?
See here for some hints: Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

1 Like

Hi @Anu_B

I have created a workflow to help you with your process.
Main.xaml (11.7 KB)
image

You can check the ‘Pattern’ property on each ‘Matches’ to view the Regex Patterns I have used.
image

Hopefully you find this helpful :blush:

Kind regards

Steve

1 Like