Wednesday, April 29, 2009

SQR: Keeping leading zeros in CSV file

Add '=" to the fild such as emplid or business unit in order to keep leading zeros in sqr generated CSV file as example below:
Write #OutFile_xls From
'='
'
$EmplID
'",="'
$business_unit
','
$empl_rcd
','
$Field
','
$Errmsg
'