asked on
Powershell script to search a CSV file for numbers in a Column
Hi All
I am working on a project in Powershell to show the output of various share drives in HTML
I need to find a way to search Column 2 for various values from 0 to 2048 and add the following after each one depending on the value.
0-99 Red
100-199 Amber
200-2048 Green
Example below
Thank you for looking and hopefully you can help me.
Si
I am working on a project in Powershell to show the output of various share drives in HTML
I need to find a way to search Column 2 for various values from 0 to 2048 and add the following after each one depending on the value.
0-99 Red
100-199 Amber
200-2048 Green
Example below
Column 1 Column 2 Column 3 Column 4
Unc Path_1 18 sharename_1 2048
Unc Path_2 98 sharename_2 2048
Unc Path_3 12 sharename_3 2048
Unc Path_4 18 sharename_4 2048
Unc Path_5 4 sharename_5 2048
Unc Path_6 41 sharename_6 2048
Unc Path_7 72 sharename_7 2048
Unc Path_8 12 sharename_8 2048
Unc Path_1 18 sharename_1 2048
Unc Path_2 98 sharename_2 2048
Unc Path_3 12 sharename_3 2048
Unc Path_4 18 sharename_4 2048
Unc Path_5 4 sharename_5 2048
Unc Path_6 41 sharename_6 2048
Unc Path_7 72 sharename_7 2048
Unc Path_8 12 sharename_8 2048
Thank you for looking and hopefully you can help me.
Si
PowershellProgrammingMiscellaneous
Last Comment
Si Walton
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Thats works a treat
Si