That's great! Thanks, Mark.
I wanted to start writing a formula using Stored Signals in Data Lab. In this case, I will get the following:
I tried to write a function for converting "Name" to "Variable Name":
from re import split
def create_formula_variable_name(names):
formula_name = []
for name_i in names:
name_i_lower = name_i.lower()
name_i_list = split("_| | ", name_i_lower)
f_name = '$'
cnt = 0
if len(name_i_list) > 1:
for i in name_i_list:
f_name += i[0]
else:
if len(name_i_list[0]) > 4:
f_name += name_i_list[0][0]
else:
f_name += name_i_list[0]
formula_name.append(f_name)
return formula_name
However, this is not a perfect solution.