REGEX to split String of TEXT

anovohatski1

Good morning,

I am fairly new to RegEx so hoping that someone could help me out. I am looking for a way to split out two types of text string, but failing. Any suggestions or ideas are highly appreciated. 

String Type 1

NUMBER #: 1234567890 ABC OF ABC (could be anything)    TYPE: 99 ABC

Current attempt at REGEX (output method parse): .:*(\d+) which only gives me 1234567890 and nothing else

String Type 2

ABC1 1,111,111.11      11.11       0.00

Current attempt at REGEX (output method parse): (\d+)([^\d]([^\s]+).*?(\d*\.\d*) which gives me the following output. Any suggestions on how to make this expression better?

RegEx Output 1: 1

RegEx Output 2: 

RegEx Output 3: 1,111,111.11

RegEx Output 4: 11.11

Once again any help with this is highly appreciated.

David-Carnes

@anovohatski1 

Sorry I misunderstood your intent.
Use this to parse the string into four columns:

NUMBER\s\#\:\s+(\d+)\s+([\w\W]+)\s+TYPE\:\s+(\d+)\s+(\w+)

The second output, ABC OF ABC, will have trailing spaces, so be sure to clean that up.

Good luck and have fun!