Ask Your Question
0

How to paste tab delimited data into base table [closed]

asked 2013-04-17 23:22:01 +0200

Kabo gravatar image

If I've got a tab delimited/separated string, like this

word1[tab]word2[tab]word3

I can paste this into calc and each word ends up in a cell of it's own, not all three words in the same cell.

But if I paste it into a base-table, I get the opposite. All words are pasted into the same column and not word1 in column1, word2 in column2, etc.

This is very annoying. Is there a fix/workaround for this?

I've tried pasting directly into the table and I've tried pasting into a form. None of them work the way I want.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-30 17:43:55.391136

Comments

Extra clarification: Calc is working just the way I want it, my problem is with how Base works.

Kabo gravatar imageKabo ( 2013-04-18 08:43:34 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-04-18 02:16:40 +0200

m.a.riosv gravatar image

In calc, have you tried with Menu/Edit/Past special/Unformatted text, selecting in the options window tab as delimiter.

edit flag offensive delete link more

Comments

And what if it doesn't give you the options window? I have space-delimited text and it pastes the whole text in one cell...

panos gravatar imagepanos ( 2013-07-26 15:40:58 +0200 )edit

Menu/Data/Text to Columns

m.a.riosv gravatar imagem.a.riosv ( 2013-07-26 19:11:33 +0200 )edit

Question Tools

Stats

Asked: 2013-04-17 23:22:01 +0200

Seen: 6,009 times

Last updated: Apr 18 '13