Delimiting a Mainframe file

[manrique83]

I am fairly new to programming. Is there a way to delimit the following record by position, or how should I go. The mainframe file is being FTP'd to my machine, VB.net program reads it and for reporting purposes I need the 828, 804 field, can anyone help in how to put this into an array, structured or not.

000107561756A083C20 YAHOO ON AND TRUCKING****828
000107561756A301A20 GOOGLE N ARCHITECTURE*** 804

 

[zemp]

manrique83, first off welcome to Tek-tips. When you have time take a look at faq222-2244 on how to get the most from these forums.

If you are using VB.Net you should post in the VB.Net forum. Try forum796.

zemp

 

[jebenson]

To get the best response to this question, I suggest you post it in the VB .NET forum: forum796

One thought though - if the field you need is always the last 3 characters of each line, you can do this:

Dim sField as string

sField = Mid(sInput, Len(sInput)-3)

Where sInput is a string holding a single line of input from the text file. You probably want to make sField an array; I just did this quickly, to give you a starting point.


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson