Concatenate String Formula ?

[mhamlett]

I'm not sure the formula I need, hopefully someone can give me advice and point me in the right direction.

Field_______________ Field2
example1.................. red
example1.................. blue
example1.................. green
example2.................. red
example2.................. green


----------------------------------------------------------------------------------------

I need it to look like this

Field_______________ Field2
example1.................. red blue green
example2.................. red green


Thanks in advance!

 

[BettyJ]

Group on Field

Write the following three formulas

@init
WhilePrintingRecords;
stringvar concat_field2:="";
Place it in GH of Field

@Concat_Field2
whileprintingrecords;
stringvar concat_field2:=concat_field2&{Field2}&" ";
concat_field2;
Place it in Details

@Disp_Concat_field2
whileprintingrecords;
stringvar concat_field2;
concat_field2;
Place it in GF of Field

Suppress GH and Details
Hope this helps

 

[SkipVought]

Are there ALWAYS 3 field2 values for any field1 value?

Are there EVER more than 3?

 

[mhamlett]

There will be more than 3 at times. Thanks for the quick feedback but I may actually go a different route to accomplish my needs, is there a way to create a unique text field next to each data field?

example

data............unique_text1
data............unique_text2
data............unique_text3
data............unique_text4
data............unique_text5
data............unique_text6
data............unique_text7
data............unique_text8
etc.

The text will be manual input that changes daily, given my situation I can rely on this scenario more so than using the data fields I have available. I will however save the information you gave me BettyJ for other projects down the road, Thanks!