Validate data entry question

[elom]

When entering data in a field defined as "text" I have the need to prohibit a possible "carriage return" because it is causing problems with an export of data that must be performed later. The hidden character caused by the "carriage return" is actually not the standard return (represented in ascii by decimal value 13) but is what I believe would be called a soft return.

My question is simply, how can I can this character be eliminated at the time of data entry? I would very much appreciate a response from anyone.

THANK YOU.

[eremaut]

Hi,

Plan A: try to strip (via loop script) the CR's before the actual export. But if the found set is very big or records are locked, then you are sitting ducks ...

Plan B: avoid the CR's in the first place. Just put a validation on the field like this:

Case( PatternCount( Text_Field; "

[Anatoli]

Create second Calc field with Substitute function and substitute the CR out.

Then export the second field and not the entry field.