Parsing question - Page 2 - Shell Programming and Scripting

shamrock · #8 05-13-2008

Quote:

Originally Posted by muser

Thanks for this code just prints a "20" and every file name on the same line.

There was a typo...xlsdate changed from "echo $i" to "echo $file"

Code:

for file in "$(echo dat*)"
do
   xlsdate=$(echo $file | awk '{split($2,a,"\.xls");print a[1]}')
   fmtdate=$(echo $xlsdate | awk -F"-" '{for(i=NF;i>=1;i--) s=s""$i;print "20"s}')
   echo $xlsdate
   echo $fmtdate
   echo $file
done

era · #9 05-13-2008

Also you probably mean "for file in dat*" rather than the silly echo. (^:

muser · #10 05-13-2008

Quote:

Originally Posted by robotronic

Uh! I wrote "x" variable instead of "xlsFile"

Code:

for xlsFile in dat*.xls
do
   d=${xlsFile:4:2}
   m=${xlsFile:7:2}
   y=${xlsFile:10:2}

   xlsDate="$d-$m-$y"
   formattedDate="20$y$m$d"

   echo $xlsDate
   echo $formattedDate
   echo $xlsFile
done

Also, this works only with bash. You didn't specified which shell are you using. If not using bash, you may extract the same values through "cut" commands or something similar.

I used -

d=$(echo $xlsFile | cut -c4-5)
m=$(echo $xlsFile | cut -c7-8)
y=$(echo $xlsFile | cut -c10-11)

and it worked okay. Thanks!

muser · #11 05-13-2008

Quote:

Originally Posted by era

Also you probably mean "for file in dat*" rather than the silly echo. (^:

This didn't work for me so I gave up trying to fix it.
Also, I was using Korn shell.

Thanks!

shamrock · #12 05-13-2008

Quote:

Originally Posted by era

Also you probably mean "for file in dat*" rather than the silly echo. (^:

Spot on era

learnbash · #13 05-14-2008

hi Era,

hope you are doing well, can you answer few threads pls

sendmail help required
how to break mysql dump sql file

I am waiting for your kind reply.

Cheers,
Bash

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
parsing xml with awk/sed	ricgamch	Shell Programming and Scripting	3	05-28-2008 07:39 AM
Awk Parsing	bombcan	Shell Programming and Scripting	2	04-24-2008 11:45 AM
parsing	tungaw2004	UNIX for Dummies Questions & Answers	15	03-27-2007 05:33 PM
XML parsing	handak9	High Level Programming	1	11-01-2004 05:13 PM
Text parsing question	98_1LE	UNIX for Dummies Questions & Answers	3	03-24-2002 08:04 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode