Page 1 of 1

Check if data is text

Posted: Mon Feb 01, 2016 4:03 pm
by luan_ngo
I'm importing a table from Excel and the value of some cells can be either text or numbers. In my program, if it's text, it will be treated differently than numbers. Is there a way I can see whether the value in my alpha series is a number or text?

Thanks!

Re: Check if data is text

Posted: Mon Feb 01, 2016 4:07 pm
by EViews Gareth
Use the @val function to convert the text to a number. If it returns NA, you know it isn't a number.

Re: Check if data is text

Posted: Mon Feb 01, 2016 4:36 pm
by luan_ngo
Thanks!