I have written a k shell program which is executing a sql and exporting data in numeric form like 0412323444 into .csv file. the problem i am facing is that , the data is coming in excel formatted in scientific form like 4.1+E08,while my requirement is to store data as such 0412323444 in excel ( no other extra character like '(single quote) or double quote.
please help me in this regard
Something I discovered way back when...
export data in the following pattern:
="Need to know",="0123456",="0101010"
The combination of the = and the " " cause Excel to store data specifically as text.
Joeyg,
it is true that appending some character convert number into text and can be stored in the .csv format .but what is required i have to export number as such in the excel without any extra character .
if the number is 041008.it should be exported as 041008 in the excel.
is there any way we can do this through shell script.
If your k-shell script is writing the data (confused by your follow-up note) in csv format so that it can later (or in next step) be read by Excel, then write it as I described.
="Need to know",="0123456",="0101010"
="howdy there",="0028410",="0001313"
and so on.
What does the current csv file look like? Please supply a small piece, or a few lines.
Actually I am running a sql commnad which is selecting numeric data from a database table ,i am exporting this data in .csv file.
The database table is containing data like
04567891245645
01234583445674
08967565678565
What .csv file is generating is
4.5+E10
1.2+E8
8.9+E8
the .csv file is automatically taking in scienific format.
while my requirement is to store data in .csv file in form of
04567891245645
01234583445674
08967565678565
(no extra quote or character)
You want the csv file to consist of:
="04567891245645"
="01234583445674"
="08967565678565"
Then, when opened by Excel, it will be fine.
The csv file is not storing - at least I don't think so
Thus, my request to see the contents of the csv file and not what Excel is reading.
A couple of lines would suffice.
(I had to write an intermediate script to do what I am proposing for a similar matter.)