Regular Expressions

[CodeMonkey775]

I'm making an Excel type program where you reference to other cells using the R(r)C(c) syntax.
r = row number
c = column number.

Examples: R1C1 R40C18

I'm unfamiliar with regular expressions though and not sure how I could search through a string to find all of the references.

Example String: '= (9 * 9) + "Hello" + R2C15 + "Test" + R32C1'

How would I write a regular expression that would return all of the cell references in that string. Even better, I'd like to return a list of Point objects. Each Point object would represent a cell (row,column). But just getting the regular expression to work would be great.

Any help is appreciated.

[iamthwee]

Can you describe your problem more clearly, with some more examples please.