Skip to content

search.md

Latest commit

 

History

History
293 lines (249 loc) · 8.82 KB

search.md

File metadata and controls

293 lines (249 loc) · 8.82 KB

Search - Match the corresponding row in a column

sample file (test.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
│  3  | hansen |
└─────┴────────┘

1. Equal

Set criteria (Select column: name, Search mode: Equal, Search conditions: tom|jerry)

Equal search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
└─────┴────────┘

2. EqualMulti

Set criteria (Select column: name, Search mode: EqualMulti, Search conditions: tom|jerry)

EqualMulti search result (2 output file: test_tom.csv, test_jerry.csv)
test_tom.csv
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
└─────┴────────┘

test_jerry.csv
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  2  │ jerry  │
└─────┴────────┘

3. NotEqual

Set criteria (Select column: name, Search mode: NotEqual, Search conditions: tom|jerry)

NotEqual search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  3  │ hansen │
└─────┴────────┘

4. Contains

Set criteria (Select column: name, Search mode: Contains, Search conditions: om|jer)

Contains search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
└─────┴────────┘

5. ContainsMulti

Set criteria (Select column: name, Search mode: ContainsMulti, Search conditions: om|jer)

ContainsMulti search result (2 output file: test_om.csv, test_jer.csv)
test_om.csv
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
└─────┴────────┘

test_jer.csv
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  2  │ jerry  │
└─────┴────────┘

6. NotContains

Set criteria (Select column: name, Search mode: NotContains, Search conditions: om|jer)

NotContains search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  3  │ hansen │
└─────┴────────┘

7. StartsWith

Set criteria (Select column: name, Search mode: StartsWith, Search conditions: to|jer)

StartsWith search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
└─────┴────────┘

8. StartsWithMulti

Set criteria (Select column: name, Search mode: StartsWithMulti, Search conditions: to|jer)

StartsWithMulti search result (2 output file: test_to.csv, test_jer.csv)
test_to.csv
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
└─────┴────────┘

test_jer.csv
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  2  │ jerry  │
└─────┴────────┘

9. NotStartsWith

Set criteria (Select column: name, Search mode: NotStartsWith, Search conditions: to|jer)

NotStartsWith search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  3  │ hansen │
└─────┴────────┘

10. EndsWith

Set criteria (Select column: name, Search mode: EndsWith, Search conditions: om|rry)

EndsWith search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
└─────┴────────┘

11. EndsWithMulti

Set criteria (Select column: name, Search mode: EndsWithMulti, Search conditions: om|rry)

EndsWithMulti search result (2 output file: test_om.csv, test_rry.csv)
test_om.csv
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
└─────┴────────┘

test_rry.csv
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  2  │ jerry  │
└─────┴────────┘

12. NotEndsWith

Set criteria (Select column: name, Search mode: NotEndsWith, Search conditions: om|rry)

NotEndsWith search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  3  │ hansen │
└─────┴────────┘

13. Regex

Set criteria (Select column: name, Search mode: Regex, Search conditions: hansen)

Regex search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
└─────┴────────┘

14. IsNull

Set criteria (Select column: name, Search mode: IsNull)

IsNull search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│     │        │
└─────┴────────┘

15. IsNotNull

Set criteria (Select column: name, Search mode: IsNotNull)

IsNotNull search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
│  3  | hansen |
└─────┴────────┘

16. gt

Set criteria (Select column: idx, Search mode: gt, Search conditions: 2)

gt search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  3  | hansen |
└─────┴────────┘

17. ge

Set criteria (Select column: idx, Search mode: ge, Search conditions: 2)

ge search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  2  │ jerry  │
│  3  | hansen |
└─────┴────────┘

18. lt

Set criteria (Select column: idx, Search mode: lt, Search conditions: 2)

lt search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
└─────┴────────┘

19. le

Set criteria (Select column: idx, Search mode: le, Search conditions: 2)

le search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
└─────┴────────┘

20. Between

Set criteria (Select column: idx, Search mode: le, Search conditions: 1|2)

Between search result (1 output file: test.search.csv)
┌─────┬────────┐
│ idx │ name   │
├─────┼────────┤
│  1  │ tom    │
│  2  │ jerry  │
└─────┴────────┘