Concatenate multiple rows into single row 1

[pl1101]

I need to convert multiple row into a single column separated by commas. I read another thread that tells me how to do it, but the comma is either is added to the end. How do I stop the comma from appearing at the end.

Example:
Id
1
2
3
4
4

Need to display:
id
1,2,3,4,4

It currently displays:
1,2,3,4,4,

I used thread# 767-1478748 to get the above results.

Thank you in advance. I really appreciate your help!

 

[lbass]

For the display formula, use:

whileprintingrecords;
stringvar x;
left(x,len(x)-1)

To create a link to a previous thread, write the word "thread" followed immediately by the thread number (no space), as in thread767-1478748.

-LB

 

[pl1101]

I added this code to the display and then I get an error message: "String length is less than zero or not an integer". Where and how do I check for zero length?

 

[pl1101]

The comma still is at the end of the string.

 

[lbass]

whileprintingrecords;
stringvar x;
if len(x) >= 1 then
left(x,len(x)-1)

This assumes you added a comma with no space (as shown in your sample). If there was a space, change it to -2. This formula belongs in the group footer.

-LB

 

[pl1101]

I need to display a date of Thursday of the current week. How do I do this? Please help!
Example: if it is Tuesday, Feb 23, 2010, I need to display 2/25/2010

 

[lbass]

Please start a new thread as this is a different topic.

-LB