Escaping commands within a lookup


(Jake Smith) #1

HI All,

Is it possible to use the following in a lookup tale

Get-PSDrive | where {$_.Provider -like “Microsoft.PowerShell.Core\FileSystem”}| ft Name,Root

This is a powershell one liner to find c:\ drive etc.

I want to use it in a lookup table, but what about the quotes, wont they break the csv file?

Cheers

Jake


(Jochen) #2

It’s possible to configure the quote character in the CSV File data adapter:


(Jake Smith) #3

Hi Jochen,

Can you use an obscure character such as ` or ^ as your quote character as the strings in the csv have both single and double quotes?

Cheers

Jake


(Jake Smith) #4

Hi Jochen,

Or maybe { as a quote character?

Jake


(Jochen) #5

Sure, any ASCII character which isn’t part of the quoted values should work.

It’s possible, but it doesn’t look good.

id,value1,value2
1,{some quoted value{,{another quoted value{

(Jake Smith) #6

Hi Jochen,

Here is an example which i know looks horrid but works with [ as quote character and ; as a separator

[Command[;[Category[
[Get-ChildItem Env: | ft Key,Value[;[Privilege Escalation[
[$env:UserName[,[Privilege Escalation[
[Get-LocalUser | ft Name,Enabled,LastLogon[;[Privilege Escalation[
[Get-ChildItem C:\Users -Force | select Name[;[Privilege Escalation[
[Get-LocalGroup | ft Name[;[Privilege Escalation[
[Get-LocalGroupMember Administrators | ft Name, PrincipalSource[;[Privilege Escalation[
[Get-ItemProperty -Path 'Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\WinLogon' | select "Default*"[;[[Privilege Escalation[

I posted so that if someone else needs similar functionality they can see how to do it.

Cheers

Jake


(system) #7

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.