[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Number to Character
- Subject: [sqr-users] Number to Character
- From: "PeterG Clark" <PeterG.Clark@vac-acc.gc.ca>
- Date: Wed, 04 Oct 2006 11:58:27 -0300
- Delivery-date: Wed, 04 Oct 2006 11:01:29 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi folks,
Normally, this would be the sort of thing I would like to play with until I got
it working, but I am pressed for time and turning to the tremendous knowledge
base on this list :-)
I have a Number(25) field on a table (Oracle) that I know will never contain
more than three significant digits (i.e. 999) and I need to get it into a 3
character field on a flatfile ... i.e. if the column contains 7, I need to put
007 in the flatfile field, if it contains 29, I need 029 to be in the flatfile
field, 0 needs to be 000, 567 needs to be 567, etc.
Anything I've tried with edits, to_char's, pads and trims isn't working ... or
at least I am not hitting the right combination.
Thanks in advance.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users