Want to convert fixed length into CSV

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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: 2174
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

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

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: Majestic-12 [Bot], Yahoo [Bot] and 12 guests