How can I cunningly remove thousand separators from nos. converted to text?

[Former Member]

Its all in the title.

I have a string formula to concatenate various string fields together which works fine, however I come a little unstuck when adding a number to the end of the string that is 1000 or greater.

I dont wish to see the comma (thousand separator).

I use the Totext formula to convert the number to text

eg Totext (,0) where might be a Year 2008

This would appear as 2,008

I also have audit numbers that could go into the millions and have 2 commas.

Is there an easy way to remove them, or should I build up a string character by character using a loop formula?

Thanks

[ken_hamady2]

Use:

Totext (,0,"")

that is an empty string or two double quotes as the 3rd argument

[Former Member]

Moved question to Crystal design section

[former_member11696]

Hi Richard,

I moved this post for you.

Thank you

Don

[Former Member]

Hi,

1)Whatt version of Crystal reports are you using?

2) Do you see this issue in the CR designer? If so, please post to the Report Design forum:

[;

Note that if the issue exists in the CR designer, the issue will exist at runtime also and needs to be resolved in the designer 1st.

3) If this is only happening in a runtime application, specify the CR SDK used and the development language used as well as version of the development language.

Amit

[Former Member]

Yes, this problem does occur in design mode too, so i will repost in the correct place.

Thanks