How to make one string containins all of a column (1 Viewer)

DowdUCC

New member
Local time
Today, 14:18
Joined
Jul 25, 2013
Messages
7
Hi,

i want to make a string that contains all of the fields in a column.

I have a table called UserSelectedComponentT with a column called ComponentName.

I want a string that is essentially all the different component names seperated by a " + " .

Is this possible?
 

pr2-eugin

Super Moderator
Local time
Today, 14:18
Joined
Nov 30, 2011
Messages
8,494
Hello DowdUCC, Welcome to AWF.. :)

I think I am a bit :confused: Fields are sometime referred to as Columns.. So when you say fields and Columns in the same sentence it confuses me.. Could you show some sample data of how data is organized and how you want the output to be?
 

DowdUCC

New member
Local time
Today, 14:18
Joined
Jul 25, 2013
Messages
7
Of course.

Say I have a table called UserSelectedComponentT with a column called ComponentName with 3 values like so:

ComponentName
Siemens 500 Generator
Bosch PXS Gearbox
LM 50 Blades


how do i create a string that reads "Siemens 500 Generator - Bosch PXS Gearbox - LM 50 Blades"
 

CazB

Registered User.
Local time
Today, 14:18
Joined
Jul 17, 2013
Messages
309
where do you want to use the resultant string?
 

Users who are viewing this thread

Top Bottom