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

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

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

Show key headers only | View raw

On 12/07/2012 00:40, Knute Johnson allegedly wrote:
> On 7/11/2012 10:35 AM, Jimmy wrote:
>> Have been having hard time to come up with the regular expression to
>> replace the following..
>>
>> 1,"blaha",NULL,'N','Y','N','N',NULL
>> 2,"blahb",NULL,'Y','Y','Y','N',NULL
>> 3,"blahc",NULL,'N','N','N','N',NULL
>>                          ^
>>
>> With all contents in column #6 (first column is column #1) to 'Y'?
>>
>> i.e. result
>>
>> 1,"blaha",NULL,'N','Y','Y','N',NULL
>> 2,"blahb",NULL,'Y','Y','Y','N',NULL
>> 3,"blahc",NULL,'N','N','Y','N',NULL
>>                          ^
>>
>> Thanks,
>> Jimmy
>>
> 
> public class test {
>     public static void main(String[] args) {
>         String str = "3,\"blaha\",NULL,'N','N','N','N',NULL";
> 
>         System.out.println(str);
> 
>         String[] arr = str.split(",");
>         if (arr[5].equals("'N'"))
>             arr[5] = "'Y'";
> 
>         StringBuilder sb = new StringBuilder();
>         for (int i=0; i<arr.length; i++) {
>             sb.append(arr[i]);
>             if (i != arr.length - 1)
>                 sb.append(",");
>         }
>         System.out.println(sb);
>     }
> }
> 

Not handling the case where there is a separator (comma) within a
(quoted) field.

Regex could only be a solution if such a case were excluded.

-- 
DF.

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