how to change field format

[Anonymous]

Dear All

I have a field as mentioned below:

Recommend dealer

1) Probably Would

2) Definitely Would

3) Probably Would Not

4) Definitely would not

I want this in below format:

Recommend make 1) Probably Would 2) Definitely Would 3) Probably Would Not 4) Definitely would not

How to achieve this?

[YoussefBelloum]

Hi,

your field is called Recommend dealer ?

and you have 4 lines, like this ?

1) Probably Would

2) Definitely Would

3) Probably Would Not

4) Definitely would not

you want to concatenate the lines on one lines like this ?

Recommend make 1) Probably Would 2) Definitely Would 3) Probably Would Not 4) Definitely would not

[Anonymous]

yes

[tresesco]

Try like (in a textbox):

='Recommend make '&Concat(Distinct [Recommend dealer] , ' ')

[Anonymous]

output shud be

1) Probably Would 2) Definitely Would 3) Probably Would Not 4) Definitely would not

[YoussefBelloum]

use this

'Recommend make '&concat([Recommend dealer],' ') as new

Find attached:

[Anil_Babu_Samineni]

Front end / Backend?

[Anonymous]

=concat([Recommend dealer],chr(32)) // UI.

//script

Load concat([Recommend dealer],chr(32)) as [Recommend dealer];
load * inline [
Recommend dealer

1) Probably Would

2) Definitely Would

3) Probably Would Not

4) Definitely would not
];