Adding a character in between a string at equal intervals dynamically

[Mapuna]

I have  a table containing names in each row.

Table1:

I want to transform this into:

[MarcoWedel · Accepted solution]

Hi,
one solution could be:

mapInsChr:
Mapping LOAD Chr(RecNo()), Chr(RecNo())&'_' AutoGenerate 255;

tabNames:
LOAD *,
     Left(MapSubString('mapInsChr',NAME),Len(NAME)*2-1) as NAME_with_Char
Inline [
NAME
anup
peter
alexander
];

[Mapuna]

Hi, its the best solution i came across so far. I implemented something similar using for loop. But this looks efficient. Thanks for responding!