Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #15982

Re: need regular expression to replace part of result based on a search pattern

Show key headers only | View raw

On 7/12/2012 10:28 AM, Jimmy wrote:
> Thank you so much for everyone's response.
> These CSV are inside a script and I've clean up the quotes.
>
> Want 1 line of regexp to change from column #6 (from top to bottom 'N','Y','N','Y','N','Y')
>
> 'blaha',NULL,'N','Y','N','N',NULL
> 'blahb',NULL,'Y','Y','Y','N',NULL
> 'blahc',NULL,'N','N','N','N',NULL
> 'blahd',NULL,'N','N','Y','N',NULL
> 'blahe',NULL,'N','N','N','N',NULL
>
> To following result in column #6 (from top to bottom 'Y','Y','Y','Y','Y','Y')
>
> 'blaha',NULL,'N','Y','Y','N',NULL
> 'blahb',NULL,'Y','Y','Y','N',NULL
> 'blahc',NULL,'N','N','Y','N',NULL
> 'blahd',NULL,'N','N','Y','N',NULL
> 'blahe',NULL,'N','N','Y','N',NULL
>
> Can someone please help?

     If you are certain that commas appear *only* as field separators
and never inside quoted material, you can use something like (untested)

	"(.*?,){5}.*?,(.*)"

After matching you'd then paste group(1) + "'Y'," + group(2).

     If quoted material can contain commas that don't count as field
separators, I don't think regular expressions can do the job at all.
You'll need to parse the strings in a context-sensitive way.

	"Some people, when confronted with a problem, think `I know,
	I'll use regular expressions.' Now they have two problems."
	-- Jamie Zawinski

-- 
Eric Sosman
esosman@ieee-dot-org.invalid

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

need regular expression to replace part of result based on a search pattern Jimmy <jimmy_please@yahoo.com> - 2012-07-11 10:35 -0700
  Re: need regular expression to replace part of result based on a search pattern Roedy Green <see_website@mindprod.com.invalid> - 2012-07-11 15:24 -0700
  Re: need regular expression to replace part of result based on a search pattern Knute Johnson <nospam@rabbitbrush.frazmtn.com> - 2012-07-11 15:40 -0700
    Re: need regular expression to replace part of result based on a search pattern Daniele Futtorovic <da.futt.news@laposte-dot-net.invalid> - 2012-07-12 00:56 +0200
  Re: need regular expression to replace part of result based on a search pattern Roedy Green <see_website@mindprod.com.invalid> - 2012-07-11 21:21 -0700
  Re: need regular expression to replace part of result based on a search pattern Jimmy <jimmy_please@yahoo.com> - 2012-07-12 07:28 -0700
    Re: need regular expression to replace part of result based on a search pattern Eric Sosman <esosman@ieee-dot-org.invalid> - 2012-07-12 11:24 -0400
      Re: need regular expression to replace part of result based on a search pattern Joshua Cranmer <Pidgeot18@verizon.invalid> - 2012-07-12 11:42 -0400
      Re: need regular expression to replace part of result based on a search pattern Arne Vajhøj <arne@vajhoej.dk> - 2012-07-23 22:55 -0400
  Re: need regular expression to replace part of result based on a search pattern Leif Roar Moldskred <leifm@dimnakorr.com> - 2012-07-12 09:42 -0500
    Re: need regular expression to replace part of result based on a search pattern Gene Wirchenko <genew@ocis.net> - 2012-07-12 09:18 -0700
    Re: need regular expression to replace part of result based on a search pattern glen herrmannsfeldt <gah@ugcs.caltech.edu> - 2012-07-12 18:34 +0000
    Re: need regular expression to replace part of result based on a search pattern Arne Vajhøj <arne@vajhoej.dk> - 2012-07-23 22:53 -0400
  Re: need regular expression to replace part of result based on a search pattern Arne Vajhøj <arne@vajhoej.dk> - 2012-07-23 22:48 -0400
    Re: need regular expression to replace part of result based on a search pattern Arne Vajhøj <arne@vajhoej.dk> - 2012-07-25 17:37 -0400

csiph-web