Specific text from txt file to Excel

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

This topic contains 1 reply, has 2 voices, and was last updated by

 
Participant
3 months ago.

  • 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: 1
    Replies: 1530
    Points: 2,591
    Helping Hand
    Rank: Community Hero

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

The topic ‘Specific text from txt file to Excel’ is closed to new replies.