concatenate fieldvalues with a slash inbetween

chriys1337 — Fri, 21 Jul 2023 07:34:26 GMT

Hi,

I would like to concatenate some field values but add a slash '/' in between.

Table:

LOAD

CONCAT(Field,'&', ID) as Fields1, // works fine, Result A&B&C

CONCAT(Field,'& chr(39) / & chr(39) &', ID) as Fields2 // does not work; it should be A&'/'&B&'/'&C

Resident FieldNames;

Can anybody please help me?

BR,

chriys

Re: concatenate fieldvalues with a slash inbetween

marcus_sommer — Fri, 21 Jul 2023 07:48:10 GMT

The syntax is wrong. You may try it with:

CONCAT(Field,'&''/''&', ID) as Fields2