I've amended the code slightly to extract the relevant data for 4G EE, as this differs the most from other data.
Currently it looks like this:
When looking at the number after the last / from the relevant column, this code need to work with the 2nd / and to replace the last / with a 0 or 2 x 0.
For for example, the data from Column G for 4G EE currently looks like this: LTE 234/30/11858/9
I am interested in the 11858/9 part, so after the 2nd /.
However, IF the number at the end is one digit then the / needs to be replaced with 00 and if the number at the end is 2 two digits then the / needs to be replace with 0
- For example, based on LTE 234/30/11858/9 the number to be extracted to the location table would be 11858009
- Based on LTE 234/30/10644/14 then the number to be extracted to the location table would be 10644014
If you understand what I mean?
Massive thank you once again :-)
Bookmarks