SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to handle the values in CSV file - 033

KumarnklSep 14 2018 — edited Sep 15 2018

Hi All,

We are processing CSV file upload . Some field values are start with 0 (Zero) like 033, 08754, 0765

Need actual value with zero.

The CSV file open in the EXCEL. Then zero's are getting hide.

Since the CELL FORMAT are "General".

Is any suggestion on your side for this issues !!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2018

Added on Sep 14 2018

18 comments

1,590 views