Link to home
Create AccountLog in
Avatar of Si Walton
Si Walton

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

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

Thank you for looking and hopefully you can help me.

Si
ASKER CERTIFIED SOLUTION
Avatar of oBdA
oBdA

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Si Walton
Si Walton

ASKER

Thank you oDba

Thats works a treat

Si