UNIX and Linux Forums - Search Results

Showing results 1 to 2 of 2 Search took 0.01 seconds. Search: Posts Made By: shivamayam

Forum: Shell Programming and Scripting 07-13-2017

Remove the leading and trailing date from a CSV file

3,228

Posted By

#!/bin/bash for file in *.csv do ...

#!/bin/bash
for file in *.csv
do
len=${#file}
let len=$len-11-13
outfile=${file:11:$len}
cp $file outdir/$outfile.csv
done
Change cp to mv when you have tested.

Forum: Shell Programming and Scripting 07-12-2017

Remove the leading and trailing date from a CSV file

3,228

Posted By

sed 's/[^_]*_//; s/_[^._]*[.]$.*$$/.\1/' infile

sed 's/[^_]*_//; s/_[^._]*[.]$.*$$/.\1/' infile

Showing results 1 to 2 of 2