Imported from the Apple Support Forums via the Wayback Machine 🔗
I have imported a transaction list from an online financial management site into Numbers. All my transactions are tagged, usually 2 times: a category and a subcategory. these tags are in one column in my Numbers table separated by a comma. is there an easy way to separate these into independent columns so that I can easily create subcategories in Numbers?
I looked at Split but that seems to be the same as making a copy of the column (in that case why is a split command needed, please enlighten me).
Imported from the Apple Support Forums via the Wayback Machine 🔗
m,
To decompose your tag column, we would create 2 new columns with formulas that each take a portion of the tag, before the comma and after the comma.
We can use FIND or SEARCH to locate the comma and then we can use combinations of LEFT, RIGHT, MID and LEN to grab the appropriate sub strings. The exact form of the expressions would depend on whether you have spaces or other characters that you want to strip out.
Regards,
Jerry
0
Badunit·
Imported from the Apple Support Forums via the Wayback Machine 🔗
If you do this often I would recommend using the script that Yvan supplied. If it is a one-time-only affair, you can do it quickly with any text editor.
0
mbucc·
Imported from the Apple Support Forums via the Wayback Machine 🔗
thanks a lot, script works like a charm. Unfortunate there's no "Text to Columns" in Numbers....
0
Badunit·
Imported from the Apple Support Forums via the Wayback Machine 🔗
mbucc wrote:
...Unfortunate there's no "Text to Columns" in Numbers....
If you saved the script in the scripts folder and called it Text to Columns, there is now.
0
KOENIG Yvan·
Imported from the Apple Support Forums via the Wayback Machine 🔗
My script is named "csv2tsv", not "Text to Columns".
As it is not linked to Numbers, the given instructions aren't urging you to install it in the folder
Macintosh HD:Users:yvan_koenig:Library:Scripts:Applications:Numbers:
but in the folder
Macintosh HD:Users:yvan_koenig:Library:Scripts:
If you applied the instructions, the script is available from every applications.
If you want to restrict it to Numbers, install it in :
Macintosh HD:Users:yvan_koenig:Library:Scripts:Applications:Numbers:
As badunit wrote, you may rename it but if you want to ask about it, use the original name in your question. If you ask about a script named "Text to Columns" I would be unable to guess which one it is.
Yvan KOENIG (VALLAURIS, France) mercredi 23 décembre 2009 07:51:43