Shell Programming and Scripting

ok, I assume this is all ONE line.
you didn't say what part of it you wanted....
In the future pls use vB Codes when posting sample data and/or quoting others.

Sure vgersh99,
I will do that from next time.
Can you please give code for doing that?

Thanks & Regards,

Code:

echo 'COL001 | P | 2007-02-01-00.00.00.000000 | | sam | babu | | | M | 1949-01-04-00.00.00.000000 | INDIA | | C60 | | 110 S | | ENNIS | IN | 46563 | INDIA |' | awk -F'|' '{gsub("[^0-9]", "", $3); print "[" $3 "]"}'

But I'd advise to do EVERYTHING in awk - including reading line/records - no need for the shell 'while read line....'

I have changed the script to use awk only
example

awk -F "|" '{

#ENTITY_TYPE=`print "$line" | cut -d'|' -f2 | awk '{gsub(/^[ \t]+|[ \t]+$/,"");print}'`
ENTITY_TYPE=$2

if [ ${ENTITY_TYPE} == "O" ]
then
ENTITY_TYPE="B"
else
ENTITY_TYPE="P"
fi
#CUSTOMER_ID=`print "$line" | cut -d'|' -f1 | awk '{gsub(/^[ \t]+|[ \t]+$/,"");print}'`
CUSTOMER_ID=$1

BIRTH_DATE=`print $10 | sed 's/[^0-9]//g' | cut -c1-8`

}' inquiry.txt

My question is can I use sed and cut inside awk?
If now can you please tell me the alternative way to do this?

Thanks in advance.

Can someone please help me on this?
Its kind of urgent..

Thanks a lot in advance.

you can use ANY utility from within awk, but it's not recommended as you're defeating the purpose of using just ONE tool capabale of doing it all natively.
Furthermore, I've provided a sample awk code in my previous post. Is there something in the sample code that you're stuck with?

Can you send some format of lines of your Input file..

Although I am also new to scripting but I think..
You are using awk inside while statement . The number of times the awk appears the programme will take that much time. Thats the problem I think.

you no need to put awk inside while..instead process all your data once you inside awk .

Here your all the lines of your input file is processed as many times the awk appears..



user_prady