REGEX PARSE NUMBER

[dunkindonut7777]

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

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

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

[DataNath]

@dunkindonut7777 give this a whirl:

(\d{2}\s[a-zA-Z]{3}\s\d{4})

[grazitti_sapna]

@dunkindonut7777  try this (\d+\s\w+\s\d+)

[DataNath]

If you then want to format your date as it appears in your example output then you can use the following:

Or you can do the whole thing in one, like so (workbook attached):

[grazitti_sapna]

@dunkindonut7777 , to fetch the names.

(?:Posted by\s)([A-Z\s]+)(?:on)

Thanks!