count, split and extract values from a string
Posted on 2011-03-06
I have to the following data strings within a column :
014=1103021328 - 14 Characters
0248=1103051135 - 15 Characters
I understand to pull the date from the the second part after the '=' but sometimes I have 14 Characters and sometime data has 15.
I am trying to formulate how to extract the first part before the '=' (transaction number) and then the second part after the '=' which is actually the date but sometimes the string is 14 characters and sometimes it's 15