Hello,
I have an array looking like this 082640-000-07332/001 and would like to convert it to 0826400000733200100 for a search clause?
I tried this:
sc <SPAN class="operator token">=</SPAN> line<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"["</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># 082640-000-07332/001 convert to 0826400000733200100</SPAN>
sc2 <SPAN class="operator token">=</SPAN> sc<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
sc21 <SPAN class="operator token">=</SPAN> sc2<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"-"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
sc22 <SPAN class="operator token">=</SPAN> sc21<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"/"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
sc23 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>sc21<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"00"</SPAN><SPAN class="punctuation token">)</SPAN>
sc3 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">,</SPAN> sc23<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> sc3<SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>but this code results in this (print sc3):
FLURSTUECKSKENNZEICHEN = 'u'08264000007138/000'00'
Any help would be great?
