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.