Any MS Excel experts out there - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Any MS Excel experts out there

£0.00 @
I am trying to create some csv files in excel to use to auto edit some mp3 file id3 tags. I have the track date in one cell in excel in the format track number - artist - title e.g. 17 - A… Read More
elitom Avatar
9y, 1m agoPosted 9 years, 1 month ago
I am trying to create some csv files in excel to use to auto edit some mp3 file id3 tags.

I have the track date in one cell in excel in the format

track number - artist - title

e.g.

17 - Animals - The House Of The Rising Sun

What I want to do is separate the track number artist and track title into three seperate cell using a function.

I know about RIGHT / LEFT / MID but is there a way to use the "-" in the above example to separate text strings of differing lengths?

Anyone got any ideas

Any answers much appreciated

Ta

EliTom
Tags:
elitom Avatar
9y, 1m agoPosted 9 years, 1 month ago
Options

All Comments

(12) Jump to unreadPost a comment
Comments/page:
#1
Not sure that a single function will give you what you need to be honest.

The best bet might be to write a vbscript procedure, where your using loops to determine length of the text components.

Hope this helps
#2
If your trying to modify the id3 tags etc in mp3's i really do suggest using ' Tag&rename' its a brilliant easy to use application and improtantly its free to download. It also lets you rename the tracks using any tags you want. It lets you extract information from the filename and enter it in different fields, all at the click of a few buttons. Hope this helps

BFM
#3
BurningFeetMan
If your trying to modify the id3 tags etc in mp3's i really do suggest using ' Tag&rename' its a brilliant easy to use application and improtantly its free to download. It also lets you rename the tracks using any tags you want. It lets you extract information from the filename and enter it in different fields, all at the click of a few buttons. Hope this helps

BFM


Yeah I use T&R normally but I have some compilation albums that I cannot get the tags from the usual T&R sources like Amazon or Freedb.

Yes I could use T&R to manually edit the tags but I have all the data in xls files but need to seperate into separate cells if you see what I mean

EliTom
#4
how about text to columns using '-' as the character? Then add it in as another column if you want to keep the '-'. Not sure how clear that is but maybe it will be mildly useful :)
#5
autolesbona
how about text to columns using '-' as the character? Then add it in as another column if you want to keep the '-'. Not sure how clear that is but maybe it will be mildly useful :)


Can you explain a bit more please?

What is the function name to do this

Sounds promising - Ta

EliTom
#6
not quite sure what you mean mate, you can always extract the info from the filename even without access to amazon etc. However, there is also another program which may help you rename the files correctly, ' File Renamer Deluxe ' is a very good renaming package, very in depth and allows you to do just about anything including adding id3 tags etc. Definately worth a look buddy!

BFM
1 Like #7
Its under the data menu --> text to columns I think. You then want to chose the delimited option and then in the bottom box enter the character you wish to use as the column seperater.
#8
There is a search text function that will give you the position of the "-".
You can then use your LEFT and RIGHT functions with this to filter down so you can get what you want.
You should be using Access for this anyway :)

Hope this helps
#9
Sorry elitom, I forgot about the initial feature of excel. IF you create your csv file with the '-' to seperate your data, then open it with excel and it will go into the how is the file delimited dialogue, just select the '-' as the seperator, and it should do the business for you
#10
autolesbona
Its under the data menu --> text to columns I think. You then want to chose the delimited option and then in the bottom box enter the character you wish to use as the column seperater.


Your a star :)

That works:thumbsup:

many thanks - rep added

EliTom
#11
i know only the absolute basics of excel, but sounds like once you have done what toconn suggests you will end up with

tracknumber-artist-title

you could then use filerenamer or similar to change all '-' to ' - ' so you get

tracknumber - artist - title

or perhaps that too can be done with excel?

BFM
#12
woohoo for me :) Glad I could help

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!