Dynamic Multi Field Value Replacement

[mjh418]

Hi All !

I need help with dynamic multi-field situation. 

Situation is below:

1. The number of Fields which differ by number suffix(1,2,3..) is NOT FIXED. So sometimes, there can be just two fields, Type and Type2. But sometimes it can be Type ~ Type 10 with 10 columns. 

2. I need to build a dynamic formula which IF TYPE is blank, then use the Type2 OR WHATEVER COLUMN THAT HAS A VALUE.

At least the good thing is there will always BE JUST ONE column that has A VALUE.  There will not be two or more columns with values. IF one column has a value, then REST columns will ALWAYS be empty. Just that the number of columns are not fixed but changeable.

Type	Type2	Type3	TypeXX....
11
	22
		33
			46

Expected Outcome:

Type

11

22

33

46

Thank you so much for your time.

[atcodedog05 · Accepted solution]

Hi @mjh418 

Question 1: Yes thats correct. You can do that.

Question 2: You can use formula like below

REGEX_Replace([Name2], "(.+\u)[\d_]+", "$1")

Hope this helps : )