No one answer yet ?

[#1]

if(index(Code, ' '), concat(left(Test, 1) & '(' & len(Test) & ')', ' ', Row), concat(left(Test, 1) & '(' & len(Test) & ')', '-', Row)) as Test2

[#2]

not sure why this expression is used. It checks for space in the Code field, if space presents then first letter of Test field and length of test field.

Eg: if Code = 'Country' and Test='India' then result would be

I(5)-

this will be repeated for total nyumber of occurences of India in data.

If India exists 5 times

I(5)-I(5)-I(5)-I(5)-I(5)

[Peter_Cammaert]

What exactly was your question?

[#4]

explination of above expression how it works