topic Re: Adding a character in between a string at equal intervals dynamically in App Development

Adding a character in between a string at equal intervals dynamically

Mapuna — Tue, 20 Dec 2022 12:39:42 GMT

I have a table containing names in each row.

Table1:

I want to transform this into:

Re: Adding a character in between a string at equal intervals dynamically

MarcoWedel — Tue, 20 Dec 2022 20:12:21 GMT

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 ];

Re: Adding a character in between a string at equal intervals dynamically

Mapuna — Wed, 21 Dec 2022 05:27:36 GMT

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