Hi all,
I have the requirement as follows.
I will be reading values from csv file which will look similar to below.
A B C
1 (5) 5
(2) (3) (8)
2 (1) 8
when the file is opened through ms excel the values in the bracket are getting converted as -5,-2-3-8 and -1. But when i open it with notepad the values are as follows 1,(5),5,(2),(3),(8),2,(1),8.
The requirement now is i should read the csv file and populate the values to table. When i use the str2num method to read the values i'm getting the values as 0 which are inside the bracket. When i populate the table the values that are inside the bracket should be inserted as e.g if i read (5) then the value should be inserted as -5 in the table.
And also can you tell me why i'm getting correct values in ms excel i.e as -5 for (5) and not getting same result in notepad or notepad++.
Thanks.
*This post is locked for comments
I have the same question (0)
