[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
- Subject: [sqr-users] Reading file into SQR
- From: "ViJaYaNaNd gMaiL" <grvijay@gmail.com>
- Date: Fri, 14 Jul 2006 16:56:32 -0500
- Delivery-date: Fri, 14 Jul 2006 17:58:26 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;h=received:message-id:date:from:to:subject:mime-version:content-type;b=LBPZ/Yu5SCPf2GQBHQy8i7vGWoyCCHA7dC7guIrqjubM8fELv8ur8Vbi6LDf14uA27ghvA2/GRymgg/y+u4zvVzEsMZZfxg1kzVpDHL6Evpeafy78JNoSumn7N3J+sUvb5PqcwSiVcWt6iYo5xlmbA/s9tFKwlHszr4AK53oFhA=
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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