Delete a row in a csv if a value in a certain column is not an integer with PowerShell

Question

I have a csv file with ID numbers and want to delete a row if that ID is not completely a number.

Example:

0001, jeff, smith

0abc, john, jones

I would like the "0abc, john, jones" row removed from the csv file.

Answer 1

If you just had that in your text file and nothing else this would work

Import-Csv -path c:\temp\data.csv -Header ID,First,Last | 
    Where-Object{$_.ID -match '^\d+$'} | 
    Export-CSV -Path c:\temp\newfile.csv

If you have issue with this please look at the following references

• Import-Csv
• Where-Object
• Export-CSV
• Regex for numbers