Hi team, Trying to push a string value which has p...
# suitescripts
SMNCP
09/01/2020, 7:03 AMHi team, Trying to push a string value which has preceding zeroes (eg: x= "000015373") into a csv file. And the preceding zeroes were discarded, Hence enclosed the string with quotations ("\""+x+"\"").
This resulted in pushing correct value into the csv. But when the file is viewed in notepad, it appears as """000015373""".
Any ideas of what is the issue and how to rectify it ?
b
battk
09/01/2020, 1:21 PMif you want the csv value to be "000015373", then the raw csv column value """000015373""" is the value
battk
09/01/2020, 1:21 PMone layer of quotes is for the escape mechanism
battk
09/01/2020, 1:22 PManother layer of quotes is to escape the escape character
battk
09/01/2020, 1:24 PMyou can go through the csv rfc for more detail, usually rfcs are painfully boring, but this one is pretty short
3 Views