Manipulating Multiple Fixed-Width Columns for Outlook
Posted: Sat Aug 23, 2008 3:38 am
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
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