Regex, replace nth field in a CSV record

[bob]

Hi
I need to replace the nth field in a CSV record with a new value,
Having trouble figuring out a regex that will capture the nth field.
I have a regex that captures every field in the record
but can't see an efficient way of making use of the matches collection
to build the required output string.
i.e. Don't want to iterate through the m[0].Groups collection
appending to a string builder when I figure I could use a replace
function if I had the right regex to count out n fields.

e.g.
MyRecord,"","","",""
replaced with
MyRecord,"","","NewValue",""

Any ideas?
Thanks
Bob

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

Why don't you just parse the CSV into an array or a datatable and change it
there?

-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

"bob" wrote:

Hi
I need to replace the nth field in a CSV record with a new value,
Having trouble figuring out a regex that will capture the nth field.
I have a regex that captures every field in the record
but can't see an efficient way of making use of the matches collection
to build the required output string.
i.e. Don't want to iterate through the m[0].Groups collection
appending to a string builder when I figure I could use a replace
function if I had the right regex to count out n fields.

e.g.
MyRecord,"","","",""
replaced with
MyRecord,"","","NewValue",""

Any ideas?
Thanks
Bob

[bob]

Hi Peter,
I am reading these records out of a file, checking with a database
that certain fields match then writing the records (slightly altered)
out to another file.
I think the array suggestion would be almost as expensive as iterating
through the Matches group collection.
Am I to take it that there isn't a way to get the nth field with a
regex?
regards
Bob
On Mon, 20 Aug 2007 04:32:02 -0700, Peter Bromberg [C# MVP]
<pb*******@yahoo.yohohhoandabottleofrum.comwrote :

>Why don't you just parse the CSV into an array or a datatable and change it
there?

-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

"bob" wrote:

>Hi
I need to replace the nth field in a CSV record with a new value,
Having trouble figuring out a regex that will capture the nth field.
I have a regex that captures every field in the record
but can't see an efficient way of making use of the matches collection
to build the required output string.
i.e. Don't want to iterate through the m[0].Groups collection
appending to a string builder when I figure I could use a replace
function if I had the right regex to count out n fields.

e.g.
MyRecord,"","","",""
replaced with
MyRecord,"","","NewValue",""

Any ideas?
Thanks
Bob

[bob]

Hi All,
Decided to iterate through the Matches group collection.
Don't waste any time on this question.
Thanks
Bob
On Tue, 21 Aug 2007 08:50:41 +1200, bob
<st**************@cutthis.adriley.co.nzwrote:

>Hi Peter,
I am reading these records out of a file, checking with a database
that certain fields match then writing the records (slightly altered)
out to another file.
I think the array suggestion would be almost as expensive as iterating
through the Matches group collection.
Am I to take it that there isn't a way to get the nth field with a
regex?
regards
Bob
On Mon, 20 Aug 2007 04:32:02 -0700, Peter Bromberg [C# MVP]
<pb*******@yahoo.yohohhoandabottleofrum.comwrot e:

>>Why don't you just parse the CSV into an array or a datatable and change it
there?

-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

"bob" wrote:

>>Hi
I need to replace the nth field in a CSV record with a new value,
Having trouble figuring out a regex that will capture the nth field.
I have a regex that captures every field in the record
but can't see an efficient way of making use of the matches collection
to build the required output string.
i.e. Don't want to iterate through the m[0].Groups collection
appending to a string builder when I figure I could use a replace
function if I had the right regex to count out n fields.

e.g.
MyRecord,"","","",""
replaced with
MyRecord,"","","NewValue",""

Any ideas?
Thanks
Bob