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 · Accepted solution]

Hey @dunkindonut7777, the following should work, unless there’s any chance of wildly deviating from the examples provided:

.+\((\d+\))

[DataNath · Accepted solution]

Sorry, second escape character was before the wrong bracket. Should be:

.+\((\d+)\)

[dunkindonut7777]

Hi thank you for this can you parse also this one?

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 · Accepted solution]

Have replied to your other topic @dunkindonut7777 - the following should be fine:

ID\s(\w+)

[dunkindonut7777]

Hi Thank you for your help @DataNath. I have also to parse these two fields can you help me? Please refer to the desired output fields. Thankyou

(Raw)	Desired Output (Date)	Desired Output (NAME)
ID 48424 XYZ DOCTORS HOSPITAL (CLINICA HILARIO), INC. (Posted by CORLITO NAVARRO on 10 Aug 2021)	10-Aug-21	CORLITO NAVARRO
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)	10-Aug-21	JEREMY LENIETH GADE
Account	Null
Accounts Receivable Trade (12101)	Null
REVENUE - Reagents Reselling - SEHI (40207)	Null
VAT Payable (2520)	Null

[dunkindonut7777]

I want the expression only

[DataNath]

@dunkindonut7777 how do you get on with the following? Should be fine as long as format doesn’t change drastically:

Posted\sby\s([A-Z\s]+)\s

[dunkindonut7777]

How about the date? Can you give me the expression also?

[dunkindonut7777]

Hi @DataNath can you parse the date fields? I have a difficulty separating it

(Raw)	Desired Output (Date)
ID 48424 XYZ DOCTORS HOSPITAL (CLINICA HILARIO), INC. (Posted by CORLITO NAVARRO on 10 Aug 2021)	10-Aug-21
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)	10-Aug-21
Account	Null
Accounts Receivable Trade (12101)	Null
REVENUE - Reagents Reselling - SEHI (40207)	Null
VAT Payable (2520)	Null