REGEX TO PARSE NUMBERS IN NON-STANDARDIZED TEXT

I have input like this and need to extract LN# from each cell. The number I need are after "LN". I cannot figure out a Regex formula to parse the LN No out. Please help. Thanks.

Data:

SUNNY AVENUE INVESTMENTS, LLC LN 31600003462, COVERING INSURANCE DEDUCTIBLE FOR LOAN COLLATERAL PROPERTY

CHURU INVESTMENTS, LLC LN 816803472, COVERING INSURANCE DEDUCTIBLE FOR SBLC

HOPE PACIFIC 3900 LLC LN 76962939 THIS SBLC IS AN APPROVAL CONDITION FOR LN 76962939

Expected Output:

LN No

31600003462

816803472

76962939

Datasets

Regex

Parse

Preparation

Accepted answers

nagakavyasri

@Ewbkm : another way

Screenshot 2023-05-18 154614.png

Regex-parse.yxmd

All comments

binu_acs

@Ewbkm One way of doing this

Regex_180523.yxmd

nagakavyasri

@Ewbkm : another way

Screenshot 2023-05-18 154614.png

Regex-parse.yxmd

Ewbkm

Thanks. Your solution works. However, I am not sure it's my data or something else. With this REGEX formula applied to my data, it split out additional 30 fields before the last column, which the only one I need. I attached the original data for you to try. I know I can just use Select to choose the column I need to continue but just curious if there is any way we can parse without the blank columns?

Thanks..

sblc missing acct.xlsx

binu_acs

@Ewbkm Your Excel had so many blank columns and blank rows which were causing the issue, I deleted all the unwanted rows and columns and attached the workflow

Regex_180523.yxzp

sblc missing acct.xlsx

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703