Is there a limit for max nested functions in column formula?

[bit]

As title says.

31 functions works:

Code: Select all

regex:"C:\\windows\\([^\\]+)$"  addcolumns:col1  col1:=REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(LOWER(regmatch1:),"^\x60","0X60"),"^\x61","0X61"),"^\x62","0X62"),"^\x63","0X63"),"^\x64","0X64"),"^\x65","0X65"),"^\x66","0X66"),"^\x67","0X67"),"^\x68","0X68"),"^\x69","0X69"),"^\x6A","0X6A"),"^\x6B","0X6B"),"^\x6C","0X6C"),"^\x6D","0X6D"),"^\x6E","0X6E"),"^\x6F","0X6F"),"^\x70","0X70"),"^\x71","0X71"),"^\x72","0X72"),"^\x73","0X73"),"^\x74","0X74"),"^\x75","0X75"),"^\x76","0X76"),"^\x77","0X77"),"^\x78","0X78"),"^\x79","0X79"),"^\x7A","0X7A"),"^\x7B","0X7B"),"^\x7C","0X7C"),"^\x7D","0X7D")

32 functions, col1 is empty:

Code: Select all

regex:"C:\\windows\\([^\\]+)$"  addcolumns:col1  col1:=REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(LOWER(regmatch1:),"^\x5F","0X5F"),"^\x60","0X60"),"^\x61","0X61"),"^\x62","0X62"),"^\x63","0X63"),"^\x64","0X64"),"^\x65","0X65"),"^\x66","0X66"),"^\x67","0X67"),"^\x68","0X68"),"^\x69","0X69"),"^\x6A","0X6A"),"^\x6B","0X6B"),"^\x6C","0X6C"),"^\x6D","0X6D"),"^\x6E","0X6E"),"^\x6F","0X6F"),"^\x70","0X70"),"^\x71","0X71"),"^\x72","0X72"),"^\x73","0X73"),"^\x74","0X74"),"^\x75","0X75"),"^\x76","0X76"),"^\x77","0X77"),"^\x78","0X78"),"^\x79","0X79"),"^\x7A","0X7A"),"^\x7B","0X7B"),"^\x7C","0X7C"),"^\x7D","0X7D")

How to remove such limit?
I need to do ~100 regex_replace to build col1, with such limit there is no way to achieve it.

[bit]

Just found an workaround using multiple vars:

Code: Select all

regex:"C:\\windows\\([^\\]+)$"  addcolumns:col1    
cola:=REGEX_REPLACE(...(LOWER(regmatch1:),"^\x21","0X21"),"...)                      
colb:=REGEX_REPLACE(...$cola:,"^\x3F","0X3F"),...)                      
....
col1:=$colf: 

It's harder to view and edit, also there is a limit of max 16 assignable columns.