Removing commas from fields

HCL Domino Domino Forum
1

I am loading data into a Text field which can include commas. When I build a view using this field, it treats it as a multiple value field and only displays the text after the comma.

I tried a formula to replace the comma with a space - this however did not remove the comma.

Any one know of a work around.

Thanks

2

Subject: removing commas from fields

Why don’t you remove the comma replacing it with “nothing” ? Like:

FIELD yourField := @Trim(@Replace(yourField;

“,”; “”));

Shouldn’t that work?

Regards,

Rune Carlsen

Founder Dominozone

http://www.dominozone.net