Page 2 of 3

Re: Matching album names containing invalid file path characters

Posted: Thu Mar 16, 2017 3:46 pm
by zag
I would like to test this before rolling it out fully to the new strAlbumStripped field.

Hows this for a example set of 500 albums:

http://www.theaudiodb.com/blank.php

currently removing these characters:

Code: Select all

array('!', '@', '#','$', '%', '^','&', '*', '(',')', '_', '-','+', '\'', '[',']','{','}',';',':','"','<','>','|');

Re: Matching album names containing invalid file path characters

Posted: Sun Mar 26, 2017 12:05 pm
by bLight
Just got back from abroad, I'll have some code ready for testing in a few days.

Re: Matching album names containing invalid file path characters

Posted: Sun Mar 26, 2017 12:28 pm
by bLight
How do I perform the actual search? Adding "&i=1" or something else?

Re: Matching album names containing invalid file path characters

Posted: Tue Mar 28, 2017 8:17 am
by zag
You don't yet ;)

I was just checking the character removal is OK with you before I actually add it to a new database field.

Are the above examples what you want?

Re: Matching album names containing invalid file path characters

Posted: Tue Mar 28, 2017 12:14 pm
by bLight
Ah... :)

As far as I can tell, these characters missing :
1. "="
2. "~"
3. "?"
4. ","
5. "."
6. "`" (not " ' " which you already included)

Re: Matching album names containing invalid file path characters

Posted: Thu Mar 30, 2017 2:10 pm
by zag
Problem with some of those is they really effect album names

Example

Deadmau5 - 4×4=12

Turns into:

Deadmau5 - 4412

Re: Matching album names containing invalid file path characters

Posted: Thu Mar 30, 2017 6:12 pm
by bLight
That's actually ok as the client (the player) will be stripping the same characters prior to querying the DB, from the user's point of view it will be transparent as they don't see the stripped strings.

And btw, the "×" isn't listed as one of the chars.

Re: Matching album names containing invalid file path characters

Posted: Sun Apr 09, 2017 7:27 am
by bLight
Has there been any progress on this front?

Re: Matching album names containing invalid file path characters

Posted: Sun Apr 16, 2017 12:28 pm
by zag
Sorry I've been away snowboarding for a few weeks ;)

Will take a look next week.

Re: Matching album names containing invalid file path characters

Posted: Mon Apr 24, 2017 12:15 pm
by bLight
Any update?