I need a way to extract 2 pieces of info from a couple of thousand lines of an Excel spread sheet.
ex.
| 011001962O1210003742071807122203950CATHAY BANK? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 4128 TEMPLE CITY BLVD R5-14? ? ? ? ? ? ? ? ROSEMEAD? ? ? ? ? ? ? ? ? ? ? CA917700000626582733811? ? ? ? ? |
I need to get the first six numbers and the bank name. The initial number of integers prior to the Bank name is not fixed.
Can be a t-sql statement or c# snipet