Parsing Text after specific wording\Characters
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to parse out this string, NAME]:VOLUME [CLASS]:STORAGE VOLUMES [GUID]:************************** [DEVICEID]:*************************************
I only want the information after [DEVICEID]: The information after deviceid varies in length and information that will be in this field.
I have not been able to get this one, I have tried text to columns with ]: as my delimeter, I have tried regex with multiple different statements.
Anyone have hints, or tricks?
Solved! Go to Solution.
- Labels:
- Expression
- Parse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
^.*\[DEVICEID\]:(.*$)
Try the Regex above. You need to escape the '[' & ']' characters in order for the Regex statement to work.
Hope this helps and Happy Solving!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, I tried your suggestion and modified it. ^.*\'['DEVICEID\']':(.*$) Is this what you meant by escaping the brackets? I will be honest I am not well versed in Regex.
I did try the expression I have in this reply, but I got NULL output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
An alternative quick fix solution would be to use a formula tool to replace where you want the split to occur with something like a pipe, and then use that as your delimiter in a Text To Columns tool. A formula along the lines of the following would do the trick: Replace([String], '[DEVICEID]:', '|')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Hub119
I tried your suggestion, this took out everything related to DeviceID. I was looking to only get the information after DeviceID
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bliffick see the attached workflow, and let me know if this is what you are trying to accomplish or not.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
