Java replace string

Question

Hi all I a have the following code in my java application

DROP TABLE IF EXISTS "countries";
CREATE TABLE "countries" (
  "CNT_ISO2" varchar(2) NOT NULL,
  "CNT_CODEN" int(11) NOT NULL,
  "CNT_NAME" varchar(100) NOT NULL,
  "CNT_NAME_SHORT" varchar(50) NOT NULL,
  "CNT_CONTINENT" int(11) DEFAULT NULL,
  PRIMARY KEY ("CNT_ISO2")
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

using java I want to replace all varchar with another character say text

eg:- Both varchar(2) and varchar(50) should be replaced with text

Thanks......

Dmytro Chyzhykov · Accepted Answer · 2012-07-28 15:14:03Z

2

Try the following code:

stmt.replaceAll("varchar(\\(\\d+\\))?", "text");

answered Jul 28, 2012 at 15:14

Dmytro Chyzhykov

1,8541 gold badge20 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Rakesh Over a year ago

Thank u Dmytro thats working fine ...can u please explain that..?

Marko Topolnik Over a year ago

Rakhesh, this is replacement by Regular Expression. All the \ signs are needed to escape the special meaning of the parentheses.

Marko Topolnik Over a year ago

@DmytroChyzhykov It's kind of lame to just copy my answer, don't you feel that way? It's what I call "karma vulture" behavior. The proper way was to edit my answer and just add two characters into it. I understand, with your rep still in the low three-digit range, but as you move on, please do mind the rules of conduct.

Dmytro Chyzhykov Over a year ago

@Marko Topolnik. Sorry for that. Nothing personal. I've voted your comment in place.

Marko Topolnik · Accepted Answer · 2012-07-28 15:34:22Z

1

I think your solution can be as easy as

stmt.replaceAll("varchar(\\(\\d+\\))?", "text")

edited Jul 28, 2012 at 15:34

answered Jul 28, 2012 at 14:43

Marko Topolnik

201k31 gold badges336 silver badges455 bronze badges

6 Comments

Paul Tomblin Over a year ago

No, .replace takes a char, not a string. I think you mean stmt.replaceAll("varchar([0-9]*)", "text");

Marko Topolnik Over a year ago

@PaulTomblin Please, do bother to actually check the Javadoc. But you are right in pointing out that the parenthesized numbers need to be removed.

Dmytro Chyzhykov Over a year ago

@Marko Topolnik. There is a few mistakes in your code. Just double the first and the last / symbols.

Paul Tomblin Over a year ago

@MarkoTopolnik, unlike you I did check the Javadoc. Why don't you follow the link you posted, and you'll see that the signature for .replace is either String replace(char oldChar, char newChar) or String replace(CharSequence target, CharSequence replacement). Neither takes two Strings as an argument.

Paul Tomblin Over a year ago

You are correct. I missed that String is now a subclass of CharSequence. My apologies.

|

Collectives™ on Stack Overflow

Java replace string

2 Answers 2

4 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related