/prog/ - /prog/ Challenge: Micro$oft Excel 2018

Name: Anonymous 2018-02-14 9:00

Write a command line tool that takes in a CSV file, overwrites all the data of a given column by a given value, and outputs the results into a new CSV file.

More specifically, this command line tool should accept the following arguments:

the filename of a CSV file,
the name of the column to overwrite in that file,
the string that will be used as a replacement for that column,
the filename where the output will be written.

Name: Anonymous 2018-02-14 9:26

can we assume that CSV uses the actual comma as a separator?

Name: Anonymous 2018-02-14 10:12

>>1
Do your own homework. (Yes, homework, because most businesses don't upgrade to latest Office on a whim.)

Name: Anonymous 2018-02-14 10:14

Also assume that entries themselves don't contain commae. Edited on 14/02/2018 10:15.

>>2↵
Yes.
Also assume that entries themselves don't contain commae.

Name: Anonymous 2018-02-14 13:28

To clarify, the CSV contains a header line naming the columns? Since you said ``name'' rather than number.

Name: Anonymous 2018-02-14 15:03

This isn't a /prog/ challenge. It's your work. Figure it out you mental midget.

Name: Anonymous 2018-02-14 15:42

https://ftp.gnu.org/gnu/gawk/

Name: Anonymous 2018-02-14 16:19

>>5
Yes.

Name: Anonymous 2018-02-14 16:26

>>6
If your work includes rewriting a single feature of

GNU A.W.K.

, you are miserable.

Name: Anonymous 2018-02-14 17:09

>>7
The rooster will be avenged.

Name: Anonymous 2018-02-14 18:44

>>7
Non-https link
ftp://ftp.gnu.org/gnu/gawk/

Name: Anonymous 2018-02-14 18:45

dubs get

Name: Anonymous 2018-02-14 19:17

STOLEN

Name: test 2018-02-15 2:58

test

Name: Anonymous 2018-02-15 9:04

do my're are challenge you anii

Name: Anonymous 2018-02-15 9:09

>>15
I will do your're are challenge later because I'm shitposting from work and need to keep appearances

Name: Anonymous 2018-02-20 11:58

Ez pc: perl, use any popular CSV module. Or AWK, (that might be a bit harder since you have to handle quoted strings yourself)

Name: Anonymous 2018-02-20 12:46

>>16
your're computer scientist job?

Name: Anonymous 2018-02-20 13:04

>>18
No, my'm code monkey job

Name: Anonymous 2018-02-20 13:11

>>19
actually, my'm am job is not code monkey but security, which allows me to laugh at code monkeys and the code their're are monkeying

Name: Anonymous 2018-02-20 15:09

>>20
A trained code monkey is still a code monkey

Name: Anonymous 2018-02-20 18:54

!

Name: Anonymous 2018-02-21 7:58

>>21
but my job is not monkeying the code, it is breaking the monkeyed code to display goatse on remote servers

/prog/ Challenge: Micro$oft Excel 2018

1 Name: Anonymous 2018-02-14 9:00

2 Name: Anonymous 2018-02-14 9:26

3 Name: Anonymous 2018-02-14 10:12

4 Name: Anonymous 2018-02-14 10:14

5 Name: Anonymous 2018-02-14 13:28

6 Name: Anonymous 2018-02-14 15:03

7 Name: Anonymous 2018-02-14 15:42

8 Name: Anonymous 2018-02-14 16:19

9 Name: Anonymous 2018-02-14 16:26

10 Name: Anonymous 2018-02-14 17:09

11 Name: Anonymous 2018-02-14 18:44

12 Name: Anonymous 2018-02-14 18:45

13 Name: Anonymous 2018-02-14 19:17

14 Name: test 2018-02-15 2:58

15 Name: Anonymous 2018-02-15 9:04

16 Name: Anonymous 2018-02-15 9:09

17 Name: Anonymous 2018-02-20 11:58

18 Name: Anonymous 2018-02-20 12:46

19 Name: Anonymous 2018-02-20 13:04

20 Name: Anonymous 2018-02-20 13:11

21 Name: Anonymous 2018-02-20 15:09

22 Name: Anonymous 2018-02-20 18:54

23 Name: Anonymous 2018-02-21 7:58