Comma in filename?

[lithium]

Okay, I am currently trying to get my database to load a picture from a folder depending on what filename the user selects from a listbox populated on load from that folder. The issue I have comes down to naming conventions used, the format has always been LAST, FIRST INITIAL.NUMBER.jpg and I can only get it to work if I replace the comma with a period.

[ranman256]

Filenames can't have commas. Its the law.
use underscore.

[lithium]

Yeah, well the thing is that I have hundreds of jpegs that all have commas in them and I don't want to go through each one and change the names. Isn't there a way to still populate the names and read the commas?

[June7]

Commas are allowed in filenames but apparently not a good practice.

What method are you using to 'load' - load to where? I had no problem loading it into an Image control.

Could get a file manager program that has a utility to do a global replace on all the filenames in a folder. Change the comma to underscore. Change file naming policy. Just use unique ID (employee, customer?) in the filename.

[ssanfu]

Using more than one period in a file name (for the extension) is also not a good practice. Best practice is no punctuation or special characters (exception is the underscore) in file names.

I have seen where a file name like

FileName.Ver2.SubVer1.ext

caused programs to bomb. Changing the file name to

FileName_Ver2_SubVer1.ext

solved the problems.