Skip to main content
Solved

How to save a text file in delimited semicolon?


Forum|alt.badge.img+16
  • Hero (Customer)
  • 659 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

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+15
  • Superhero (Employee)
  • 168 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)
  • 659 replies
  • June 29, 2023

@Ben Monroe Appreciated.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings