Specific text from txt file to Excel

Welcome Forums General PowerShell Q&A Specific text from txt file to Excel

  • This topic has 1 reply, 2 voices, and was last updated 1 year ago by
    Participant
    .
Viewing 1 reply thread
  • Author
    Posts
    • #162228
      Participant
      Topics: 1
      Replies: 0
      Points: 12
      Rank: Member

      First time user and I would like to be able to retrieve specific lines of text from a TXT file and load into an Excel spreadsheet.

      The file I am retrieving the text from has 5 lines of data that repeats several times in the file but each line ends with unique data. I want to be able to drop each line into a separate column in Excel. Example: Line 2 in column one, Line 4 in column two. Then every line that starts the same as Line 2 will go to column one.

      Any help to get me started would be much appreciated. Thanks.

    • #162257
      Participant
      Topics: 5
      Replies: 2368
      Points: 5,987
      Helping Hand
      Rank: Community MVP

      You may start with learning the very basics of Powershell first – Getting Started with PowerShell 3.0. There you will learn everything you need.

Viewing 1 reply thread
  • The topic ‘Specific text from txt file to Excel’ is closed to new replies.