Want to convert fixed length into CSV

Get help with installation and running here.

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

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

Want to convert fixed length into CSV

Post by dilbert2000 »

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

Post by DataMystic Support »

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, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
Post Reply