Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • December 03, 2016, 09:59:51 PM
  • Proudly celebrating 10 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 2014 times)

dluby

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 220
    • View Profile
    • Donate to Member
View fixed length record files
« on: July 11, 2009, 07:19:50 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,768
    • View Profile
    • Donate to Member
Re: View fixed length record files
« Reply #1 on: July 11, 2009, 01:39:36 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,184
    • View Profile
    • Donate to Member
Re: View fixed length record files
« Reply #2 on: July 11, 2009, 02:19:49 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.