Keeping Leading Zeros in excel/CSV by peoplecode

Posted on by

Keeping Leading Zeros in excel/CSV by peoplecode

Keeping Leading Zeros in excel/CSV by peoplecode in app engine or AE. You can use below sql code before write file in peoplecode.

This syntax for convert number to text for solve issue leading zeros

‘=””‘|| REPORTS_TO ||'””‘ 

 

e.g.   select jb.emplid  ,’=”‘||jb.reports_to||'”‘ from ps_job jb

 

Ref: https://it.toolbox.com/question/writing-data-into-csv-file-through-app-engine-peoplecode-100112
Ref:http://www.compshack.com/peoplecode/leading-zero-issue-csvexcel-formatterd-report

Posted in Application Engine (AE), Peoplecode.