[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] How to extract data in an SQR
- Subject: [sqr-users] How to extract data in an SQR
- From: Kaz.Narayanan@averydennison.com
- Date: Thu, 2 Dec 2004 13:37:02 -0800
- Delivery-date: Thu, 02 Dec 2004 16:45:10 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Sensitivity:
Hi,
I want to extract an amount field from a data set like this below:
IV*14625458**23.17*23.4*.23\
DL*13377031PRGCB*PO*-25735.33*-25735.33*0\
I want to only extract the amount of 23.17 in the first line and
-25735.33 in the 2nd line.
Only logical construct here is that these amounts always comes after the
3rd '* '
in the data set.
Could anyone help please?
Thanks
Regards
KM Narayanan
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users