Change a character variable to multiple variables

[Jason2020]

I have a data set that has a character variable ($poc) and would like to replace it with 2 new variables: t (F2.0) and site ($2). Is that possible without the need to output to a raw data file and re-enter it? Thanks.

Have:

POC17DB

POC17BB

POC17MB

POC17ML

POC17LL

POC17DL

POC16DB

POC16BB

POC16MB

POC16ML

POC16LL

Want:

17 DB

17 BB

17 MB

17 ML

17 LL

17 DL

16 DB

16 BB

16 MB

16 ML

16 LL

[HB]

Will your data always be 

Three letters

Two numbers

Two letters

or can you have single digit or three digit numbers and single letter or three letter sites?

[Jason2020]

Yes the data has a fixed format: 3 letters, 2 numbers, 2 letters

[Peter_C · Accepted solution]

Have a look at the input() and substr() function documentation

[Jason2020]

Thanks Peter. I solved it using the substr function:

  a = substr(site, 4, 2);
  b = substr(site, 6, 2);

Thanks again.