concatenate rows and enclose them within single quotes

[#1]

I have a name field

I want to concatenate all the names within single quotes

Ex : Name

       Sam

        John

       Adam

       Alex

I want the result to be

'Sam','John','Adam',' Alex'

Want it to be done in script not front end

Any ideas ?

[swarup_malli · Accepted solution]

Try this

[Your table]:

Load concat(CHR(39)&Names&CHR(39),',') as ResultNames;

LOAD Names

FROM Your file;

[Clever_Anjos]

T:

LOAD * INLINE [

Name

Sam

John

Adam

Alex

];

LOAD chr(39) & Concat(Name,chr(39)&','& chr(39)) & chr(39) as value Resident T;

[#4]

Thank you guys