Hello,
in a table I have the following data:
data result
1234TM 1234 TM
3478PM 3478 PM
3489 3489
3845TL 3845 TL
1238 1238
When showing this data in a field it has to look like this:
first the 4 numbers then an interspace and then the 2 letters.
How can I do this?
Thanks in advance,
Sven.
in a table I have the following data:
data result
1234TM 1234 TM
3478PM 3478 PM
3489 3489
3845TL 3845 TL
1238 1238
When showing this data in a field it has to look like this:
first the 4 numbers then an interspace and then the 2 letters.
How can I do this?
Thanks in advance,
Sven.