This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to do the same thing, but i don't want to leave off any part of the field. So, for example, if one of mine is 20180109, I need to have a separate column for year, month and day.
I've been trying the RegEx tool with parse but I don't know how to construct the expression - and I have looked at multiple other places in the community and if it is answered somewhere I don't see it.
This is what I have, but when I run it, my Month Day and Year fields are Null.
I did not figure out how to do it. I found a different angle to approach that worked much better. What's your specific issue? My other approach may or may not be helpful to you, but if it is, I'd be happy to help.