How do I split a double entry this into two columns.
Address is on top and GPS is underneath it. The addresses do not have a common period. I have 318 entries like these:
390 Main Street
42°03′55″N 78°03′44″W
42-64 and 43-69 Main St., 9 S. Church St.
42°27′41″N 77°46′39″W
School St.
41°59′58″N 78°16′22″W
Gibson Hill Rd., SW of Rtes. 19 and 408
42°15′10″N 78°04′31″W
There are two lines of text by cell?
or,
Address is in row n and GPS in row n+1?
Always attach an example file in such a case.
The editor of this site may (e.g,) spoil pasted text in a not directly visible way or replace quoting characters by “typographic” ones.
Check the attached example:
disask117855_splitnonsense.ods (14.4 KB)
Slightly simplified (better) version:
disask117855_splitnonsenseEnh.ods (14.4 KB)
Here is a sample of what I am trying to do. I have 318 entries that I need to address. I need to split the cell as
shown in row 4 and place the bottom line into the adjacent column.
Sample.ods (17.9 KB)
Select the cells in question and first do:
-
⇒find and replace:
search for \u000a replace: |
[x]regular Expression
[x]Selection only
⇒ replace all -
⇒ Data ⇒ Text in columns [x]other: »|« … ok
1 Like
For me, this insert the code, not a tab (\t).
1 Like
Sorry that was my fault, you’ll need to input a literal »tab« eg: ctrl shift u0009 (linux)
1 Like