![]() But using Excel in order to use Number as a replacement to Excel begs the question Why not just use Excel?Īnd please keep your insults to yourself.Go to the Data tab > Get External Data > From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import, and the Text Import Wizard dialog will open. I am copying and pasting from an email.Īs I have already stated I HAVE AN EXISTING WORKAROUND using Excel 2004 to convert the data with its text import wizard. This is a business environment and not acceptable for security reasons and misses the point as well.Īnd once again I am not opening a file and IMPORTING it. I am looking for a way to do this IN NUMBERS WITHOUT USING AN APPLE SCRIPT. I won't run an Apple script sent via an email. I am able to do this in Excel 2004 for Mac. That last comment is insulting and you are completely missing the point. Why are some beings fool enough to build such sets of datas? Sample Text – (City) April 8th 2 Crew Call time 9am (8hr call)įrom my point of vue, the true problem is: Sample Text – (City) April 5th 2 Crew Call time 9am (8hr call) 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: 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. 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. In the received sample, I was able to create a table but I'm not sure that it is the correct one. I apologize but I don't know a process able to guarantee that such a set of datas will be correctly deciphered. ![]() The problem asked by the OP is that he wants to import a text in which values are separated by spaces. 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). Numbers is able to import TAB delimited values. ![]() Your results will appear as a list of links to posts below the Search Discussions Content pane.+ Enter a search term (or terms) in the field and press Return. 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. +_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._+ … 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.+ +*What is Apple Discussions and how can it help me?*+Īpple Discussions is a user-to-user support forum where experts and other Apple product users get together to discuss Apple products. ![]() Cookies should be enabled and an Apple ID account is required if you would like to contribute to the discussions.+ _For information on how to use Discussions, please visit the Discussions Help Page_. The main features include personalization, subscription capabilities and email capabilities. +Apple Discussions, launched in August, 2000, have grown rapidly in usage and features. In such countries, most programs generates so called CSV files which are in fact using the semi-colon as delimiter.Īs you are a "old" forum's poster, i wish to post my well known reminder: csvĬAUTION: I wrote "theorically" because, if you are in a country using the comma as decimal separator, the problem becomes odd. txtįor CSV datas theorically we may import the file assuming that the name extension is. Use copy-paste or import the file assuming that the name extension is. No problem to paste TAB separated values. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |