PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

SQR - Output CSV with leading 0s question - Tools 8.59.03

Hello,

I am trying to output a CSV and maintain the leading 0s on employee IDs, I was able to successfully maintain the 0s by using this code:

let $emplid = '="' || $emplid || '"'

but when the CSV is pulled in by the vendor, their program is grabbing ="000001" because while the CSV displays just the numbers, the data itself has =" " included. So I'm wondering if anyone has figured out how to output a CSV and maintain the leading zeros without using the above method.


Thanks,

Jeff

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center