Dear All
I need the data in the table (vehicle number column) to be loaded in the manner how 4th row number is appeared(WP_SY_2530).Hence all numbers need to be arranged 1st two letters then underscore then the 2nd two letters again underscore & the last four numbers. how this could be done?
Many thanks in advance
Neville
| SG-JK-2541 | 14500 |
| WP-PG-1825 | 20000 |
| WP_KN-1425 | 12500 |
| WP_SY_2530 | 45000 |
| WPLK-1525 | 22500 |
| WPOP-2852 | 15000 |
| WPXD8520 | 25000 |
