[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Reading file into SQR



Hi
I have a text file that I am reading in through sqr.
Now the format of the text file has changed and the file is not reading
properly and not updating the tables. Do i need to modify the program. Any
pointers would be of much helpful to me.

Here is the piece of code:
while 1 = 1
    read 1 into $recorddata:1000
    let $recorddata = upper($recorddata)
    EVALUATE $recorddata
        when = 'SSN:'
        read 1 into $recorddata:1000
        LET $N_SSN = upper($recorddata)
        BREAK

My text file previous was looking like this for SSN:
SSN:
999-99-9999

But now my text file looks like this
999-99-9999
SSN:

Similarly someother fields got rearranged like these.

Need advice

thnx
cvijay

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users