I have a 4 line, single spaced list in Writer then a blank line and the next entry in the list:
NAME
ADDRESS
CITY
STATE
[Blank line]
NAME
(etc)
How to ‘turn’ that so I can copy into ODS for of:
NAME | Address | City | State
Or is it easier to copy Writer format into CALC and change ‘directions’ in CALC?
Thanks, ⌡im
It’s not very difficult.
First of all, turn all your data into one line by replacing the end of paragraph sign with a tab.
Use Find & Replace: find $, replace with \t, Regular Expressions - ON, Replace All
Now [Blank line] has become two tabs in a row - <TAB><TAB>
Turn them back into “end paragraph” mark: find \t\t, replace with \n, Regular Expressions still is ON and Replace All
Close the Find & Replace form - it did the job
Now select all data (Ctrl+A) and use Table - Convert - Text to Table
Worked PERFECTLY !
Thanks, you saved me many hrs of Copy & Paste
⌡im