Get comma separated values of a field

[rajat2392]

Hi,

I have a field with number values. There are around 106,000 records in the table.

I want all the values in any object as comma separated.

Can anybody suggest me how to achieve it.

Thanks

Rajat Arora

[kaushiknsolanki]

Try this.

Concat(FieldName,',')

Regards,

Kaushik Solanki

[Chanty4u]

am not sure...

u can give  coma  for decimal and thousand..... it wil seperate comma.

[rajat2392]

It doesn't work for 100,000 records in my case.

[Chanty4u]

yes it is working for all..

go to document properties   > select nymber tab-->select ur Number fileds--->change to  override---> follow above image

[rajat2392]

Hi,

I need the distinct values in the field together with a comma separator.

This is not my requirement actually.

Thanks for the reply.

[kaushiknsolanki]

For a distinct value you can out distinct keyword.

Concat(Distinct FieldName,',')

Regards,

Kaushik Solanki

[kkkumar82]

Like this may be

Concat(Distinct fieldName,',')

Are you using this in text box or where?

Thanks

Kiran Kumar

[Chanty4u]

as mentioned Kaushik use distinct function=

=Concat(Distinct Filedname,',')

[rajat2392]

I have total 106,081 distinct values.

I want all of them to come in a row with comma separation.

It doesn't happen as the records are huge.

Is there any other way?

Thanks

Rajat Arora