Menu
I have a text file in this format :
{ attribute1 attribute2 attribute3.... attributeN value"A" value"B" value"C".... value"Z" /* next line of values*/ } Each word is separated by a tab.
How do I convert to CSV format? I tried using Excel but it's giving compatibility issues.
442
Select one or more lines you want to convert, or simply press Ctrl+A to select all lines. Open the File menu and choose 'Save Selected Items', or simply press Ctrl+S. From the 'Save as type' combo-box select 'Comma Delimited Text File' and ,choose or type the filename to save, and then click the 'Save' button.
Change separator when saving Excel file as CSV Click File > Options > Advanced. Under Editing options, clear the Use system separators check box. Change the default Decimal separator. As this will change the way decimal numbers are displayed in your worksheets, choose a different Thousands separator to avoid confusion.
Import the data with excel (Data > Load from text file), using tab as a column separator. Then save the file as csv.
It cannot have compatibility issues, it's a basic task and i did it quite often in the past.
59
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
