Hi, I have many thousands of records like the below:
<tbody>
</tbody>146J.1381.122.128.T.8.51848388-2753672-113
I want to be able to delete the fourth sub-string of the seven total in each case, and preserve the rest of the contents of each record. That is, in the above examples I want to be able to delete these: .2, .128, .2, .28, .32, . 64, .124, and .128
And have resulting records like these:
<tbody>
</tbody>146J.1381.122.T.8.51848388-2753672-113
I would be most grateful for your help, thank you.
Alfie101
128K.1381.122.2.A.8.51856273-2753672-113 |
128K.1459.111.128.A.8.51769315-2753672-113 |
128K.1459.111.2.A.8.51467685-2753672-113 |
130E.1456.122.28.A.8.51543816-2060102-1 |
130E.1456.122.32.T.8.51543816-2060102-1 |
130E.1456.122.64.A.8.51543816-2060102-1 |
130E.1567.100.124.A.8.51331082-2060102-1 |
<tbody>
</tbody>
I want to be able to delete the fourth sub-string of the seven total in each case, and preserve the rest of the contents of each record. That is, in the above examples I want to be able to delete these: .2, .128, .2, .28, .32, . 64, .124, and .128
And have resulting records like these:
128K.1381.122.A.8.51856273-2753672-113 |
128K.1459.111.A.8.51769315-2753672-113 |
128K.1459.111.A.8.51467685-2753672-113 |
130E.1456.122.A.8.51543816-2060102-1 |
130E.1456.122.T.8.51543816-2060102-1 |
130E.1456.122.A.8.51543816-2060102-1 |
130E.1567.100.A.8.51331082-2060102-1 |
<tbody>
</tbody>
I would be most grateful for your help, thank you.
Alfie101