Manipulating Multiple Fixed-Width Columns for Outlook

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
affering
Posts: 1
Joined: Sat Aug 23, 2008 2:25 am

Manipulating Multiple Fixed-Width Columns for Outlook

Post 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
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Manipulating Multiple Fixed-Width Columns for Outlook

Post 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"
Post Reply