1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
package main
import (
bt "badtudexo"
st "saggytrousers"
"fmt"
"os"
xl "github.com/xuri/excelize/v2"
)
// This program has the function of finding duplicate values in a column. It
// will spit them back as output if they exist. Useful, to, e.g. check
// duplicates in a reference that should be unique.
func usage() {
fmt.Println(`bt-duplref: check for duplicates.
This program allows you to check whether there are any duplicates in a given
file column. This can be handy as a check for, e.g. transaction references.
Note: Speed
-----------
A downside to this program at the moment is the algorithm used is O(N^2), so
does not scale well. It should be performant enough for a few thousand rows,
but beyond that it may become a bit slow.
`)
os.Exit(-1)
}
func parseArgs(args []string) {
for i := 0; i < len(args); i++ {
arg := args[i]
switch arg {
case "-h", "help", "--help":
usage()
case "-v", "--verbose":
verbose = true
case "--no-verbose", "--quiet", "-q":
verbose = false
default:
i++
g_file = args[i]
}
}
}
var g_file string
var verbose bool = true
func main() {
args := os.Args
parseArgs(args)
file, err := xl.OpenFile(g_file)
if err != nil {
fmt.Println("Could not open file.")
}
sheet := st.SelectSheet(file, "")
columnIdx := st.SelectHeader(file, sheet, "", /* exact: */ false)
columns, err := file.GetCols(sheet)
if err != nil {
fmt.Println("Could not get columns.")
return
}
column := columns[columnIdx]
// Do the thing.
if verbose { fmt.Println("Loaded file, now checking duplicates...") }
dupls := bt.Duplicate(column)
// Output.
for _, d := range dupls {
v := d.Value
i := d.Index
fmt.Printf("Duplicate at index %d is %v\n", i, v)
}
}
|
