We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Changing comma to pipe

asked 2021-06-10 18:05:23 +0200

stijnscheper gravatar image


I have an export from my website, and i have a couple (3000) text that are separated with a comma, but i need to separate it with a pipe this: | Is there a way to get it to do this? So to be clear I do not want de separator of the file to change but the text insight the file.

edit retag flag offensive close merge delete


Please make your request clearer.

Are you trying to change a "plain text" file (usual extension .txt) or to manipulate a formatted text?

In both cases if it is only a matter of replacing a comma with a vertical bar, use the replace or Find&Replace command of the application.

Explain where Writer is specifically concerned. In any case, mention your OS name and LO version.

Please do not use Add Answer but edit your original question to enhance the details of your question (answers are reserved for solutions to a problem on this Q&A site).

ajlittoz gravatar imageajlittoz ( 2021-06-10 18:10:41 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-06-10 18:17:38 +0200

Opaque gravatar image

updated 2021-06-10 18:18:07 +0200


yes - use Edit -> Find and Replace

  • Make a copy of your document (if something goes wrong)
  • Open the copy
  • Edit -> Find and Replace
    Find: ,
    Replace: |
    Assure that option [ ] Regular expressions is not set
  • Click button Find all to check and if the , (commas) found are OK for being replaced
  • Click button Replace All

Hope that helps.

edit flag offensive delete link more


Thank you! This solves the problem.

stijnscheper gravatar imagestijnscheper ( 2021-06-10 18:49:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-06-10 18:05:23 +0200

Seen: 23 times

Last updated: Jun 10