• This forum is the machine-generated translation of www.cad3d.it/forum1 - the Italian design community. Several terms are not translated correctly.

export tables in csv

  • Thread starter Thread starter Daniele-san
  • Start date Start date

Daniele-san

Guest
Hi.
is it possible through particular settings to replace the comma with another symbol for exporting a table in csv?
Unfortunately the comma being present sometimes even in the descriptions, split the text by entering the next part to the comma in the next box
Thank you.
Hi.
 
when a field of proe has comma, in the csv this field is enclosed by quotes.
which software must analyze such csv?
if the csv amounts it in excel, just select as "text trainer" the character of the quotes.
 
when a field of proe has comma, in the csv this field is enclosed by quotes.
which software must analyze such csv?
if the csv amounts it in excel, just select as "text trainer" the character of the quotes.
thanks to the intervention
Maybe I couldn't explain myself well.
exporting a table in csv proe automatically inserts the commas to delimite the voices of each single cell... but if the commas are already present in a voice (example description of a component es: screw m2.5x3 etc.) I find this comma in the csv file and then importing it into sap (our management system) recognizes the comma as a partition then splits the text es m2 into a cell and 5x3 into the next one.
importing the file with excel and indicating the comma as a partition behaves the same way so I wanted to know if it is possible to replace the comma by acting on configuration files or other.
 
Yes I understood, I missed the passage in sap (on which I can not help you).

for excel I tried, if from the "text limiter" the comma and "qualified of text" quotes, should import it well (from me it works, excel 2010)
Hi.
 

Forum statistics

Threads
44,997
Messages
339,767
Members
4
Latest member
ibt

Members online

No members online now.
Back
Top