CODEWITHSUNDEEP
linuxawkscripting
FARAH
FARAH

Reputation: 33

Split file into multiple file using awk, but in date format

I want to split a file into multiple files and save the file in date format.

Why doesn't this command work?

awk -v DATE= date '+%d%m%Y'-F"," 'NR>1 { print > "Test_" DATE ".CSV_"$1".csv"}' Testing.CSV

Upvotes: 0

Views: 607

Answers (2)

RavinderSingh13
RavinderSingh13

Reputation: 133458

@FARAH: Try:

awk -v DATE=$(date +%d%m%Y) -F"," 'NR>1 { print > "Test_" DATE ".CSV_"$1".csv"}'   Input_file

As there is lack of information about samples and expected output so seeing that your command needs to some fine tuned, try above and let us know if this helps.

Upvotes: 1

karakfa
karakfa

Reputation: 67467

this should work

awk -F, -v date=$(date +%d%m%Y) 'NR>1{print > "Test_"date".CSV_"$1".csv"}' file

if not, try first 

awk -v date=$(date +%d%m%Y) 'BEGIN{print date}'

to check whether date is correctly set as an awk variable.

Upvotes: 2

Related Questions