Convert comma, Tab delimited paste?
apple Verified ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I am trying to give Numbers a try. I often copy text from an email and paste it in to an Excel spreadsheet and format it using the text import wizard.
I can't find any reference in Numbers help to try to do this.
Is there a way to format copied text in Numbers using tabs or commas as delimiters?
Things like this in Excel Mac 2004 and the very good 'Change Case...' in Word Mac 2004, keep me from being able to use Pages and Numbers as stand alone application without using MS products as converters.
15 replies
Sign in or join Beachball Help to reply.
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
No problem to paste TAB separated values.
Use copy-paste or import the file assuming that the name extension is .txtFor CSV datas theorically we may import the file assuming that the name extension is .csv
CAUTION: I wrote "theorically" because, if you are in a country using the comma as decimal separator, the problem becomes odd.
In such countries, most programs generates so called CSV files which are in fact using the semi-colon as delimiter.
Numners is unable to import these files.As you are a "old" forum's poster, i wish to post my well known reminder:
+-+-+-+-+-+-+-+-+
Worried Life Blues 2008
Discussions
+Apple Discussions, launched in August, 2000, have grown rapidly in usage and features. The main features include personalization, subscription capabilities and email capabilities. _For information on how to use Discussions, please visit the Discussions Help Page_. Cookies should be enabled and an Apple ID account is required if you would like to contribute to the discussions.+
…
+*What is Apple Discussions and how can it help me?*+
+
Apple Discussions is a user-to-user support forum where experts and other Apple product users get together to discuss Apple products. … You can participate in discussions about various products and topics, find solutions to help you resolve issues, ask questions, get tips and advice, and more.+
+_If you have a technical question about an Apple product, be sure to check out Apple's support resources first by consulting the application Help menu on your computer and visiting our Support site to view articles and more on our product support pages._+
…
+*I have a question or issue*—+
+how do I search for answers? _
It's possible that your question or issue has already been answered by other members so do a search before posting a question._ On most Apple Discussions pages, you'll find a Search Discussions box in the upper right corner. Enter a search term (or terms) in the field and press Return. Your results will appear as a list of links to posts below the Search Discussions Content pane.+
…
+Search tips are available here:+
+
http://discussions.apple.com/help/search-tips.html++-+-+-+-+-+-+-+-+
Yvan KOENIG (from FRANCE lundi 18 août 2008 20:12:02)
- 0
Looter ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I am copying and pasting text from an email. When I paste the text into Numbers, there is only 1 column but the correct number of rows. In Excel I can use the text import wizard to get approximately the correct number of columns and rows.
I am not importing a file but copying and pasting text.
- 0
Jerrold Green1 ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Looter,
You must be your own Wizard in this case. You can use Pages (Find and Replace) for adding delimiters, I think that would be more convenient than writing expressions in Numbers to parse the text.
Jerry
- 0
Looter ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Jerrold Green1 wrote:
Looter,You must be your own Wizard in this case. You can use Pages (Find and Replace) for adding delimiters, I think that would be more convenient than writing expressions in Numbers to parse the text.
Jerry
Fair enough. I'd like to see Numbers be able to handle this without using Excel or Pages as a converter. Can you use find TAB and replace with ','? Anyway, I can use the Excel import wizard THEN copy and paste into Numbers. But why not just use Excel at that point?
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
My guess is that in the mail, the TAB separing values where replaced by spaces.
May you send the original mail to my mailbox?
Click my bluename to get my address.
Yvan KOENIG (from FRANCE lundi 18 août 2008 22:02:18)
- 0
Looter ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
It is a work related email and I am unable to forward it to you. Thank you very much for the offer. It may be the case, that Mail.app is replacing the tabs with spaces. I just checked in Excel and the wizard was separating using SPACES. Actually, I think it might be the clipboard which is substituting spaces for tabs as the email appears to use tabs for spacing/alignment.
I would image that is even harder or impossible to replace spaces with tabs using Pages and that there is no easy solution using Numbers.
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I am aware of what means CONFIDENTIALITY.
If you send the mail, I guess that I may find an easy workaround.
Maybe you may ask to the original's autor to send a fake one with odd values.
The important thing, is that I get a mail containing datas organised as the one which you received.Yvan KOENIG (from FRANCE lundi 18 août 2008 22:38:45)
- 0
Looter ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Um, that is not possible. I am not in the practice of forwarding business email to an anonymous person from a forum, in another country for that matter. And I am not going to bother a client with a request for a fake email.
Thanks for your time. But I don't see what your solution could possibly be.
If you have a suggestion to easily do this using ONLY Numbers please let me know.
Again, thanks.
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I'm not an anonymous person on a forum.
I'm a world wide known potter which worked during 30 years with a process which was patented in 1930.
The patent is dead for years but, as I know the meaning of discretion, we are always the only one pottery using this process.You may search for "Gerbino AND Koenig" in Google to check what I write.
At least, may you tell us which program was used to create the table embedded in the received email.
Knowing that, I would be able to ask someone to send a fake mail.
I'm ready to try to help but I can't work on "nothing".
Yvan KOENIG (from FRANCE lundi 18 août 2008 23:17:27)
- 0
WWJD ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I would think that you could construct a sample file and send. If Mr. Yvan is successful, you are ahead, if he is not successful, you are still where you are right now.
Regards,
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I recived a sample file but I don't know if it matches exactly the original one contents.
In the received one, values are separated by chunks of numerous spaces.
I wrote this short script to rebuild a table with TABs.
--(SCRIPT spaces2tabs4bh]
set theClip to the clipboard as text
set i to count of theClip
set j to 0
repeat while i > 1
if character i of theClip is space then
set j to 1
repeat
if character (i - j) of theClip is not space then
if j > 1 then
set debut to text 1 thru -(1 + (count of theClip) - (i - j)) of theClip
set fin to text (i + 1) thru -1 of theClip
set theClip to debut & tab & fin
set i to (count of debut) - 1
exit repeat
else
set i to i - 1
exit repeat
end if
else
set j to j + 1
end if
end repeat -- with j
end if -- character i of theClip
set i to i - 1
end repeat
set the clipboard to theClip
display dialog "Done !" & return & "The table is in the clipboard."
--[/SCRIPT]Yvan KOENIG (from FRANCE mardi 19 août 2008 12:35:56)
- 0
Andrew Gorman ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Fair enough. I'd like to see Numbers be able to handle this without using Excel or Pages as a converter.
I agree
Looter. This seems like a pretty common task (at least it's one that I used all the time in excel). Being able to parse pasted text using an arbitrary delimited is pretty useful. Let's hope that Apple includes this in future releases. - 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hello
Numbers is able to import TAB delimited values.
It is able to import CSV if they are using the US format but fails to import the one mostly used in Europe (semi-colon used as delimiter).
The problem asked by the OP is that he wants to import a text in which values are separated by spaces.
I apologize but I don't know a process able to guarantee that such a set of datas will be correctly deciphered.In the received sample, I was able to create a table but I'm not sure that it is the correct one.
I can't imagine how a program may decide that a single space is part of a cell's content or is a cells separator.
One attempt would be to replace every chunck of space character containing at least two characters as a TAB but we can't guarantee that it is correct.It's the choice I made in the given script but at this time, I got no feedback from the OP so I don't know if the row:
Sample Text – (City) [22 spaces] April 5th [51 spaces] 2 Crew [20 spaces] Call time 9am (8hr call)
is correctly decipher with:
Sample Text – (City) [tab] April 8th [tab] 2 Crew [tab] Call time 9am (8hr call)
Maybe it is, maybe it isn't.
From my point of vue, the true problem is:
why are some beings fool enough to build such sets of datas?Yvan KOENIG (from FRANCE jeudi 28 août 2008 20:33:34)
- 0
Looter ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
KOENIG Yvan wrote:
HelloNumbers is able to import TAB delimited values.
It is able to import CSV if they are using the US format but fails to import the one mostly used in Europe (semi-colon used as delimiter).
The problem asked by the OP is that he wants to import a text in which values are separated by spaces.
I apologize but I don't know a process able to guarantee that such a set of datas will be correctly deciphered.In the received sample, I was able to create a table but I'm not sure that it is the correct one.
I can't imagine how a program may decide that a single space is part of a cell's content or is a cells separator.
One attempt would be to replace every chunck of space character containing at least two characters as a TAB but we can't guarantee that it is correct.It's the choice I made in the given script but at this time, I got no feedback from the OP so I don't know if the row:
Sample Text – (City) [22 spaces] April 5th [51 spaces] 2 Crew [20 spaces] Call time 9am (8hr call)
is correctly decipher with:
Sample Text – (City) [tab] April 8th [tab] 2 Crew [tab] Call time 9am (8hr call)
Maybe it is, maybe it isn't.
From my point of vue, the true problem is:
why are some beings fool enough to build such sets of datas?Yvan KOENIG (from FRANCE jeudi 28 août 2008 20:33:34)
That last comment is insulting and you are completely missing the point.
I am able to do this in Excel 2004 for Mac. I won't run an Apple script sent via an email. I am looking for a way to do this IN NUMBERS WITHOUT USING AN APPLE SCRIPT. This is a business environment and not acceptable for security reasons and misses the point as well.
And once again I am not opening a file and IMPORTING it. I am copying and pasting from an email.
As I have already stated I HAVE AN EXISTING WORKAROUND using Excel 2004 to convert the data with its text import wizard. But using Excel in order to use Number as a replacement to Excel begs the question; Why not just use Excel?
And please keep your insults to yourself.
- 0
Andrew Gorman ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Well put!
The technology doesn't fit the work flow, period!