database to fix length field csv

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

billiard

database to fix length field csv

Postby billiard » Sat Sep 03, 2005 6:27 pm

Can I take a text file or access database and parse it into a fixed field length csv text file, defining the field sizes for each column?

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

Postby DataMystic Support » Wed Sep 14, 2005 3:00 pm

Yes, use the Restrict to Delimited field (CSV) once for each column, and inside each, use a Pad to Width filter.
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 1 guest