 |  |  |  |  |  |  |  |
Regular Expressions
Please support our C# advertiser: Intel Parallel Studio Home
 |
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.
|
Similar Threads
- Regular Expressions (VB.NET)
- Parsing a log file using regular expressions (C#)
- Regular Expressions (Computer Science)
- 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
| Thread Tools | Search this Thread |
Latest C# Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for C#
.net access ado.net algorithm array bitmap box broadcast buttons c# chat check checkbox class client color combobox control conversion csharp custom database datagrid datagridview dataset datetime degrees development draganddrop drawing encryption enum event excel file files form format forms ftp function gdi+ httpwebrequest image index input install java label list listbox listener mandelbrot math mouseclick mysql networking object operator oracle path photoshop picturebox pixelinversion post prime programming radians regex remote remoting resource richtextbox save saving serialization server sleep socket sql statistics stream string table tcp text textbox thread time timer treeview update usercontrol validation visualstudio webbrowser windows winforms wpf xml
