Error handling for file

Hi Guys,
I got a csv with pipe delimted file and i want to check second column of the file has any alpha character becuase I am expecting only number in that,
and if any alpha characters then it should throw an error

Thanks in advance

Try:

awk -F\| '$2~/[[:alpha:]]/{print "Alpha alert, oh no..."}' file