Write a utility program, ModifyAndCopyRxLogs:
Usage:
ModifyAndCopyRxLog -i <filepath> -o <output_directory> [-c <1,2,3,4,...>] [-p prefix] [-t]
-i Input filepath
-o Output directory (can be a network share)
-c Specifies the columns to be included (all other columns are deleted from the file)
-p Specifies an optional prefix to be added to the filename
-t If specifies appens date and time (e.g., _2017_5_23__21_20) to the end of the filename
Description:
RxLogs are pipe(|)-delimited files (similar to CSV). ModifyAndCopyRxLogs reads the file specified by log_filepath and makes the following changes:
1. Deletes all columns not specified with the -c command-line parameter
2. Escapes all double-quotes (e.g., " -> "")
3. Escapes all commas (any field containing a comma is surrounded by double-quotes. e.g., |hello,world| -> |"hello,world"|)
4. Changes all pipe (|) characters to commas (,)
5. Publishes the file to output_directory while adding the "prefix" if one is specified on the command-line, and adding date and time (e.g., _2017_5_23__21_20) to the end of the filename if -t is specified
Return Value:
0 Successfully processed the file
1 Input file not found
2 Cannot copy to output directory
I'm a proficient coder, specialized in Go, Python and C.
This kind of parsing task is completely achieveable in a couple days of work, provided with a test input.
I'm sure we'll work well together!
Relevant Skills and Experience
I worked many years with python and go, plus my C knowledge can help a lot in this task.