I have a project via my university and I really don't know where to start.... I need to amend a batch of .csv files within a folder using a powershell command. So I have the format below in which the csv file is in.
H;GBA/OUT/00029;20210218;Alex Brown;Old Doncaster Road;Rotherham;S63 7EE;GB;07738055103;alex.brown@gba-fm.com;GBP;2975.26;0;Sale;1;3 x (1.0 x Chair KJ-2-EMMA-SA-AB [PACK0000013];Pallet;KN;KN;GBA1:KN:KN::;
P;GBA/OUT/00029;20210218;1;12;KJ-2-EMMA-SA-AB;399.48;0.189888;13.2;
I need to change the file, where it extracts only the H line files, but only keeps the following information:
GBA/OUT/00029;20210218;
There is usually between 50-100 csvs per day passing through this folder, so I am really struggling on an outcome in powershell. Can anybody please help me!!
