How to pick up the "&" character in a text field using RegEx?

Falnangel

I have a text field with content such as this "2016-01-30_2.Monthly_P&L". I'd like to parse the field into 4 fields: Year, Month, Date and just a Name field so the fields would be:

2016-01-30_2.Monthly_P&L	2026	01	30	2.Monthly_P&L

I used this RegEx expression "(\d+)-(\d+)-(\d+)_(\d+\.\w+\_\w+\&\w+)" but result looked like this:

2016-01-30_2.Monthly_P&L	2026	01	30	2.Monthly_P

I've tried replacing the "&" in my expression with "&amp" or "amp" and results still doesn't seem to pick up the "&" correctly.

How do I pick up the "&" in a field so it can parse properly?

Thanks in advance.

alexnajm

Your RegEx expression worked for me! What part isn't working?