Urgent: How to eliminate special symbols in a file and how to read it

Hi,

I have file called suppliersList.txt
---------------------------------
112|MIMUS|krish@google.com
113|MIMIRE|krish@google.com
114|MIMCHN|krish@google.com
115|CEL|krish@google.com
108|UGEN|krishn@google.com
109|SLAND|krish@google.com

i have 3 varibale
-------------
no
Name
email

i need to cut the special symbol from the file "|"
and i need to loop

my output should be like this

echo "No"$no
echo "Name"$Name
echo "email"$email

output like
---------------------

No 112
Name MIMUS
email krish@google.com

No 113
Name MIMIRE
email krish@google.com

No 114
Name MIMCHN
email krish@google.com

No 115
Name CEL
email krish@google.com

like this

Please send me your valuable suggesions on this

Thanks you everyone.

Thanks
Krish.

cat suppliersList.txt

112|MIMUS|krish@google.com
113|MIMIRE|krish@google.com
114|MIMCHN|krish@google.com
115|CEL|krish@google.com
108|UGEN|krishn@google.com
109|SLAND|krish@google.com

Script is

awk -F"|" ' BEGIN {OFS="\n"}
{print "No " $1 , "Name " $2 ,"email " $3 , "\n" }' suppliersList.txt

No 112
Name MIMUS
email krish@google.com

No 113
Name MIMIRE
email krish@google.com

No 114
Name MIMCHN
email krish@google.com

No 115
Name CEL
email krish@google.com

No 108
Name UGEN
email krishn@google.com

No 109
Name SLAND
email krish@google.com

awk -F"|"  '{print "\nNo " $1, "\nName " $2, "\nEmail " $3}' suppliersList.txt

Thank you a lotttttttttttttttttttt
Its working fineeeeeeeeeeeeee

Hi,

I need some more, advanced, i need to put in loop,
bcoz i need to validate these numbers with other string

i need to print how many lines in a file
i need to print

line1

NO
Name
Email

line2

No
Name
Email

like this
please help me