I have two types of number in my shapefile/database in the same column as follows. The first one does not have any alphabetic character but second one has alphabetic characters.
(a) 26 25 21 0000 00200 0000 (b) 27 25 21 0050 00000 001A
There is one space between the blanks as it can be seen from the number. The number given are mismatched. Here, in the first example, the 21 should take the place of 26 and 26 should take the place of 21 and in second example, 21 should take place of 27 and vice-versa. For example, this is the output I am after:
(a) 2125260000002000000 (b) 212527005000000001A
How can I replace those numbers using the field calculator?