Regex to extract

[vvissamsetty]

Hi Guys,

I'm very new to Regex and trying to extract the Month and the number from a huge data which looks like this 

C/OGBPS STOBB 50 PR INDEX OCT20 3545

C/O A B 500 INDE DEC 2300.00

P/O A B 500 INDE JAN 2335.00

C/O A B 500 INDE AUG 2925.00

So basically, I want everything with date into one column and the last column of numbers into one column. Can some one help me with this?

Thank you

[Thableaus · Accepted solution]

Hi @vvissamsetty 

This might simple but if your data goes in this pattern it works well.

Parse Method with Regex Tool

.*\s(.*?)\s(.*)$

Cheers,

[vvissamsetty]

Thanks @Thableaus.