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.
Tried searching the boards for a similar issue and don't see one that is similar to this. Hoping someone can assist as I'm a Regex newbie.
I basically have a bunch of support documents that have a identification code up front followed by the name of the support. These codes can vary in length and the characters that follow the digits can also vary. Here's a rough example:
File naming conventions
What I need to pull
All I'm after are the codes at the front. I'm having a heck of a time with this as my trusty ol' text to columns doesn't seem to work super well when the delimiter can be an underscore, space, hyphen, or not exist at all. Any thoughts?
Thank you Qui and treepruner for the regex tool examples, it looks like the solution is fairly simple! I definitely need to spend some time learning this a bit more. In that vein, thank you for the link treepruner. I will give it a look!
Thank you for the formula MarqueeCrew. I knew the formula tool can do a lot of Regex magic but have never given it a shot. I'll definitely look at ways to try and integrate these in my workflows once I have a better handle on the subject.