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

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
Post Reply