• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

Is there a utility to parse a fixed length string?

I don't know if this is the right area to ask this question but here goes.

I don't have VB - but I guess I can get hold of compiled VB programmes that will run (I do have M$ Office and can run VBA).

I have a number of individual fixed length record strings (approx 7,500 chara's).
I don't have yet, but will have, the record mapping - I believe I'll need approx 50 fields from the string.
I'd like to map these fields onto several rows so that they look like a conventional ascii report within say 180 chara width.
Is there a VB utility in existance that allows a non VB programmer to specify the field locations from a long record string and allow some sort of mapping to an output file?

0
capital052798
Asked:
capital052798
  • 2
1 Solution
 
jsimoniCommented:
if i understand your question correctly, you should use MS Access which comes with Office.  You can import your files into Access.  You can then use the Access Report Wizard to create your layout of your ASCII text file.  Once this is complete you can Export your report to a text file.
0
 
woodsrrCommented:
Use Excel:

1. Do a file open
2. Point to the file

Excel will popup the Text Import Wizard
You can now import the data using delimited or fixed width.

From what you have descriped, you will use fixed width.
0
 
capital052798Author Commented:
mmm
I actually use the Access function you talk about quite a bit BUT I just wonder if Access can cope with 7,500 chara's - I assumed it didn't but I'll give it a try.
0
 
capital052798Author Commented:
To my surprise MS Access was able to do the job - I would still have liked a compiled routine thoug because I need this to run on machines that don't have MS Office.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now