topic Re: problem with shell script - reading folder in Operating System - HP-UX

problem with shell script - reading folder

amonamon — Thu, 15 Jun 2006 07:21:20 GMT

Hello..

I have a strange problem with my shell script..I have in folder meny txt and doc files I am only interested in txt files..how can I read certan data from each file and write it back to one file..

any ideas?

I have like 300 txt files in one folder and there is in each file peace of info that I need each file has this structure:

mysql -u -h -p
THIS LINE IS TARGET

so basicly I only need last line from txt file..tail -1 is target value..

any ideas or start code??

Re: problem with shell script - reading folder

Marvin Strong — Thu, 15 Jun 2006 07:28:58 GMT

for a in *.txt
do
tail -1 $a >> newfile
done

Re: problem with shell script - reading folder

Ninad_1 — Thu, 15 Jun 2006 07:30:52 GMT

If you mean by txt and doc files as .txt and .doc files, then you can use the following

for i in `ls -1 *.txt`
do
tail -1 $i >> ouputfile
done

Regards,
Ninad

Re: problem with shell script - reading folder

spex — Thu, 15 Jun 2006 07:35:39 GMT

find . -type f -name '*.txt' -exec tail -1 {} >> accum.txt \;

Re: problem with shell script - reading folder

Enrico P. — Thu, 15 Jun 2006 07:38:10 GMT

Hi,

for FILE in `ls`; do
if tail -1 $FILE|grep ^mysql >> /dev/null; then
tail -1 $FILE >> ouputfile
fi
done

Enrico

Re: problem with shell script - reading folder

amonamon — Thu, 15 Jun 2006 09:02:56 GMT

thanks you guys gave me a good hint...thanks for code..

Re: problem with shell script - reading folder

OldSchool — Thu, 15 Jun 2006 10:45:45 GMT

If the lines of interest are always in .txt files contained in one directory (/folder for example), and the line that you are interested in is always "mysql -u", then the following should work just fine:

grep 'mysql -u' *.txt > accum.txt

Re: problem with shell script - reading folder

amonamon — Fri, 16 Jun 2006 00:59:44 GMT

thanks but tail has different values not always same..

I figure it out..but now I have anothe small problem..

I have this:
awk '{printf("INSERT INTO akcije (date, time, target1, target, action) VALUES ('%s','%s','%s','%s','%s');\n",substr($0,0,6),substr($0,8,17),substr($0,25,8),substr($0,33,6),substr($0,48,11));}' ca > CAndA.sq

result is: from CAndA.sq file:
..
...
INSERT INTO akcije (date, time, target1, target, action) VALUES (20060524,145222,5431,876,west);
...
.

which is not good command for mysql it needs to be like this:

INSERT INTO akcije (date, time, target1, target, action) VALUES ('20060524','145222','5431','876','west');

how can I show those ''...
I also tryed with \' insted just ' but same result..any ideas?

Thanks..

Re: problem with shell script - reading folder

Enrico P. — Fri, 16 Jun 2006 03:09:44 GMT

Hi,
try

awk '{printf("INSERT INTO akcije (date, time, target1, target, action) VALUES ('%s','%s','%s','%s','%s');\n",substr($0,0,6),substr($0,8,17),substr($0,25,8),substr($0,3
3,6),substr($0,48,11));}' ca |sed s/\'//g > CAndA.sq

Enrico

Re: problem with shell script - reading folder

amonamon — Fri, 16 Jun 2006 03:35:24 GMT

thanks for help but I get a same result with sed command...

same with this sed as without sed..

Re: problem with shell script - reading folder

Enrico P. — Fri, 16 Jun 2006 04:08:07 GMT

Sorry,
try to put the

"'"'"'"

before and after the substr function:

awk '{printf("INSERT INTO akcije (date, time, target1, target, action) VALUES ('%s','%s','%s','%s','%s');\n","'"'"'"substr($0,0,6)"'"'"'","'"'"'"substr($0,8,17)"'"'"'","'"'"'"substr($0,25,8)"'"'"'","'"'"'"substr($0,3
3,6)"'"'"'","'"'"'"substr($0,48,11)"'"'"'");}' ca > CAndA.sq

Enrico

Re: problem with shell script - reading folder

Enrico P. — Fri, 16 Jun 2006 04:12:48 GMT

Hi,
in my test it work:

awk '{print "'"'"'"substr($2,2,5)"'"'"'","'"'"'"substr($2,2,5)"'"'"'"}' test

'prova' 'prova'

Enrico

Re: problem with shell script - reading folder

amonamon — Fri, 16 Jun 2006 04:21:37 GMT

Enrico...this works perfect...thanks guys for this help..

Cheers,

Re: problem with shell script - reading folder

Enrico P. — Fri, 16 Jun 2006 04:29:06 GMT

Hi,

http://www.gnu.org/software/gawk/manual/html_node/Quoting.html

Here there is many example more readable than that I gave you for single quote in awk.

Enrico