Jump to content

Validate data entry question


elom
 Share

This topic is 7430 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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; "

Link to comment
Share on other sites

This topic is 7430 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.