Getting problem in Parse Excel Spreadsheet to CDT smart service

bhanuprakashm over 7 years ago

Hi All,
I am using "Parse Excel Spreadsheet to CDT" smart service..when i was upload the excel one of the column values contains "800001058" ,"800001058","800001058" like this.

so i am stored this values into text datatype column in cdt..but it coming like "8.000011e+08" from smart node.(before storing into db)

Can you please help me in this..

Discussion posts and replies are publicly visible

Parents

+1 bhanuprakashm over 7 years ago

Thanks, my issue is resolved..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Mihai-Octavian Tudose
Certified Lead Developer
over 7 years ago in reply to bhanuprakashm

Hello, can you please give me some input into how you were able to overcome this issue? Thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandu
A Score Level 2
over 7 years ago in reply to Mihai-Octavian Tudose

I would like to suggest the solution provided by Venkat Kondeti is good one, One more way is like select the entire column and format the cells to Text and save the excel sheet instead of formatting each cell. Saving this type of values in text is good approach.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 chandu
A Score Level 2
over 7 years ago in reply to Mihai-Octavian Tudose

I would like to suggest the solution provided by Venkat Kondeti is good one, One more way is like select the entire column and format the cells to Text and save the excel sheet instead of formatting each cell. Saving this type of values in text is good approach.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data