e164-csv-normalizer

README

e164-csv-normalizer

Application formats various phone number strings input by users to E.164 common format. The application generates a CSV file with normalized phone numbers based on an input CSV file.

Usage

$ go get github.com/4rakcheev/e164-csv-normalizer
$ go build
$ ./e164-csv-normalizer -i testNumbersDB.csv

Launch parameters

param	default	description
-i	-	Input csv file. Will be processed first column.
-d	y	Set to n for don't remove Duplicates after format
-h	n	Set to y for skip first row as a Header in the input file
-o	-	Path for Output normalized csv file
-n	-	Set a National Prefix for non e164 numbers. Choose the scenario parameter sn for use this feature
-sn	-	Set of Scenarios for the National prefix replacement (you can use multiple scenarios like za): z replace first zero to the prefix a add the prefix to all numbers except National Prefix itself

Example

Normalize the test database with numbers in varied formats (like user inputs). This example skip first row as header, replace first 0 to prefix 358, append 358 prefix to other numbers without this prefix and removes duplicates

$ ./e164-csv-normalizer -i testNumbersDB.csv -n 358 -sn za -d y -h y
Processed [16] rows from file `testNumbersDB.csv`
Normalized numbers [12] (removed [2] duplicates) with wrong number [1] saved in `normalized_testNumbersDB.csv`
(!)skipped line 8 with error: "number 3.58504E+11 in large exponent format"

Input example:

some csv header
+358 40 727 9689
+358 400903691
+358 44 0308202
+358040 8545115
+358400290288
00250
3.58504E+11
0034600222090
040 1597474
40 1597474
040 252 7629
040 861 41 81
35840 861 41 81
0400109848
358407411963

Output:

358400903691
358440308202
3580408545115
358400290288
3580250
358034600222090
358401597474
358402527629
358408614181
358400109848
358407411963

Build for different architectures

Example for build executable application for Windows arch:

$ env GOOS=windows GOARCH=amd64 go build

Choose yours current Target Operating System (GOOS) and Target Platform (GOARCH) parameters in Godoc.