How to exclude alphabets in a particular column ?

Hello,

I have accountId column in a table like below,

AccountId
1254T
43456
54328
2156A

In this column I want to exclude accountId which contains alphabets.
How can I do this… pls help me.

Thanks
Anusha.

Anusha, 

Happy new year!!

Have you tried "Row Filter" node selecting "Exclude rows by attribute value" radio button and using as Matching Criteria a regular expression for any word character (http://rubular.com/)?

 

Hi Karelman,

Happy new year to you too..

Thanks for your reply and "Row Filter" helped me to solve the problem.

Thanks a lot.