UNIX for Dummies Questions & Answers

Hello! I have content in a log file that consists of a lot of spaces before and after a 3 digit integer which I need to strip out before I can use the file. The number of digits can change. When I had my logic in a 'for' loop and could output into another file, it was fine. but it turns out that I will only have 1 line now and don't need the for loop. I have tried a lot of different logic for grepping using the 'x' switch and it didn't work outside of the loop. I tried the E switch as well. This is what I had that worked inside of a for loop, any ideas on how to strip the spaces from the integer? I tried taking just that one line below with the grep, I tried using 'cat' instead of 'echo', nothing worked:

SQL_COUNT=`cat ${LOGPATH}/sql_count.log`
NUM_LOG=${LOGPATH}/num.log

for x in ${SQL_COUNT}
do
echo $x | grep -x '[0-9]*'
done > ${NUM_LOG}

Use tr:

Code:

 echo "       1234567         " | tr -dc '[0-9]'

Or in your case try

Code:

cat filename | tr -dc '[0-9]'

Worked perfectly, thanks!

The solution:

Code:

... | tr -dc '[0-9]'

also removed he carriage return at the end of each line.

Here is another solution, keeping the carriage return:

Code:

echo "       1234567         " | sed 's/ //g'
sed 's/ //g' input_file

A cruel way !

Code:

echo "       1234567         " | awk '{ print $0 + 0 }'

Yes, I didn't realize that I didn't have the carriage return, then again, I'm too new at this to realize that when my ID prompt listed right after my number that it meant I didn't have a carriage return . Thanks!

I'm working with a ksh script on a windows box calling a sendmail bat file, now if I can only get it to send me mail! At least I have the trimmed number to work with, maybe there's something with how I'm manipulating my code - yesterday it worked and I have changed things today...

Thanks again,

Code:

tr -dc '[0-9]' < filename