CSV & open by excel

[Slobodan Naglic]

My CSV file has data like:

"Text";"10711";"REZ";"11";"0";"46";"107466";"24,05";"4600";"1750"
"Text";"10711";"REZ";"11";"0";"46";"107466";"24.05";"4600";"1750"

When double clicked the file is opened with excel like (one column is
handled as if there is DATA value):

Text 10711 REZ 11 0 46 107466 24.MAY 4600 1750
Text 10711 REZ 11 0 46 107466 24.MAY 4600 1750


Id there a syntax to prevent this behavior?

TIA

 

[Bruce Sinclair]

My CSV file has data like:

"Text";"10711";"REZ";"11";"0";"46";"107466";"24,05";"4600";"1750"
"Text";"10711";"REZ";"11";"0";"46";"107466";"24.05";"4600";"1750"

When double clicked the file is opened with excel like (one column is
handled as if there is DATA value):

Text 10711 REZ 11 0 46 107466 24.MAY 4600 1750
Text 10711 REZ 11 0 46 107466 24.MAY 4600 1750


Id there a syntax to prevent this behavior?

Not sure exactly what the problem is here, but instead of double clicking
the file, open XL and import the file using the wizard. You get a heap of
very useful options (including what separators you want to use) there that
will probably help you do what you want.

HTH

 

[Slobodan Naglic]

Problem is that my data is enclosed to be pure text data and it is
interpreted as if there are no any " arround.



CSV data:

"Text";"10711";"REZ";"11";"0";"46";"107466";"24,05";"4600";"1750"
"Text";"10711";"REZ";"11";"0";"46";"107466";"24.05";"4600";"1750"



and this becomes displayed as:

Text 10711 REZ 11 0 46 107466 24.MAY 4600 1750
Text 10711 REZ 11 0 46 107466 24.MAY 4600 1750

 

[joeu2004]

Problem is that my data is enclosed to be pure text data and it is
interpreted as if there are no any " arround.

Sorry to say, but that is the way Excel works.

To avoid that, do not open the CSV file directly.

Instead, start Excel by double-clicking the Excel icon (not the file
icon).

Then use the Text Import Wizard. In XL2003, click on Data > Import
External Data > Import Data.

In the Text Import Wizard, click Delimited, Next, select Comma (or
Semicolon), and click Next. In that last menu, select each colum that
you want treated as text, and select Text.

It is tedious, but it might do what you want.

 

[Slobodan Naglic]

Thank you,
my problem is that I must distribute CSV file and I'm not shure how users
will open file.
And I am shure that they will not know which data will be corrupted (

Problem is that my data is enclosed to be pure text data and it is
interpreted as if there are no any " arround.

Sorry to say, but that is the way Excel works.

To avoid that, do not open the CSV file directly.

Instead, start Excel by double-clicking the Excel icon (not the file
icon).

Then use the Text Import Wizard. In XL2003, click on Data > Import
External Data > Import Data.

In the Text Import Wizard, click Delimited, Next, select Comma (or
Semicolon), and click Next. In that last menu, select each colum that
you want treated as text, and select Text.

It is tedious, but it might do what you want.

 

[Slobodan Naglic]

SW that produces file is old DOS.
It does not write to the excel (

 

[Bruce Sinclair]

Thank you,
my problem is that I must distribute CSV file and I'm not shure how users
will open file.
And I am shure that they will not know which data will be corrupted (

... then you don't have an XL problem here.

Why do you have to send out the csv file instead of an XL file ? If you send
it out as an XL file (eg), you will be (fairly) certain how it will open ...
and that they'll see what you want them to see. There are XL viewers or open
office available for those that don't have XL.
Alternatively, if as I suspect you want the whole line of data as one line
of text, why not send the data as a text file ?

I guess the real question here is ... what exactly do you need to do ... and
what are the limitations you have to work within ?

 

[Bruce Sinclair]

SW that produces file is old DOS.
It does not write to the excel (

Ah right. OK.
If that's the case,maybe you can open it in XL, get it looking like you want
it to look then send it out as an XL file ? A bit lees easy for you, but
probably more useful for the others it has to go to ?