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 need some assistance building out logic that would parse a string with data in the following format:
I want to parse the string to just remove the ID field. The challenge is that the ID field is not always the same character length each time. I think the best approach would be to use regex to find 3 characters and stop at underscore. I need help building out that logic in regex. Please let me know if you an idea.
Ideally I would not like to spread it across multiple columns. I would think regex would be the best approach since the ID isn't generally in the same place. Let me know what you think at your earliest convenience.
If you are just trying to parse everything inbetween the Underscores, this should work fine. This expression will remove everything before and after the underscores, and grab everything inbetween the underscores.
This is a good approach, but unfortunately the ID is not necessarily after or before the first underscore . There some values where the ID is embedded after a few underscores and text. An example of this would be :
In this case I dont believe your solution will work. Would happen to have an alternative work around? I appreciate your help.