Want to convert fixed length into CSV

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

dilbert2000
Posts: 1
Joined: Fri Mar 18, 2005 3:10 am

Want to convert fixed length into CSV

Postby dilbert2000 » Fri Mar 18, 2005 3:20 am

I would appreciate it if you could point me in the right direction. I have a file that consists of 120 byte records containing fixed length fields. What do I need to do to convert this file into individual fields in CSV format.
Also how do I process the first and last line differently?

Thanks for the help.

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

Postby DataMystic Support » Wed Apr 06, 2005 11:16 am

1. Use the Filters\Add\Insert columns filter to add commas between tghe fields.

2. Use two line restricitons - one for the first line, and one for the last line
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 7 guests