[Solved] Relevance Question: 3 registry values w/ semi-colon separators instead of commas?

Content Authoring
1

Does anyone know if there’s a way to use semi-colons instead of commas for the seperators below? I was planning on running an analysis against all machines that have a Chrome App installed and then use Excel to break the 3 properties into their own columns. Unfortunatley, it’s looking like a lot of the DisplayName properties already contain a comma in the name which will likely break what I was wanting to do. We’ve had a bunch of Google Apps show up in the environment, but we also want to see what else is out there. Thanks in advance!

q: (values "DisplayName" of it, values "InstallDate" of it, values "UninstallString" of it) of keys whose (value "Publisher" of it as string as lowercase = "Google\Chrome" as lowercase AND value "UninstallString" of it as string as lowercase contains "chrome.exe" as lowercase) of keys "SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of keys of key "HKEY_USERS" of registry
A: YouTube, 20230905, "C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=agimnkijcaahngcdmfeangaknmldooml
A: Gmail, 20230905, "C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=fmgjjmmmlfnkbppncabfkddbjimcfncm
A: Slides, 20230905, "C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=kefjledonklijopmnomlcbpllchaibag
A: Google Drive, 20230905, "C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=aghbiahbpaijignceidepookljebhfak
A: Sheets, 20230905, "C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=fhihpiojkbmbpdjeoajapmgkhlnakfjf
A: Docs, 20230905, "C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=mpnpojknpmmopombnjdcgaaiekajbnjb
T: 4.835 ms
2

Sure, just throw

(concatenation ";" of (item 0 of it as string; item 1 of it as string; item 2 of it as string)) of ...

At the front of the query

3

Actually for excel may be easier to tab-delimit by inserting ASCII 0x09 (tab) as the delimiter

(concatenation "%09" of (item 0 of it as string; item 1 of it as string; item 2 of it as string)) of ...
1 Like
4

I tried a concatenation, but didn’t have the parenthesis placed right. Thank you as always, Jason!

1 Like