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.
Want to convert fixed length into CSV
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2229
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
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
2. Use two line restricitons - one for the first line, and one for the last line
Regards,
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
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