Help with delimited text parsing in pattern?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2021 08:50 AM
Hello - I am trying to parse below plain text output to various temp variables but I couldn't do it. Can someone please validate and give me the right direction?
I am trying to store variables after '=' in temp variables
Thanks!
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2021 09:50 AM
So got two ways and I really dont like either but checking with the big brains around the water cooler, these are your options...
so starting with a similar file...
then you parse out just the name and put it in a temptable.name
rinse and repeat for version.
OR
grab the individual returns, "knowing" what each value field will be [1]=name [2]=verison
Or
bring both pairs into a temptable then parse that table out again to retrieve the name and version lines individually
like i said, its not the prettiest way of doing it but should get you over the proverbial hump.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2021 10:01 PM
You can make use of the regex, or you can use an eval script to get the 2 values in a table,
You can refer "Linux Server" pattern under "Linux storage" library Step: "Insert data to proc_ide".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2021 08:14 PM
You can use the Filter table operation to retrieve the target value
1. Parse the command output/ variable/ File using delimiter to populate data in the table format.
Example -Parse the variable using delimiter "=".
2. Use Filter table operation to get the target value.
Example -Get the version value