Page 1 of 1

Manipulating Multiple Fixed-Width Columns for Outlook

Posted: Sat Aug 23, 2008 3:38 am
by affering
Hello,
I am trying to manipulate a company database (fixed-length record format) in order to input its selected contents into Outlook. Each column has a defined/delimited width, but each column entry has varying length as shown below. I am not sure what is the best approach to convert this for an Outlook import.

I could not find a working filter (convert) that would convert this to "Comma Separated Values" or "Tab Separated Values". Should I use the "add filters" to add characters (") to format this? This may be trivial, but unfortunately I am beginning to learn this tool. Your help will be appreciated.

Original Data:
00290056 ROBINSON IMPROVEMENT COMPANY ADOMP
003110 MAYES PRINTING COMPANY ADOMP
003860000THE MONTICELLO COMPANIES, INC. ADOMP
0051200 HOPKINS-CARTER COMPANY ADOMP
007430 NACM TAMPA, INC. ADOMP
00954000 LONCALA, INCORPORATED ADOMP
0099700000THE UMATILLA FRUIT COMPANY ADOMP

Expected Data:
"00290056","ROBINSON IMPROVEMENT COMPANY","ADOMP"
"003110","MAYES PRINTING COMPANY","ADOMP"
"003860000","THE MONTICELLO COMPANIES, INC.","ADOMP"
"0051200","HOPKINS-CARTER COMPANY","ADOMP"
"007430","NACM TAMPA, INC.","ADOMP"
"00954000","LONCALA, INCORPORATED","ADOMP"
"0099700000","THE UMATILLA FRUIT COMPANY","ADOMP"

Thank you for your time and I hope to hear from you soon with a favorable response.

Affering

Re: Manipulating Multiple Fixed-Width Columns for Outlook

Posted: Sun Aug 24, 2008 9:59 pm
by DataMystic Support
You could use the EasyPattern

Code: Select all

[capture(1+ digits) as 'id'] [capture(1+ chars) as 'name'] [capture('ADOMP') as 'code']
Replace with:

Code: Select all

"@id1","@name","@code"