mapping string values with corresponding formats
<p>I have to process many strings( thousands ) which are in  either of the two formats as below:</p>

<pre><code>============= Examples of Str=============
123|S|122.14, 
S,344,122.146 

==============================================
The format of these strings are 
A|B|C 
B,A,C 
</code></pre>

<p>I want them as <code>A=123 B=S C=122.14</code></p>

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

<p>How do I do this.</p>

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

<p>Please help. Thanks</p>
