split string

izza_azhar · 01-17-2005, 07:03 PM

if file name such:
ATK_7B1_WIP_20041116160700.9.xml.dat
ATK_7B1_WIP_20041116160700.93474039283928384.xml.dat
so how can i cut to only get the year,month,day and year and month

such:20041116 or 200411

Dark_Helmet · 01-17-2005, 08:29 PM

This works for me (assuming the files have all YYYYMMDD format for the date - as in 01 for January, 02 for February, etc.)

Code:

for entry in $( ls ATK* | cut -f 4 -d '_' ) ; do echo ${entry:0:8}; done

mjrich · 01-17-2005, 08:46 PM

Or using Sed:

Code:

echo Please enter output filename:
read filename

touch $filename
for f in *.xml.dat; do
        echo Processing $f
        echo $f | sed 's/ATK_7B1_WIP_//' | head -c8 >> $filename
        echo $CHAR112 >> $filename
done

echo
echo Done !

Not as simple or elegent as Dark_Helmet's code (or as portable for that matter), but it works for me.

Cheers,

mj

izza_azhar · 01-17-2005, 09:14 PM

if my program such this:

for FILE in ls ATK*.dat
do
curr_year=$(date +%Y)
curr_month=$(date +%Y%m)
file_year=<filename just have the year>
file_month=<filename that just have year and month>

if [ "$curr_year" = "$file_year" ]
then
if [ 'expr $curr_month - $file_month >= 3 ]
then
mv $FILE /u006/r45647/Izza/xsltOutput/archiveprocess
<move the file to another directory>

fi

fi

done

can we use sen to pass the variable for $file_year or file month?
or it's easy use the cut only?

bigearsbilly · 01-18-2005, 03:21 AM

Code:

billym.primadtpdev>cat ~/1

for file in *.dat;do
     x=${file##*_}
    date=${x%%.*}
    echo "[$date] $file"

done

Code:

billym.primadtpdev>bash ~/1
[20041116160700] ATK_7B1_WIP_20041116160700.9.xml.dat
[20041116160700] ATK_7B1_WIP_20041116160700.93474039283928384.xml.dat

you can then use touch -t to set the time
and then find -ctime +<no_of_days> to find
the overdue files.

Hko · 01-18-2005, 11:48 AM

Quote:

Originally posted by izza_azhar
if file name such:
ATK_7B1_WIP_20041116160700.9.xml.dat
ATK_7B1_WIP_20041116160700.93474039283928384.xml.dat
so how can i cut to only get the year,month,day and year and month

such:20041116 or 200411

Like is posted in your other thread on this subject:

Code:

for FILENAME in ATK_*.dat ; do
	FILEDATE=$(echo $FILENAME | cut -c 13-20)
	# ....
done

izza_azhar · 01-18-2005, 08:24 PM

it's really work