Unsolved Need Regex Help
-
@dustinb3403 said in Need Regex Help:
@pete-s Thank you for the help, unfortunately it appears I'm limited to PostgresSQL regex like below or directly selecting the installed software from the list of thousands of items.
I have no options for a subquery, at least that I can see at the moment.
Yeah, well you're not going to find a regex solution. Simply because you need to look at several rows of information to determine if the computer has software or not. That's why it's not going to work.
If you could put have all the software into one column then you could use regex to find the rows that doesn't have the software installed. So if you had a string with "Microsoft,Libre,MyTax,Anti-virus " you could use regex on that and it would work fine.
-
@pete-s yeah that is what I'm feeling as well. . . sadly. This really needs to be somehow capable with the tooling, even if I'm not able to implement it.
-
@dustinb3403 said in Need Regex Help:
@pete-s yeah that is what I'm feeling as well. . . sadly. This really needs to be somehow capable with the tooling, even if I'm not able to implement it.
I haven't heard of BrightGauge before. Maybe it's big in the market, I don't know.
Regardless of that, it looks very capable on their website but that's because that's what marketing does - makes things look good.
The actual technical capability of the product is unknown until it's put to use. In your case unfortunately it looks like the product can't get the job done.
Maybe you're trying to hammer with a screwdriver or the hammer you have is just crap. In either case the support should be able to help you.
-
@pete-s said in Need Regex Help:
@dustinb3403 said in Need Regex Help:
@pete-s yeah that is what I'm feeling as well. . . sadly. This really needs to be somehow capable with the tooling, even if I'm not able to implement it.
I haven't heard of BrightGauge before. Maybe it's big in the market, I don't know.
Regardless of that, it looks very capable on their website but that's because that's what marketing does - makes things look good.
The actual technical capability of the product is unknown until it's put to use. In your case unfortunately it looks like the product can't get the job done.
Maybe you're trying to hammer with a screwdriver or the hammer you have is just crap. In either case the support should be able to help you.
It very well may not be up to task, or it could very well be my limited use of the tool and familiarity with it.
-
@dustinb3403 said in Need Regex Help:
@pete-s Thank you for the help, unfortunately it appears I'm limited to PostgresSQL regex like below or directly selecting the installed software from the list of thousands of items.
\b(?!:Microsoft|Anti-Virus)\bI have no options for a subquery, at least that I can see at the moment.
Are you able to access the database outside of whatever tooling they provide? Being PostgreSQL, you should be able to. Get to the point where you can write your own query and go from there (you can do most anything with the data you want then.)
-
@travisdh1 No, backend database access isn't available to me.
-
@dustinb3403 said in Need Regex Help:
@travisdh1 No, backend database access isn't available to me.
Well, that's a little ****y. No db gui has given me everything I wanted to do with a database.
