Matching album names containing invalid file path characters

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

[bLight]

Just got back from abroad, I'll have some code ready for testing in a few days.

[bLight]

How do I perform the actual search? Adding "&i=1" or something else?

[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?

[bLight]

Ah...

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

[zag]

Problem with some of those is they really effect album names

Example

Deadmau5 - 4×4=12

Turns into:

Deadmau5 - 4412

[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.

[bLight]

Has there been any progress on this front?

[zag]

Sorry I've been away snowboarding for a few weeks

Will take a look next week.

[bLight]

Any update?