I need to get the variable (string) from a long name of a column in which I introduce the formula e.g. for col(A) I'm using Before script formula:
string str1=col(A)[L]$ OR
string str1=col(1)[L]$
But it forces me to define the column name/index (A or 1). I would like to have a script that read the column index and put it into the definition. For example in col(C) it will automatically change the index for 3:
string str1=col(C)[L]$ OR
string str1=col(3)[L]$
In this scenario I do not need to worry about the column index, it always read the index of a particular column.
Kind regards,
Dominik