S
samcannet
I have data that is not in a consistent format that needs to be split
in to two different fields. I have provided samples below. What formal
could I use to split this out?
Orig Column1 Column2
PanelNum Should be Should be
0002 0002
0005C 0005 C
0002B 0002 B
01A 0001 A
0005B 0005 B
04 0004
I only need the last character if it is Alpha.
Thanks for your help
in to two different fields. I have provided samples below. What formal
could I use to split this out?
Orig Column1 Column2
PanelNum Should be Should be
0002 0002
0005C 0005 C
0002B 0002 B
01A 0001 A
0005B 0005 B
04 0004
I only need the last character if it is Alpha.
Thanks for your help