Hi all,
I have a column called case_number, is in Varchar(255) in DB and CDT for this column is TEXT format.
The data is like 00002555534243 or 000034215334 etc.
Once I export this column from CDT to CSV file format. the leading zero is not shows up in CSV file.
What would be the solution for this?
Thanks!
Discussion posts and replies are publicly visible
I can't be sure, but I expect you're describing the behavior of MS Excel.
Have a look at this: https://www.youtube.com/watch?v=9KDK1FRcmSo
If you choose your delimiter as Pipe or Semicolon the leading zeroes will be preserved.