Extract part of text in a variable

Question

I am creating a script to backup some directories via powershell, but for a certain directory, I want to access a file, read a line and return a string with part of the line.

XPTO file has the following structure:

;===============================================================
;--------------------AMBIENTE DE PRODUÇÃO-----------------------
;===============================================================

[C4P12LEAD]
SourcePath=E:\Outsourcing\Clientes\c4p12lead\apo\20180828
RootPath=E:\Outsourcing\Clientes\c4p12lead\protheus-data
CtreeRootPath=E:\Outsourcing\Clientes\c4p12lead\protheus-data
StartPath=\system\
x2_path=
RpoDb=top
RpoLanguage=por
RpoVersion=120
LocalFiles=ctree
Trace=0

I need to return the path of the line that contains Sourcepath: SourcePath =E:\Outsourcing\Clientes\c4p12lead\apo\20180828

And put that path in a Sourveapo variable: E:\Outsourcing\Clientes\c4p12lead\apo\20180828

At the end of the process the $Sourveapo variable needs to have the content E:\Outsourcing\Clientes\c4p12lead\apo\20180828

How am I gonna do that?

Answer 1

Break the text into lines, search for its tag and then take the value by text position.

$text = "
;===============================================================
;--------------------AMBIENTE DE PRODUÇÃO-----------------------
;===============================================================

[C4P12LEAD]
SourcePath=E:\Outsourcing\Clientes\c4p12lead\apo\20180828
RootPath=E:\Outsourcing\Clientes\c4p12lead\protheus-data
CtreeRootPath=E:\Outsourcing\Clientes\c4p12lead\protheus-data
StartPath=\system\
x2_path=
RpoDb=top
RpoLanguage=por
RpoVersion=120
LocalFiles=ctree
Trace=0";

$token="SourcePath"
$extractedValue = (($text -split [System.Environment]::NewLine) | where { $_ -Like "$token*" }).Substring("$token=".Length);
Write-Host $extractedValue