0

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
6
Views
8 Years
Discussion Span
Last Post by mimsc
0
replace({STRING_ARRAY},{VALUE TO FIND},{REPLACE VAL})

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

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.