Applications :: Smart Column Splitting In Numbers
Sep 24, 2010
I have a .txt file that is quite long and I need to get some data off of it. The file is made up of a few thousand lines each with a format similar to: 1 2.4 5.4 abcde abc.def, The 1, the 2.4, the 5.4, etc each signify a different value and I need to somehow get them into separate columns into excel. The number of digits in everything except the first value (which is always one digit) varies, and all the values are separated by spaces. What is going to be the easiest way for me to get these values into numbers in separate columns? Realistically, doing this manually isn't an option.
View 2 Replies
ADVERTISEMENT
Mar 12, 2010
I'm sure this is easy to answer by someone with basic spreadsheet skills, which I lack... I have a column of numbers (miles) and a column of use (Personal, Medical, Business). How do I set up 3 formulas so that I get the sum of the mileage column for each of the Personal, Medical, and Business categories?
View 2 Replies
View Related
Jul 17, 2010
I've been ripping my hair out trying to find the answer to this.
In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.
For example:
Column A - 1 - 5
Column B - (value in Column A * 5)
I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.
The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
View 1 Replies
View Related
Aug 24, 2010
I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:
Joe Blow
888-888-8888
View 3 Replies
View Related
May 6, 2010
I'm trying to "lock" or "freeze" the first column in the spreadsheet I'm making so that it will always be on the left side of the sheet when I scroll right. I cannot for the life of me figure out how though.
View 5 Replies
View Related
Oct 17, 2009
I'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)
However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).
View 2 Replies
View Related
Nov 26, 2010
I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:
Joe Blow
888-888-8888
View 13 Replies
View Related
Mar 24, 2009
See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.
like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.
View 3 Replies
View Related
Mar 11, 2009
I would like to put a whole season of a tv show on my ipod, i used handbrake to rip the 4 DVD's to my hard drive but is there a way to split them so that each episode is a file by it self?
View 3 Replies
View Related
Oct 11, 2009
Currently, I have all of my media in one iTunes library. This includes 40+ movies, 3000 songs, music videos and podcasts. I also have lots of apps for my iPhone. I have an iPhone 3GS, iPod nano, and Apple TV connected to this library. The files and library are stored on an external hard drive as I don't have the space for this on my uMBP. I would like to split the library (saving all my metadata and album art so that I don't need to redo this) into two. One library will remain on the external hard drive and contain all the movies, whilst the other will have all my music on it. The first library will be used to stream movies to my Apple TV, whilst the other (in the MBP HD) will be used to sync music/apps/photos to my iPhone/iPod nano.
However, at the moment I also have all of my music synced onto my Apple TV, and if I split the library with one containing just movies, all the music will be removed from the Apple TV and I won't be able to keep it up to date with any new albums I put into the iPhone/iPod library. Basically I would like the convenience of having all my music (but not movies) on my MBP hard drive so that I can sync my iPhone without having to connect to the external drive. At the same time, I can't be bothered managing music on two libraries to keep my Apple TV library synchronised with my iPhone library.
View 1 Replies
View Related
Nov 30, 2009
When I import an album some albums split into several albums. How do I stop this from happening? I have tried dragging and dropping them into one location.
View 9 Replies
View Related
May 13, 2010
I've got a 500gb internal drive for my iMac (250gb to XP and OSX), but my iTunes library takes up 300gb. 50gb of that is music. What I'd like to do is have my music on my internal drive and keep my videos on the external, which would be powered off (it's rather noisy and doesn't have an auto-power down like my other, smaller HDD's).
View 2 Replies
View Related
Jun 16, 2012
since I don't know when, the columns in Finder windows have always the same size. If I change the size, and then close the windows, when I open a new one, the column get back to their "original size" (which is too small for my personal use).
View 2 Replies
View Related
May 6, 2005
I'm looking for OS X software for splitting and joining mpegs and avis with minimal user interaction. ie. I don't want to have to use a movie editor and drag all the clips in, arange them and then export them, I'd like to just drag and drop them into a box and press 'join' In windows I was using PeckJoin for AVIs and Ordix Mpack for Mpegs, but I haven't found anything quite like them for OS X. I'm perfectly willing to use CLI tools or X11 tools if you know of any as well. Under linux (and OS X) I can join these files just by 'cat'ing them together on the command line, but that has problems if you are missing a file, or if one is named improperly, or is missing frames. Its nice to have a program that will give you warnings about these things
View 24 Replies
View Related
Jan 13, 2008
I was wonder if there was a way to use both coverflow and 3 column view. I did search.
View 4 Replies
View Related
Sep 3, 2010
I just downloaded the new itunes 10, and the first thing I noticed was the "album by artist" column under the music library. I don't like it at all. I want to remove it, but I can't! I'm not talking about the "album artist" column. This is totally new with the iTunes 10. When I try to remove it by, it only gives me the option of sort and artwork.
View 5 Replies
View Related
Feb 13, 2005
After a few months mild use on OS X I'm starting to get used to it more and more now. I love the column view, but find it really annoying that occasionally new finder windows will open in Icon view. What exactly is the point of the finder preference "always open new windows in column view"? It sounds pretty straight forward, but finder doesn't exactly pay much attention to it. When I'm viewing in column view and I command-double click a folder, finder will open a new window in Icon view, depsite my preference. I have to reset the new window to column view and then close it, and then when I repeat the command-double click it will open in column view but it kinda defeats the point. I've read numerous posts about finder not remembering views, I don't understand also why there's only an option for column view? why isn't there "always open in list view" or "always open in icon view" option?
View 1 Replies
View Related
Apr 10, 2006
Two emails in my mailbox have two exclamation points (!!) in the flagged column. I was unable to find what this meant in the help doc or on google. I was wondering if someone on here might know what this means. The two emails were sent via forms on my websites so I imagine maybe that has something to do with it? Anyway, any insight on these crazy exclamation points.
View 4 Replies
View Related
Jun 24, 2010
I have about 20 playlists. I want to apply the column formatting (including widths and orders) of the main itunes music library to these playlists. Is there a way to do this? I cannot do it manually.
View 12 Replies
View Related
Jan 3, 2011
Does anyone know how to set all the folders in Outlook 2011 to show the same set of columns?
View 1 Replies
View Related
May 22, 2012
how to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
View 3 Replies
View Related
May 27, 2010
i just started using Mail 4.2 on OS X 10.6.3. Every so often, I forward email that I receive at work on my Lotus Notes email account. Especially, my payroll information. I created a Smart Mailbox with the rule that looks for consistent string in the subject line. The original email is in the Inbox, but it does not appear in the Smart Mailbox I created.
I must be doing something wrong. I've googled, I've looked in Apple Support, I searched here. I don't see the answer to my question.
Any help is appreciated.
View 2 Replies
View Related
Nov 14, 2010
In iStat Pro, what's the purpose of setting "S.M.A.R.T Update Interval" to something other than "off"? I understand that this may cause iStat to query SMART in my HD (MBP Early 2009) at the set time interval. But what does that give me? iStat doesn't show any new info anywhere after I set the update interval to 5 mins. At least, I haven't noticed anything new. Is it supposed to display the HD temperature somewhere? Is there something else I have to turn on? I'm using iStat Pro 4.9.
View 1 Replies
View Related
Dec 24, 2010
Is there any program that will smartly back up my files? For example, I have all my music backed up to my external, but every month or so i have a couple new bands, albums in, that I don't really remember. So basically I want a program that will scan both folders, find what files are missing in the external and copy only those files over.
View 1 Replies
View Related
Jul 10, 2009
Hi all,
I'm trying to organize my mail by sender (if anyone has better organizational ideas other than deleting mail, let me know).
Right now, I have rules so all new emails are directed towards various inboxes (family, friends, etc.). However, this means I need to go to a bunch of different folders to read my email.
Is there a way to set up a rule so that mail gets routed according to email address after being read? I just want to go to my primary inbox, read a message and have it routed accordingly. I feel like I might be missing something very basic here...
Any help would be appreciated. In case you can't tell, I'm new to the world of mac. Now that I don't spend all my time fighting with a pc, I actually have time to try and organize my life...
View 11 Replies
View Related
Mar 8, 2009
I'm trying out iPhoto for the first time.I've been scanning and cleaning up old photo albums the past few months and I generally sync them to my Apple TV units and I noticed there's a sync from iPhoto option and while an image viewer like Xee is nice in some respects, it doesn't organize by folder or album so I can quickly scan for photos between directories, etc. I have to "open" a new directory.
XnView (which is great on my PC) is still pretty much beta for the Mac right now. But it appears iPhoto can organize my albums any way I want it to and share across the network to another Mac, etc. so maybe it'd be a good way to organize.
The problem I'm seeing offhand is that I can import my photo by folder/directory (I've been organizing them that way as I scan/edit) and according the docs I've read a "Smart" Photo album is supposed to update itself as your library is updated, a simple test of moving a new photo into a folder that was already imported in no way "updates itself" that I can see.
If I added new photos to a directory, it appears I'd have to manually add those to iPhoto as I go, which could be a real hassle if I ever forgot to do it (basically it's like having to move/edit TWICE, once in the real world directory structure and then once more inside iPhoto.
View 10 Replies
View Related
May 16, 2009
I have a smart playlist to sync only one season of The Office on iTunes. I hit sync with my iPhone and it doesn't show up as a playlist? How do I get it to? (I have an 8GB iPhone, can't sync the 16GB of The Office episodes I have.)
View 2 Replies
View Related
Sep 10, 2009
On my setup on Windows it loads the playlists fine, the newest first in Itunes 9 itself but dis-ordered on my ipods. On the Ipod touch v1 with 3.1.1 Firmware I can't fathom how it's sorted, it's totally scrambled the order but on the Ipod Classic V1 160Gb it appears to be sorted via artist. Even if you re-sort it by clicking the date added column the order of the playlist and resync it makes no difference to either of them. Neither does deselecting, resyncing, unplugging -replugging adding back and syncing again.
Anyone else have this issue or am I in the minority of one?
EDIT: Looking at the Apple Support Forums it seems like Smart Playlists are broken for many users on both Windows and Mac. Itunes 9.01 will be on it's way shortly!
View 14 Replies
View Related
May 1, 2010
I created a smart playlist and these podcasts that have been deleted from my library and that do not show up in the podcasts section are in the smart playlist and i can not find them in itunes or delete them.
View 5 Replies
View Related
Feb 27, 2009
Has anyone found a way to automatically find all the pictures in the library that are missing location information? I have tried creating a smart album to accomplish this with no success. This is the condition that I am using:
PLACE is {{0, 0}, {0, 0}}
Although there are some pictures in my library that haven't been tagged, the result of the query is zero (no pictures).
Does anyone know how to create a smart album that detects pictures that are not geo-tagged?
View 7 Replies
View Related
