Skip to main content
Solved

How to save a text file in delimited semicolon?

  • June 28, 2023
  • 2 replies
  • 144 views

Forum|alt.badge.img+16
  • Hero (Customer)
  • 671 replies

Community,

 

question, how to save a text file in delimited semicolon? Excel does not have this option as far as I learnt.

 

Thank you.

 

Best answer by Ben Monroe

Hi ronhu,

You need to save as CSV format.
CSV is an abbreviation for [c]omma-[s]eparated-[v]alue.
However, instead of a comma, you need a semicolon.
So you need to configure it as needed.

  1. Open File / Options.
  2. Clear "Use system separators".
  3. Set Decimal separator to comma (,).
  4. Set Thousands separator to period (.).
  5. Click OK.
  6. File / Save As. Change "Save as type" to CSV, and Save.

Now if you open the file in a text editor, you'll see that the fields are separated by semicolons.

Best regards, Ben

2 replies

Forum|alt.badge.img+15
  • Superhero (Employee)
  • 182 replies
  • Answer
  • June 29, 2023

Hi ronhu,

You need to save as CSV format.
CSV is an abbreviation for [c]omma-[s]eparated-[v]alue.
However, instead of a comma, you need a semicolon.
So you need to configure it as needed.

  1. Open File / Options.
  2. Clear "Use system separators".
  3. Set Decimal separator to comma (,).
  4. Set Thousands separator to period (.).
  5. Click OK.
  6. File / Save As. Change "Save as type" to CSV, and Save.

Now if you open the file in a text editor, you'll see that the fields are separated by semicolons.

Best regards, Ben


Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • 671 replies
  • June 29, 2023

@Ben Monroe Appreciated.