•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the C# section within the Software Development category of DaniWeb, a massive community of 391,560 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,742 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our C# advertiser:
Views: 704 | Replies: 1
 |
•
•
Join Date: Jul 2007
Posts: 10
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
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.
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb C# Marketplace
Linear Mode
Similar Threads
- Parsing a log file using regular expressions (C#)
- Regular Expressions (VB.NET)
- Regular Expressions (Computer Science and Software Design)
- Regular Expressions (C#)
- Regular Exp (Python)
- mod_rewrite: help with regular expressions (Linux Servers and Apache)
- matching regular expressions (Java)
Other Threads in the C# Forum
- Previous Thread: some doubts
- Next Thread: Developers
