How to insert a comma after every character? Any built in function?

[vkish16161]

All,

Here's my requirement:

Say I have ABCvnfj12$$ . I want this to become A,B,C,v,n,f,j,1,2,$,$ ?

How can I make it happen using back-end script?

stalwar1‌

[sunny_talwar · Accepted solution]

May be this

Table:

LOAD Field,

Concat(NewField, ',', RecNo()) as NewField

Group By Field;

LOAD Field,

Mid(Field, IterNo(), 1) as NewField

While IterNo() <= Len(Field);

LOAD * Inline [

Field

ABCvnfj12$$

];

[vkish16161]

This also works. Just found out the solution:

Test1:

load 1234 as ID, Concat(Dummy) as Dummy;

load * Inline [

Dummy

ASD,

Fv,

gn%,

$#&];

let vLen      = Len(Peek('Dummy',0,'Test1'));

let vString   = Chr(39)&Peek('Dummy',0,'Test1')&Chr(39);

For i = 1 to $(vLen)

load Mid($(vString), $(i),1) as Charecter

Autogenerate 1;

next