Saving to a tab delimited text

Discuss the word processor

Saving to a tab delimited text

Postby 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

Postby 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.
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.
FJCC
Moderator
 
Posts: 7056
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Writer

Who is online

Users browsing this forum: No registered users and 19 guests