Hello team,
I have a log file which i need to parse, i don’t need all the details but need only few. below is how my file will look like.
T=CEMTDR1864393_10/09/2017 S=CEMTDR1864393_10/09/2017 R=TDRALRT01 2017/09/08 02:32:52 1
T=000284447_10/09/2017 S=000284447_10/09/2017 R=ITNEALRT01 2017/09/05 01:23:24 1
T=C14288015_10/18/2017 S=C14288015_10/18/2017 R=ITNECASE01 2017/08/03 01:27:06 1
T=SAM1291734_10/18/2017 S=SAM1291734_10/18/2017 R=1ZFAALRT01 2016/11/14 10:18:51 1
1st column = String that starts after T= and ends before “"
2nd column = Date that is starting after "” in the first string
3rd column = String that starts after R=.
Rest everything has to be ignored and the output should be written to a new file. Output will be like
CEMTDR1864393 10/09/2017 TDRALRT01
000284447 10/09/2017 ITNEALRT01
Please let me know how this can be acheived using powershell. I am new to it and do not have much information