Member Avatar for 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.

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by iamthwee
Member Avatar for iamthwee

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.