shell script

jikyj · April 3, 2003, 7:20am

I have a script that logon DB and submit queries and export the output to a specified drive. ok
Now i want within the output file to remove/cut the first two characters and write the rest out file to elsewhere.
can someone help ???

hugo_perez · April 3, 2003, 8:35am

cat file1.txt |awk '{print substr($0,3,length($0)-2)}' > file2.txt

oops. was corrected.

jikyj · April 3, 2003, 9:13am

Thanks a lot, it work !!!

oombera · April 3, 2003, 10:04am

I just noticed one small problem: length($0)-3 trims off the last character of each line.. it should be length($0)-2.

jikyj · April 3, 2003, 11:05am

Thanks you too, i have noticed it and recitified it for it to do the job ...