ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Syntax of this code (https://www.excelbanter.com/excel-programming/335147-syntax-code.html)

ExcelMonkey

Syntax of this code
 
Can someone tell me what this snippet of code means? What is the role of:

1) [
2) ^
3) +
4) (


Const Words As String = "[^a-z]([A-Za-z0-9$]+)"

Thanks

Bob Phillips[_7_]

Syntax of this code
 
You are looking at regular expressions.

Take a look at

http://msdn.microsoft.com/library/de...ting051099.asp
Microsoft Beefs Up VBScript with Regular Expressions

--
HTH

Bob Phillips

"ExcelMonkey" wrote in message
...
Can someone tell me what this snippet of code means? What is the role of:

1) [
2) ^
3) +
4) (


Const Words As String = "[^a-z]([A-Za-z0-9$]+)"

Thanks





All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com