Manipulating Multiple Fixed-Width Columns for Outlook

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Manipulating Multiple Fixed-Width Columns for Outlook

Postby affering » 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

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Manipulating Multiple Fixed-Width Columns for Outlook

Postby DataMystic Support » Sun Aug 24, 2008 9:59 pm

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"
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 2 guests