Newbies elom Posted June 14, 2001 Newbies Share Posted June 14, 2001 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 More sharing options...
eremaut Posted June 14, 2001 Share Posted June 14, 2001 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 More sharing options...
Anatoli Posted June 14, 2001 Share Posted June 14, 2001 Create second Calc field with Substitute function and substitute the CR out. Then export the second field and not the entry field. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8342 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 accountSign in
Already have an account? Sign in here.
Sign In Now