Musiclover
New Member
- Joined
- Jun 6, 2020
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
I have gained so much from these forums but find myself stumped on this question.
I have a large data base of file/folder names extracted from multiple folders, about 5000. I want to be able to find two separate partial bits of text in one string and return that string to the next column.
Example:
This is what the extracts look like
F:\Temp list folder\Now Workout\NOW That's What I Call A Workout (2013) CD 1\NOW That's What I Call a Workout 1 - 03 - David Guetta & Usher - Without You (feat. Usher) [Extended].mp3
I want to find if it contains two partial matches, for example match one = Now Workout, match two = Without You (feat. Usher)
Any help anyone can offer would be much appreciated and hopefully allow me a good nights sleep!!!!!
Thank you in advance of your help
I have a large data base of file/folder names extracted from multiple folders, about 5000. I want to be able to find two separate partial bits of text in one string and return that string to the next column.
Example:
This is what the extracts look like
F:\Temp list folder\Now Workout\NOW That's What I Call A Workout (2013) CD 1\NOW That's What I Call a Workout 1 - 03 - David Guetta & Usher - Without You (feat. Usher) [Extended].mp3
I want to find if it contains two partial matches, for example match one = Now Workout, match two = Without You (feat. Usher)
Any help anyone can offer would be much appreciated and hopefully allow me a good nights sleep!!!!!
Thank you in advance of your help