Regex to parse numbers and text

Hi, I have the following data that needs to be entered in 5 columns:

How can a Regex be used to do this?

Thanks.

Regex

Accepted answers

As I'm looking at it, I will still use a bit of fixed width for the first 2 columns and them regex for the last 3.

Example attached.

Best,

Fernando Vizcaino

This is a fixed width file problem so you can open your txt file as a .flat file and select the 'fixed width text file' as image below.

Then after confirming, it will open a layout pop-up where, by clicking, you decide where to cut your columns.

I'm sharing an example with you. To open the file layout, see image below.

Best,

Fernando Vizcaino

sorry, the data is incomplete, not all strings are the same length. I updated the data.

Thank you for your help!