General information
Category:
Coding, syntax & commands
>I have a text file that I have to parse into a table. There are around
>47,000 lines in it.
>
>I don't have a file layout, but it is asteriCk-delimited as in:
>
>
>NOISAT, MARY *Z7700286-31*31.75**27.18*092600*G0001*0301**1*300*300***0*300*
>
>
>There are 2 problems here:
>
>1. I don't know the layout
>
>2. Some of the lines are VERY long, upwards of 800-1000 characters
>in length.
>
>If I can determine the length of the longest line, I can use OCCURS() to
>determine the number of asteriks in that line, and from that determine
>the number of columns to create.
>
>So I appended it into a memo field, then I ran this little program:
>
>
> SET MEMOWIDTH TO 8192
>
> USE Temp1
>
> nLineNo = 0
> nTotLines = MEMLINES(DataField)
> nMaxLen = 0
> nLongest = 0
>
> FOR nLineNo = 1 TO nTotLines
>
> cString = ALLTRIM(MLINE(Data, nLineNo))
>
> IF LEN(cString) > nMaxLen
> nMaxLen = LEN(cString)
> nLongest = nLineNo
> ENDIF
>
> ENDFOR
>
>
>The problem is, this program take FOREVER to run, literally HOURS! I need
>a simpler solution.
>
>TIA
append from c:\temp\test.txt type deli with charac "*"
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only