Issue with Comma in String

[Karim_Khan]

Hi Team,

    My code is working fine in QlikView but whenever am trying to save the values into xls,csv its giving me wrong o/p

My Current O/P:

90,513,213,422,491,200

My Expected O/P:

9051321342,2491233

In QlikView its showing as  9051321342,2491233 but whenever trying to save this in xls,csv format O/P gets changed I have tried to convert the value into text but no use if its a Single Mobile Number then No issue if multiple Contacts are there then issue occur?

Regards,

KK

[passionate]

Set the format of column in Qlikview to whatever expected

like num(Cloumn,'##########,#######')

[m_woolf]

Try opening the .csv in notepad or Notepad++ to see if the data is correct in the file.

Excel may be formatting the data when you open the file.

[Karim_Khan]

Issue is coming while storing it into xls.if I will use ur logic i will convert all values into comma separated