REGEX PARSE CODE

[dunkindonut7777]

Hi I have a data here that I want to parse some of the field.

I want to separate the values under the Code field. Please refer to Desired Output field.

Code (Raw)	Desired Output
ID 48424 XYZ DOCTORS HOSPITAL (CLINICA HILARIO), INC. (Posted by CORLITO NAVARRO on 10 Aug 2021)	48424
Account	Null
Accounts Receivable Trade (12101)	Null
Accounts Receivable Trade (12101)	Null
ID 42319 ST. ELIZABETH HOSPITAL, INC. (Posted by JEREMY LENIETH GADE on 20 Apr 2021)	42319
Account	Null
Accounts Receivable Trade (12101)	Null
REVENUE - Reagents Reselling - SEHI (40207)	Null
VAT Payable (2520)	Null

[DataNath]

ID\s(\w+) Should do the trick here.

[binuacs]

@dunkindonut7777  one way of dong this with the Regex Tokenize method