Extract multiple 10 digit value from a string seperated by a space

[Ahmediqbal]

Hi there, I am trying to extract the invoice number from a bank statement line using the regex tool but cannot figure it out. The invoice number generally starts with 9; one statement line can have multiple invoices. Each statement has over 200 lines. 

Input : 343319020720230203001352969860868418 9062990141 9062990142 9860868760 9070853746 9070853747 9070853748 9860868677 9860868678 9860868679 9860866363/PT/FT/PY/9860868418 9062990141 9062990142 9860868760 9070853746 9070853747 9070853748 9860868677 9860868678 9860868679 9860866363/OA/USD12321333,23/BI/816467004/BN/BNK COUNTRY/ bANK NAME

Output: 9062990141 9062990142 9860868760 9070853746 9070853747 9070853748 9860868677 9860868678 9860868679 9860866363

[flying008 · Accepted solution]

Hi, @Ahmediqbal 

FYI.

Spoiler

^[0-9]+?\s(9(?:[0-9\s]+))(?=\/PT)

[ArnaldoSandoval · Accepted solution]

Hi @Ahmediqbal 

I am using these rules:

• The invoices start with space 9.
• After the last invoice the text start with a forward slash.

Regards,

Arnald

[Felipe_Ribeir0 · Accepted solution]

Hi @Ahmediqbal 

Try to tokenize with (\b\d{10}\b)

[Ahmediqbal]

Thank you all!