.*(\d{4}-\d{2}-\d{2})\s([\d\.]*).*([CP]).*
A RegEx explanation since @vvissamsetty requested -- posting to the thread in case others have a similar question:
. -- Any Character
* -- Repeat 0 or many
Find any character and repeat until next argument in RegEx String
\d Any digit
{4} - Exactly 4 repeating digits
{2} - Exactly 2 repeating digits
- means -
\s space
[\d\.*] -- find any digit or . and as many repeating digits or . -- brackets mean [] any of the inside characters
\. means . since RegEx counts a . as any character you have to escape special character with a preceding /
[CP] -- find either a C or a P
() -- Capturing Group -- this tells the RegEx tool which character groups to extract into a column -- each () group goes into a separate column
You'll notice several instances of .* not in () -- you have to replicate the text using RegEx Syntax in order for it to work. For example, the space between the date and number must be handled -- you can use \s for a space or a (.*)--wildcard I prefer using a more specific RegEx Identifier if possible like the space to avoid unintended matching.
I use https://regexr.com/ to test more complicated situations, and save time of running through a workflow, then paste it into the tool.
Happy to help, since I had a similar question answered on the community many years ago which helped me learn RegEx.
Thanks.
