How do I remove characters from a text file ifrom each row?
Posted on 2011-10-06
I am getting better at scripting in powershell, but I am still a novice and I am having problems finding a solution to this one..
I have a group of .txt files exported from SQL Server and delimited with a pipe - I
I am trying to remove all characters and spaces that are before the first | in each row.
Anyone able to help with this one? I could use Textpad, but that wouldn't help me learn this.
Also, any resource you have on this would be good too. I didn't find anything in google or I just didn't understand what I saw.
Idea of how the data look:
12345| File Path would sit here | more information about the data | etc |
I need to remove that ID section leaving the pipe. That first column is fixed in the length but not the data.