I am trying to extract merchant statement which is under txt format to UIpath data table using Regex activity. I could extracted some columns highlighted in red color in below image and I stored data in UIpath data table created called “merchant_Reportdb”
However, I also need to get the “Merchant Number” to same data table as a new column.
which is highlighted in yellow color. Further, the extracted merchant number should be copied under new column call “Merchant ID” and it has to be repeat according to the row counts
Card Number Merchant ID
Thanks in advance
BlankProcess1.zip (9.2 KB)