Welcome to the Airtable community!
If all of the records will have this exact format, you could use formula fields to extract the two parts. Then use a linked record field and lookups/rollups to get the values in the other table.
The exact format of the formulas depends on the exact structure of the data.
If you want to go a scripting route, that is also possible. How far have you gotten so far?