I need to find all occurrences of a comma in a string EXCEPT where it
occurs between quotation marks.
For Example:
Field1,Field2,Field3,Fiel4,"Lastname, Firstname",Field5, Field6
So I need to find the indexes of the commas except for the one that
separates the last and first name.
I figured a regular expression would be the way to go, but I cannot seem to
figure it out.
Does anyone know of any programs that help you build regular expressions?
Kind of like the wizard that helps you build a connection string? I know
of various RegEx test programs, but I would like one to help me construct
one. I evision a utility that could let me select options using a english
like language, but then builds the regex behind the scenes
Thanks for the help
--
Chris
dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address. 3 1698
oooo, that sounds like a great idea.
maybe you should write one of those :)
jk
-sandor
"Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net"> wrote in
message news:uw*****************************@40tude.net...
| I need to find all occurrences of a comma in a string EXCEPT where it
| occurs between quotation marks.
|
| For Example:
|
| Field1,Field2,Field3,Fiel4,"Lastname, Firstname",Field5, Field6
|
| So I need to find the indexes of the commas except for the one that
| separates the last and first name.
|
| I figured a regular expression would be the way to go, but I cannot seem
to
| figure it out.
|
| Does anyone know of any programs that help you build regular expressions?
| Kind of like the wizard that helps you build a connection string? I know
| of various RegEx test programs, but I would like one to help me construct
| one. I evision a utility that could let me select options using a english
| like language, but then builds the regex behind the scenes
|
| Thanks for the help
|
| --
| Chris
|
| dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
|
| To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
| replace certain words in my E-Mail address.
On Fri, 15 Oct 2004 14:47:16 -0400, Sandor Pakh wrote: oooo, that sounds like a great idea. maybe you should write one of those :)
I would if I could master RegEx's. They twist my mind!!
--
Chris
dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.
Ok.. here's a link that may give you a bit more insite on how they work. http://www.codeguru.com/Cpp/Cpp/cpp_...cle.php/c4093/
Keep me posted if you put one together :)
-sandor
"Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net"> wrote in
message news:di****************************@40tude.net...
| On Fri, 15 Oct 2004 14:47:16 -0400, Sandor Pakh wrote:
|
| > oooo, that sounds like a great idea.
| > maybe you should write one of those :)
|
| I would if I could master RegEx's. They twist my mind!!
|
| --
| Chris
|
| dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
|
| To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
| replace certain words in my E-Mail address. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bradley Plett |
last post by:
I'm hopeless at regular expressions (I just don't use them often
enough to gain/maintain knowledge), but I need one now and am looking
for help. I need to parse through a document to find a URL,...
|
by: Neri |
last post by:
Some document processing program I write has to deal with documents
that have headers and footers that are unnecessary for the main
processing part. Therefore, I'm using a regular expression to go...
|
by: Lee Kuhn |
last post by:
I am trying the create a regular expression that will essentially match
characters in the middle of a fixed-length string. The string may be any
characters, but will always be the same length. In...
|
by: James D. Marshall |
last post by:
The issue at hand, I believe is my comprehension of using regular
expression, specially to assist in replacing the expression with other text.
using regular expression (\s*) my understanding is...
|
by: Billa |
last post by:
Hi,
I am replaceing a big string using different regular expressions (see
some example at the end of the message). The problem is whenever I
apply a "replace" it makes a new copy of string and I...
|
by: Pete Davis |
last post by:
I'm using regular expressions to extract some data and some links from some
web pages. I download the page and then I want to get a list of certain
links.
For building regular expressions, I use...
|
by: Zach |
last post by:
Hello,
Please forgive if this is not the most appropriate newsgroup for this
question. Unfortunately I didn't find a newsgroup specific to regular
expressions.
I have the following regular...
|
by: Mike |
last post by:
I have a regular expression (^(.+)(?=\s*).*\1 ) that results in
matches. I would like to get what the actual regular expression is.
In other words, when I apply ^(.+)(?=\s*).*\1 to " HEART...
|
by: Mr.Steskal |
last post by:
Posted: Wed Jul 11, 2007 7:01 am Post subject: Regular Expression
Help
--------------------------------------------------------------------------------
I need help writing a regular...
|
by: Lit |
last post by:
Hi,
I am looking for a Regular expression for a password for my RegExp
ValidationControl
Requirements are,
At least 8 characters long.
At least one digit
At least one upper case character
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |