I am looking to automate the name, address, pincode, phone details seperation from a jumbled non standard data templates. Above elements are part of one cell, but in no specific order or content. General Text to Columns, left, right, mid, would not work straight forward.
Also need a small program to open pdfs (invoices) as named in one excel column and copy product number from adjacent column to paste on the opened pdf at specific location. The updated PDF with serial number should be saved seperately.
Copyright © 2021 | Truelancer.com