mapping string values with corresponding formats

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

---