... | @@ -7,12 +7,12 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
... | @@ -7,12 +7,12 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
,Blankman,,SomeTown,SD,298
|
|
,Blankman,,SomeTown,NJ,298
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
```
|
|
```
|
|
|
|
|
|
Command:
|
|
Command:
|
|
`./csvfilter --drop:3:SomeTown case1.csv`
|
|
`./csvfilter --drop:3:SomeTown --no-headers case1.csv`
|
|
|
|
|
|
Output (in terminal):
|
|
Output (in terminal):
|
|
```
|
|
```
|
... | @@ -22,6 +22,14 @@ John,Repici,120 Jefferson St.,Riverside,NJ,8075 |
... | @@ -22,6 +22,14 @@ John,Repici,120 Jefferson St.,Riverside,NJ,8075 |
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
```
|
|
```
|
|
|
|
|
|
|
|
Command:
|
|
|
|
`./csvfilter --drop:City:SomeTown --no-headers case1.csv`
|
|
|
|
|
|
|
|
Output (in terminal):
|
|
|
|
```
|
|
|
|
Error: Header specified with --no-headers option!
|
|
|
|
```
|
|
|
|
|
|
### Scenario 3
|
|
### Scenario 3
|
|
|
|
|
|
case3.csv:
|
|
case3.csv:
|
... | @@ -31,12 +39,12 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
... | @@ -31,12 +39,12 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
,Blankman,,SomeTown,SD,298
|
|
,Blankman,,SomeTown,NJ,298
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
```
|
|
```
|
|
|
|
|
|
Command:
|
|
Command:
|
|
`./csvfilter --drop:City:SomeTown case3.csv --output case3out.csv`
|
|
`./csvfilter --drop:City:SomeTown case3.csv --output="case3out.csv"`
|
|
|
|
|
|
Output (in terminal):
|
|
Output (in terminal):
|
|
```
|
|
```
|
... | @@ -61,7 +69,7 @@ John;Doe;120 Jefferson St.;Riverside; NJ,8075 |
... | @@ -61,7 +69,7 @@ John;Doe;120 Jefferson St.;Riverside; NJ,8075 |
|
Jack;McGinnis;220 Hobo Ave.;Phila;PA;9119
|
|
Jack;McGinnis;220 Hobo Ave.;Phila;PA;9119
|
|
John;Repici;120 Jefferson St.;Riverside;NJ;8075
|
|
John;Repici;120 Jefferson St.;Riverside;NJ;8075
|
|
Stephen;Tyler;7452 Terrace Road;SomeTown;SD;91234
|
|
Stephen;Tyler;7452 Terrace Road;SomeTown;SD;91234
|
|
;Blankman;;SomeTown;SD;298
|
|
;Blankman;;SomeTown;NJ;298
|
|
Joan;Anne;Jet;9 Terrace Place;Desert City;CO;123
|
|
Joan;Anne;Jet;9 Terrace Place;Desert City;CO;123
|
|
```
|
|
```
|
|
|
|
|
... | @@ -86,7 +94,7 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
... | @@ -86,7 +94,7 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
,Blankman,,SomeTown,SD,298
|
|
,Blankman,,SomeTown,NJ,298
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
```
|
|
```
|
|
|
|
|
... | @@ -135,7 +143,7 @@ John,Doe,120 Jefferson St.,Riverside, NJ |
... | @@ -135,7 +143,7 @@ John,Doe,120 Jefferson St.,Riverside, NJ |
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA
|
|
John,Repici,120 Jefferson St.,Riverside,NJ
|
|
John,Repici,120 Jefferson St.,Riverside,NJ
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD
|
|
,Blankman,,SomeTown,SD
|
|
,Blankman,,SomeTown,NJ
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO
|
|
```
|
|
```
|
|
|
|
|
... | @@ -153,7 +161,7 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
... | @@ -153,7 +161,7 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
,Blankman,,SomeTown,SD,298
|
|
,Blankman,,SomeTown,NJ,298
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
```
|
|
```
|
|
|
|
|
... | @@ -181,3 +189,101 @@ Output (in terminal): |
... | @@ -181,3 +189,101 @@ Output (in terminal): |
|
```
|
|
```
|
|
print help menu here (we will design this later)
|
|
print help menu here (we will design this later)
|
|
```
|
|
```
|
|
|
|
|
|
|
|
### Scenario 9
|
|
|
|
|
|
|
|
case9.csv:
|
|
|
|
```
|
|
|
|
First,Last,Address,City,State,Postal
|
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
|
|
,Blankman,,SomeTown,NJ,298
|
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
|
```
|
|
|
|
|
|
|
|
Command:
|
|
|
|
`./csvfilter --drop:3:SomeTown case9.csv`
|
|
|
|
|
|
|
|
Output (in terminal):
|
|
|
|
```
|
|
|
|
First,Last,Address,City,State,Postal
|
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
|
```
|
|
|
|
|
|
|
|
### Scenario 10
|
|
|
|
|
|
|
|
case10.csv:
|
|
|
|
```
|
|
|
|
First,Last,Address,City,State,Postal
|
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
|
|
,Blankman,,SomeTown,NJ,298
|
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
|
```
|
|
|
|
|
|
|
|
Command:
|
|
|
|
`./csvfilter --replace:First:John:Jon case10.csv`
|
|
|
|
|
|
|
|
```
|
|
|
|
First,Last,Address,City,State,Postal
|
|
|
|
Jon,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
|
Jon,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
|
|
,Blankman,,SomeTown,NJ,298
|
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
|
```
|
|
|
|
|
|
|
|
Command:
|
|
|
|
`./csvfilter --locate:Last:Doe --replace:First:John:Jon case10.csv`
|
|
|
|
|
|
|
|
```
|
|
|
|
First,Last,Address,City,State,Postal
|
|
|
|
Jon,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
|
|
,Blankman,,SomeTown,NJ,298
|
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
|
```
|
|
|
|
|
|
|
|
Command:
|
|
|
|
`./csvfilter --replace:City:SomeTown:Chamberlain case10.csv`
|
|
|
|
|
|
|
|
Output (in terminal):
|
|
|
|
```
|
|
|
|
First,Last,Address,City,State,Postal
|
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
|
Stephen,Tyler,7452 Terrace Road,Chamberlain,SD,91234
|
|
|
|
,Blankman,,Chamberlain,NJ,298
|
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
|
```
|
|
|
|
|
|
|
|
Command:
|
|
|
|
`./csvfilter --locate:State:SD --replace:City:SomeTown:Chamberlain case10.csv --output="case10out.csv"`
|
|
|
|
`./csvfilter --locate:State:NJ --replace:City:SomeTown:Riverside case10out.csv --output="case10out.csv"`
|
|
|
|
|
|
|
|
Output (in terminal):
|
|
|
|
```
|
|
|
|
(empty)
|
|
|
|
```
|
|
|
|
|
|
|
|
case10out.csv
|
|
|
|
```
|
|
|
|
First,Last,Address,City,State,Postal
|
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
|
Stephen,Tyler,7452 Terrace Road,Chamberlain,SD,91234
|
|
|
|
,Blankman,,SomeTown,NJ,298
|
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
|
``` |
|
|
|
\ No newline at end of file |