Extracting multiple user attributes via regex
5 posts · Closed
Hi Andrew.
Seeking advice. Looking for suggestions. Imagine you have a script that can show more than one value of information. For example, a script that looks through the Active Directory to find more than one user attribute: name, organization, address, phone.
But to show each value alone, in its own column, you run the same script more than once and apply different regex to each column.
Is there any opportunity to do this without running the same script? Like cloning the columns and applying the regex.
Sounds like an interesting idea. I guess it may be called 'Virtual Columns' or something where those columns take values from one or more real columns.
This way one can split multiple values from one column with regex as well as combine values from multiple real columns. What do you think?
Excellent!!!! Thanks!!
Added in version 7.0.3. It takes values from one or more specified columns, applies a regular expression and outputs the result.
Here for example, CPU frequency was extracted into a separate column:
[image: https://i.imgur.com/KkD1Vvn.png]
Another improvement in this version is that most items can be quickly edited without having to go to the specific scan and finding the entry.
[image: https://i.imgur.com/OYsRsIj.png]
Nice work. Thanks Andrew! Thanks rmpf2 for this helpful suggestion and feature. -WS