Inputing a Text File

[msebastian]

I'm going crazy trying to figure this out. I have a text file where I have to take certain information out of and put it in a database and I have no idea how to do it because it doesn't follow any set pattern.
Its pretty much in this format:

1 SUPER MVS/PDF FILE/LINE/WORD/BYTE/SFOR COMPARE UTILITY - V4.20(ISPF) 00/11/09 14.05 PAGE 1
LINE-# SOURCE SECTION SRCH DSN: PBUN.PROCLIB


AC002UW <<-------- I need this

67 //DIAIN DD DSN=&CTLCARD(AC002UWA),
164 //SYSIN DD DSN=&CTLCARD(AC002UWB),
238 //SYSIN DD DSN=&CTLCARD(UT300UDA),DISP=SHR
And all this stuff in brackets in the next 3 lines, Any Ideas?

[chrisfricke]

since it looks like the only brackets in the line are around the data you want you could do something like this

Line Input #Fileid,Tempstring
StuffIWant=mid(tempstring,instr(tempstring,"(")+1,instrrev(tempstring,")")-1)


This may work or may need a bit of tweaking

Cheers

Chris