| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding part of fole path
OK, here is what i have. I have a muisc list that I get from file
names from a playlist. i get the artist name and the song name from the path of the file using playlist files (txt format), Now i want the album name too. File name goes something like this: d:\Music\Beatles\Rubber Soul\Beatles - Drive My Car.mp3 Album name is Rubber Soul and is always the last "path" entry before the file name. Is there a formula that I can use to get "Rubber Soul"?? TIA Sheila |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
finding part of fole path
Hi!
Kind of ugly: =MID(A1,FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))-1))+1,FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))-1-FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))-1))) Biff "sheila" wrote in message ... OK, here is what i have. I have a muisc list that I get from file names from a playlist. i get the artist name and the song name from the path of the file using playlist files (txt format), Now i want the album name too. File name goes something like this: d:\Music\Beatles\Rubber Soul\Beatles - Drive My Car.mp3 Album name is Rubber Soul and is always the last "path" entry before the file name. Is there a formula that I can use to get "Rubber Soul"?? TIA Sheila |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
finding part of fole path
kind of ugly but works just fine Biff, thanks very much.
Sheila On Sat, 3 Dec 2005 23:56:46 -0500, "Biff" wrote: Hi! Kind of ugly: =MID(A1,FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))-1))+1,FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))-1-FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))-1))) Biff "sheila" wrote in message .. . OK, here is what i have. I have a muisc list that I get from file names from a playlist. i get the artist name and the song name from the path of the file using playlist files (txt format), Now i want the album name too. File name goes something like this: d:\Music\Beatles\Rubber Soul\Beatles - Drive My Car.mp3 Album name is Rubber Soul and is always the last "path" entry before the file name. Is there a formula that I can use to get "Rubber Soul"?? TIA Sheila |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
finding part of fole path
You're welcome. Thanks for the feedback!
Biff "sheila" wrote in message ... kind of ugly but works just fine Biff, thanks very much. Sheila On Sat, 3 Dec 2005 23:56:46 -0500, "Biff" wrote: Hi! Kind of ugly: =MID(A1,FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))-1))+1,FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))-1-FIND("~",SUBSTITUTE(A1,"\","~",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))-1))) Biff "sheila" wrote in message . .. OK, here is what i have. I have a muisc list that I get from file names from a playlist. i get the artist name and the song name from the path of the file using playlist files (txt format), Now i want the album name too. File name goes something like this: d:\Music\Beatles\Rubber Soul\Beatles - Drive My Car.mp3 Album name is Rubber Soul and is always the last "path" entry before the file name. Is there a formula that I can use to get "Rubber Soul"?? TIA Sheila |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use a cell value as part of a link's path name? | Excel Discussion (Misc queries) | |||
| I need help with an "If" Statement | Excel Worksheet Functions | |||
| Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Hybrid Mode
