topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday March 29, 2024, 8:07 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: View fixed length record files  (Read 3522 times)

dluby

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 253
    • View Profile
    • Donate to Member
View fixed length record files
« on: July 11, 2009, 07:19 AM »
Hi,

I was wondering if anyone knows of a simple way of opening fixed length files and viewing the contents (records/fields) easily?

I know Excel allows this to be done, but I'd like a method to define the layout as a template and to be able to load the file based on a template.

Any ideas?

Thanks

Damian

40hz

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 11,857
    • View Profile
    • Donate to Member
Re: View fixed length record files
« Reply #1 on: July 11, 2009, 01:39 PM »
Excel should be able to do that for you.

You can use the query wizard in Excel to "massage" the data in a file prior to bringing into your spreadsheet. Queries can be saved for reuse.

You can then create custom reports from your data and save those reports as templates.


fenixproductions

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,186
    • View Profile
    • Donate to Member
Re: View fixed length record files
« Reply #2 on: July 11, 2009, 02:19 PM »
2dluby
The simplest method I know is to use CSVed application from:
http://csved.sjfrancke.nl/

Unfortunately, it has limited "templates" functionality (each line represents one row) so it might not suit you.