Resolved: PowerShell regex needed to capture a field data

Question:

2022-05-02T09:36:07,034 INFO  [00000015] :AB-XXXXXXXXXXX@lllCORP - 3          %LET _CLIENTUSERID = 'crag';
2022-05-02T09:36:07,034 INFO  [00000015] :AB-XXXXXXXXXXX@GDLCORP - 3          %LET _CLIENTUSERID = 'Drkre';
2022-05-10T11:05:14,220 INFO  [00000015] :AB-XXXXXXXXXXX@FLLCORP - 3          %LET _CLIENTUSERID = 'Plgr2';
2022-05-10T11:05:14,220 INFO  [00000015] :AB-XXXXXXXXXXX@vLLCORP - 3          %LET _CLIENTUSERID = 'byref';
2022-05-10T11:05:14,220 INFO  [00000015] :AB-XXXXXXXXXXX@lLLCORP - 3          %LET _CLIENTUSERID = 'dfrg23';
2022-05-10T11:05:14,220 INFO  [00000015] :AB-XXXXXXXXXXX@XLLCORP - 3          %LET _CLIENTUSERID = 'FlogR1';

The expected outputs should look like below

crag
Drkre
Plgr2
byref
dfrg23
FlogR1

Thanks

Answer:

Okay, I’m assuming that the data is stored in a variable called $values and is an array where each entry of the array is an individual line, the following should extract your values as requested:

$values | % { [regex]::match( $_ , “(?<=')(.+)(?=')" ) } | Select -ExpandProperty Value [/code]

If $values is just a string containing the data, you can use the following instead:

[regex]::matches($values, “(?<=')(.+)(?=')" ) | Select -ExpandProperty Value [/code]

If you have better answer, please add a comment about this, thank you!

Resolved: PowerShell regex needed to capture a field data

Resolved: How do I use SetWindowText with Unicode in Win32 using PowerShell?

Resolved: Shopware 400 Status Error “This value is too long. It should have 255 character or less.” When I Try Updating Database Table

Resolved: Using AWK to count multiple patterns in a file

Leave A Reply