Regex Syntax Help

[jessy_chow]

First time using regex, looking for some assistance on how to write the syntax for get the following

 This is the syntax that I have '.*(\d{6,}).*', '$1') but it doesn't give me my desired results. I'm not sure how or where I can adjust. 

THANKS FOR THE HELP! 

[mceleavey]

Hi @jessy_chow ,

Assuming this is representative of the consistent format you will be able to get the result using the following regex:

^(.*?)\s

This says "Take the string from the beginning to the first space.

Configure Regex as follows:

I hope this helps,

M.

[jessy_chow]

Thanks! 

It's close but my text has the astericks and 2 spaces before the text starts. 

[binu_acs · Accepted solution]

@jessy_chow another regex method

[jessy_chow]

It worked! Thank you!

[flying008]

Hi, @jessy_chow 

FYI.

^[*\s]*(\w+)\s