AnsweredAssumed Answered

Leading Zeros in CSV

Question asked by Krupa.r on Mar 24, 2016
Latest reply on Mar 24, 2016 by Michael Thibault

Hi There,


I am writing to a CSV file. One of the column is alphanumeric but some of the values in it are just numbers starting with zeros eg., 000128xxxx. When I write to the file, i want to retain these leading zeros. I have tried double quotes, single quote, Lpad, prepending =" ", adding to_char while retrieving data, prepending blank space etc. I am unable to achieve desired output. This output csv file will manually be compared/pivoted with another excel where this number is stored as text.  So, I have to retain the zeros and possibly store it as text without any additional characters being displayed. How can this be handled?


Thanks !