Sorry if this sounds confusing or if the answer is already on the forum! I tried searching buy can't figure out what I should really even search for! I'm hoping someone can help me though!
I receive multiple pdf's a day that contain data that now needs to be put into a system. I need to take the data and put it into certain columns for exporting. The problem is, when I convert the pdf, it makes each "company" take up 3 lines (so its not just reordering the data or text-to-columns!).
I suppose an example would help!
(MY FORMATING DOES NOT WORK IN THIS PAGE, YOU CAN SEE MY EXAMPLE THAT I UPLOADED!)
(codes)
Company Name Contact Name 08210 - Wood Doors
889 East Main Street Tel: 920-999-2222 08300 - Special Doors
Fond du Lac, WI 54935 Fax: 920-999-2211 09660 - Resilient Flooring/Vinyl
11042 - Baptisteries
13230 - Digester Cover & Appurtenance
15400 - Plumbing
Other Company Name Support Team 18000 - Builders Exchange
889 West Main Street Tel: 920-999-1111
City, WI 55555 Fax: 920-999-1122
The order of what I need is this:
Contact Name | Company Name | Address | City | State | Zip | Phone | Fax | Code (without description, so just first 5 numbers)
The number of codes will change every time! I can still handle if the codes are on seperate lines as long as there isn't any information to the left of them! Any help with this would be great! (Even if you know of a program that could do this (doesn't matter if its free or not!))
I attached a sample file!
Thanks a ton!
Bookmarks