mapping string values with corresponding formats

Question

I have to process many strings( thousands ) which are in either of the two formats as below:

============= Examples of Str=============
123|S|122.14, 
S,344,122.146 

==============================================
The format of these strings are 
A|B|C 
B,A,C

I want them as A=123 B=S C=122.14

and A=344, B=S, C=122.146 ( where A , B , C correspond to column names and can be loaded into sql server db )

How do I do this.

I can use split to get the substrings as values. How do I map these values with formats and load them?

Please help. Thanks

juergen d · Accepted Answer · 2012-04-10 09:07:41Z

1

You could do something like:

String str = "123|S|122.14,";
String[] tokens = str.split("[|,]");
String A;
String B;
String C;
if(tokens[0].equalsIgnoreCase("S"))
{
    A = tokens[1];
    B = tokens[0];
    C = tokens[2];
}
else            
{
    A = tokens[0];
    B = tokens[1];
    C = tokens[2];
}

edited Apr 10, 2012 at 9:07

answered Apr 10, 2012 at 7:26

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

1 Comment

juergen d Over a year ago

@AlexeiKaigorodov: You are right. I missed that. Updated the answer.

dpnmn · Accepted Answer · 2012-04-10 09:13:05Z

0

String[] ABC; 
if( line.contains( '|' ) ) {
   ABC = str.split( "|" ); 
} else {
   String[] split = str.split( "," ); 
   ABC = new Object[] { split[1], split[0], split[2] ); 
}

answered Apr 10, 2012 at 9:13

dpnmn

5532 silver badges8 bronze badges

1 Comment

dpnmn Over a year ago

And then String A = ABC[0], B=ABC[1], C=ABC[2] if you prefer.

Collectives™ on Stack Overflow

mapping string values with corresponding formats

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related