EViews.com

Posted: **Thu Sep 29, 2016 12:56 am**

Hi

how can I go from a number to a letter in the alphabet?

I have a loop where i have identfied that i want to set a line in column 2. but when using the setlines command I have to specify this as column B, and not column 2.

Code: Select all

table.setlines(B) +r

If I know the number of the column I want to change, how can I easily find the appropriate letter representing that column using program code?

Thomas

Posted: **Thu Sep 29, 2016 11:44 pm**

The best way I have found so far is to do it manually

Code: Select all

		for %col %letter 1 A 2 B 3 C 4 D 5 E 6 F ....
		next

Thomas

Posted: **Fri Sep 30, 2016 7:44 am**

Use @chr

Code: Select all

For !i = 1 To 26
  %cl{!i} = @Chr(!i+64)
Next

table.setlines({%cl2}) +r

Regards Johan

Posted: **Fri Sep 30, 2016 9:06 am**

Perfect Johan, thanks!
Thomas

EViews.com

From numbers to letters

From numbers to letters

Re: From numbers to letters

Re: From numbers to letters

Re: From numbers to letters