Split Tab-Delimited Text From Scanned QR code

[Ponch]

I have QR codes on shop floor documents that contains entries for Item Code, Julian Code, Best Before Date and Production Date.

Each of these entries is delimited by a tab (Ascii code 9), for example CODE010 0109 18/04/2021 18/04/2020.

My question is - how do I split out each entry, so that I can put them into their own fields?

I’ve tried playing with the SPLIT function but cannot seem to find out how to identify the tab (for example, in Excel, if the above was in cell A2, I’d use =MID(A2,1,FIND(CHAR(9)-1,A2,1)) to get CODE010.

Many thanks for your time