Export To CSV

[azmeerrehan]

I have Employee ID  like '0012345677' , it has leading zeroes in it.  When I export it to Excel its fine but exporting as a CSV looses the leading 0's.  I need the leading 0's when exporting to CSV.  (QV 12))

Have already tried num(exployee ID, '0000000000')

Any suggestions

[olivierrobin]

hello

and what about using text() function ?

[azmeerrehan]

how does Txt function work

[olivierrobin]

Text() forces the expression to be treated as text, even if a numeric interpretation is possible.

Text (expr)

[azmeerrehan]

Doesnt work, still dropping out the leading 0's

[Frank_Hartmann]

this link might be helpful:

Keeping Leading Zero in Export

[olivierrobin]

try this

text(num(your column,'0000000'))

adjust the format according to your needs