Parsing a filename and adding it to a text file

Question

I have a directory full of files with the date they were created in the filename (ie "mvr-20160420.csv"). The files contain comma delimited data that I'm combining into a single text file. I'm trying to figure out how to add the date portion of each file to the data. I'm able to read the files, but not the filenames.

Sample file for mvr-20160420.csv:

client employee id,first name,last name,points
14204,Bob,Smith,5

I have a Korn script and just trying to add the filename to the data:

for file in $Folder/path/burnsmcd-mvr*.csv
do 
FN=file

if [ $FIRSTTIME = $STATUS_OK ]
then 
  FIRSTTIME=$STATUS_NOT_OK
  cat $file | strings | sort -n | awk 'BEGIN{FS=","}{OFS="|"}{if ( $1 ~ /^[0-9]+$/) print "ADMVR", $1, $2, $3, $4, $FN}' > $Folder/path/ext_test.txt
else      
  cat $file | strings | sort -n | awk 'BEGIN{FS=","}{OFS="|"}{if ( $1 ~ /^[0-9]+$/) print "ADMVR", $1, $2, $3, $4, $FN}' >> $Folder/path/ext_test.txt
fi
done

So my output ext_test.txt looks like this:

14204|Bob|Smith|5|14204,Bob,Smith,5

I can't seem to add the filename. I also need to extract the date portion.

$FN is wrong there, try $file. And don't use cat, just do strings $file | sort .... — ott--
– ott--, Commented Apr 21, 2016 at 13:24

James K. Lowden · Accepted Answer · 2016-04-21 13:44:03Z

0

$ awk 'BEGIN {OFS=","} 
      { split (FILENAME, parts, "[-.]"); print FILENAME, parts[2], $0 }' \
      mrv-20161225.csv 
mrv-20161225.csv,20161225,client employee id,first name,last name,points
mrv-20161225.csv,20161225,14204,Bob,Smith,5

A morning without awk is like a long day at work. ;-)

answered Apr 21, 2016 at 13:44

James K. Lowden

2,15614 silver badges17 bronze badges

Add a comment |

Stack Exchange Network

Parsing a filename and adding it to a text file

1 Answer 1

You must log in to answer this question.

Hot Network Questions

Parsing a filename and adding it to a text file

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions