Select some of cell content

[DanielArmani]

Hi there,

I wonder if there is a way to get some of the information from cell content when we collecting data from tables?

To explain, I need to get result from cointegration test result table which says " Trace test indicates no cointegration at the 0.05 level" or " Trace test indicates 1 cointegrating eqn(s) at the 0.05 level". this message is in one cell, I need to collect only the number "1" or "no" from the cell not all the message.

Please advise me.

Regards

Daniel

[EViews Gareth]

Extract that cell into a string, then use the string manipulation tools, such as @instr, @left, @mid, @right, to extract the bit you want.

For this particular case, something like this would do:

Code: Select all

%mystring2 = @mid(%mystring1,23,2)