User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
Saving to a tab delimited text
2 posts
• Page 1 of 1
Saving to a tab delimited text
by Peter Zanette » Wed Feb 13, 2019 7:43 am
I can save to a csv file. Then I change the csv extension to txt Then I open the file in Writer. I am unable to convert the commas to tabs in find replace dialog box. Find is , and replace is \t. It doesn't work for me.
OpenOffice 4.1.6 on Windows 10 Pro
- Peter Zanette
- Posts: 1
- Joined: Wed Feb 13, 2019 7:36 am
Re: Saving to a tab delomited text
by FJCC » Wed Feb 13, 2019 8:34 am
Click the More Options button in the Find & Replace dialog and make sure Regular Expressions is selected.
You can also make a tab delimited file directly from Calc. Choose Save As and set the file type to CSV. There should now be a check box near the bottom of the dialog that says something like Edit Filter Settings. Select that and continue with the save process. You will reach a dialog where you can set the field delimiter to tab.
You can also make a tab delimited file directly from Calc. Choose Save As and set the file type to CSV. There should now be a check box near the bottom of the dialog that says something like Edit Filter Settings. Select that and continue with the save process. You will reach a dialog where you can set the field delimiter to tab.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
- FJCC
- Moderator
- Posts: 7128
- Joined: Sat Nov 08, 2008 8:08 pm
- Location: Colorado, USA
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: Bill, MrProgrammer and 20 guests
|
Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these Policies and Terms of Use |
Get OpenOffice
|