Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III
Creator III

concatenate fieldvalues with a slash inbetween

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

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

The syntax is wrong. You may try it with:

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

View solution in original post

1 Reply
marcus_sommer

The syntax is wrong. You may try it with:

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