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

RE: [sqr-users] Leading zeros in .CSV output

Not sure of the other post, but here's some snippets that would put a
numeric value into a .CSV with leading zeroes -- for example, the number
1234 would appear in the .CSV file as ="0000001234", which is the .CSV
syntax to treat the number as text:


!       For csv output

        let $Quote = '"'
        let $EqQuote = '="'

!   Create a value with leading zeroes

        move #Number_Value to $String_Value 0000000000

!   Output

        write 1 from $EqQuote $String_Value $Quote


-----Original Message-----
From: sqr-users-bounces+jbeller=lbisoftware.com@sqrug.org
[mailto:sqr-users-bounces+jbeller=lbisoftware.com@sqrug.org] On Behalf
Of Marc Kane
Sent: Thursday, March 15, 2007 8:17 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Leading zeros in .CSV output

I remember there being a post in the archive detailing the syntax of the
function (specific to .CSV output) to "pad" leading zeros.
I can't seem to find it, could anyone send me the link if they recall
the
post or send me the resolution.


-- 
Thank you,
M. Kane
Reports Developer (Crystal Reports/SQR)
PeopleSoft CIS Production Support
GES/New York, NY
702.349.5107

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


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