Page 1 of 1

Want to convert fixed length into CSV

Posted: Fri Mar 18, 2005 3:20 am
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.

Posted: Wed Apr 06, 2005 11:16 am
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