extract rows from csv

[Nigelh53]

Hi
I'm trying to extract rows that match a pattern (3 characters and 8 digits) from a csv file and output them to a new csv

#Import the CSV file with all the data.
$csv = Import-CSV J:\CanvasData\users_utf8nobom.csv 
#Process the CSV file one row at a time 
foreach ($row in $csv) { 
#Each column is accessed using the column header. 
#We can use the -not operator to specify 'doesn't match'.      
if ($row.user_id -eq "\b[\D[3}\d{8}]\b")
{ 
#... Export that row to a new CSV file.        
$row | Export-CSV J:\Temp\teacherlist.csv  -Append -NoTypeInformation   
 } 
}

an example of the csv file is below
user_id status
MCN18158364 active
901658 active
W00054 active
MCN17125917 active

 

[k5tm]

I am far from expert, but...

How about -match rather than -eq?

Tom Morrison
Consultant

 

[gbaughma]

\b[\D[highlight #FCE94F][[/highlight]3}\d{8}]\b"

... is that correct?

Just my $.02

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

 

[fredericofonseca]

should probably be \b\D{3}\d{8}\b

if ($row.user_id -match "\b\D{3}\d{8}\b")


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[gbaughma]

should probably be \b\D{3}\d{8}\b

if ($row.user_id -match "\b\D{3}\d{8}\b")

Yeah.... the addition of the braces [] would say "any match of the characters in the braces" I believe...
I think your match should work....



Just my $.02

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg