Extracting text from Variable and save it on a file

Welcome Forums General PowerShell Q&A Extracting text from Variable and save it on a file

Viewing 1 reply thread
  • Author
    • #191002
      Topics: 6
      Replies: 16
      Points: 90
      Rank: Member

      Hello Experts,

      I am fetching some details using powershell using REST APIs and i would like to filter the output from that huge list and save it on a text file.


      Below is just the part of the script:


      foreach ($Incident in $Requests.result) {
      $output =$Incident | ft description -Wrap | out-string

      $output | Out-String | Export-Csv -NoTypeInformation -Path C:\Temp\t.txt


      the t.txt file doesnt contain the value i need.  It rather shows below info:




      I need a way to extract information from Description table and save it on a file for further use.

    • #191059
      Topics: 5
      Replies: 2372
      Points: 6,005
      Helping Hand
      Rank: Community MVP

      It’s gonna be hard to give reasonable advices how to deal with the input data when you don’t have a clue what the input data looks like. What I can tell from overviewing your code:

      Please format your code as code – you may read the first pinned post on top of the list of posts in this forum recommending to read it before posting: Read Me Before Posting! You’ll be Glad You Did!
      Please do not use aliasses. They make the code harder to read.
      Please use format cmdlets like Format-Table always as the last cmdlet in a pipeline.
      If you like to have CSV file you should name it as such and you should use descibing names vor file names and variables.

      You may read The Unofficial Powershell Best Practices and Style Guide.

      You may post some of the input data as well ( sanitized and formatted as code as well ) if it’s crucial to understand your request.

      May I suggest to try the simplest way to deal with this task:

      $Requests.result | 
          Export-Csv -Path C:\temp\RestApiFilteredData.csv -NoTypeInformation
Viewing 1 reply thread
  • The topic ‘Extracting text from Variable and save it on a file’ is closed to new replies.