Very Quick Question-Select Case-Determine if string has delimiters

Just a very quick question.

I need code to determine whether a given string contains common delimiters or not. I want the output as a Select Case/End Select. (i.e. first case = if string contains any of the following delimiters. Case else = string doesn't contain).

The delimiters I want to capture are:

• Space ( )
• Comma (,)
• Full stop/period (.)
• Underscore (_)

(I won't need "-" because of the danger of picking up hyphenated surnames).

(Yes I could work this out myself but my solution would be large and messy. I am hoping for a quick compact solution here folks! )
(Background Info: I intend to implement this code into another project I am working on: http://www.excelforum.com/excel-form...ngle-word.html

Hi MC,

Something like this:

Please Login or Register  to view this content.

Originally Posted by xladept

Something like this:

Thanks for your help +1

Before I close the thread as solved, I want the code to be more compact/compressed.

Why does xladepts code work but not the code below? (the code is an extract only)

Please Login or Register  to view this content.

Does anyone where the above code is going wrong?

That can't work because you never have " ,._" together as a string with nothing between them, maybe something like
"* ,*.*_*" would work???

That can't work because you never have " ,._" together as a string with nothing between them, maybe something like"* *,*.*_*" would work??? And - you're welcome!

Originally Posted by xladept

That can't work because you never have " ,._" together as a string with nothing between them, maybe something like"* *,*.*_*" would work??? And - you're welcome!

The post #4 code was my attempt at adapting some other code I found a while ago. The original code is below.

UPDATE 1: Just ran some tests on the function below and it always returns False. Uh oh.
UPDATE 2: I found out where I found the code from. http://www.jpsoftwaretech.com/excel-...ate-filenames/ Interestingly the web page states: "I've modified the original code ever so slightly; the asterisks just inside the quotation marks in Ross' code are unnecessary, if the Visual Basic Help System is to be believed." (It looks like the asterisks ARE necessary)

Please Login or Register  to view this content.

I will mark this thread as solved because my original question has been answered.

(However I am still interested in a "like" version to make the delimiter check more compact. I am sure I can work this out myself once somebody solves this thread here: http://www.excelforum.com/excel-prog...file-name.html )

Originally Posted by jindon

Please Login or Register  to view this content.

Thanks! +1