Member Avatar for mimsc

Thanx for the help yesterday..I was able to break down the string from my database:

('MCKINNEY','TX'),('ALLEN','TX'),('ANNA','TX')

using:

String strInput = userData.getMhtCityList();
String strProcess=null;
String strOutputs[]=null;
if(strInput!=null){
strProcess=strInput.substring(1,strInput.length()-1);
System.out.println(strProcess);
strOutputs=strProcess.split("\\'\\),\\(\\'");
}

worked like a charm

only problem now is those damn apostophies

'MCKINNEY','TX
ALLEN','TX
ANNA','TX'

any suggestions on stripping out the apostrophies out the array?

thanx

  • 2 Contributors
  • 5 Replies
  • 118 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by mimsc
Member Avatar for mwilliams6 
replace({STRING_ARRAY},{VALUE TO FIND},{REPLACE VAL})

Why wouldn't you look this up, its only a google search away.

Member Avatar for mimsc

why google when you have daniweb?

Member Avatar for mwilliams6

haha good point

Member Avatar for mimsc

no joke...I love this place..I havent used it in months, but when I did yesterday..I got like 4-5 positive responses...google is cool...but this is a more refined a focused search for help

Member Avatar for mimsc

btw...thanx for the method..it worked buddy!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.