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
解決済! 解決策の投稿を見る。
This might simple but if your data goes in this pattern it works well.
Parse Method with Regex Tool
.*\s(.*?)\s(.*)$
Cheers,