Jump to content

Removing unwanted carriage return at end of text ?


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

Recommended Posts

Could someone please share with me how I can prevent the user from entering carriage returns at the end of a text field ?

or

Could someone please share with me how I could remove unwanted trailing carriage returns (that are followed by a blank line).

--- my exact problem is this:

2 fields:

street address

city, state, zip (combined from other fields)

On certain records, my users have entered a blank line after the text they've entered in the street address field, so my letter and envelope looks like this:

Tom Smith

12 Park Place

Box 479

New York, NY, 10021

what's the best way to avoid or deal with this ?

Thanks smile.gif

Link to comment
Share on other sites

In Define Fields, select your field and click Options. Select the Validation tab and click 'Validated by calculation'. In the resulting dialog box, enter either not Position( fieldname, "

Link to comment
Share on other sites

thank you..but... the problem with this is..

The field does have some valid carriage returns in it.

I don't want to test for carriage returns.. but only for those occurrences where a carriage return is followed by a blank line..

from my original post:

Tom Smith <---- all this (Tom Smith, 12 Park Place, Box 479, and that last carriage return)

12 Park Place are from one field... the last space is because the data enterer

Box 479 hit return one time too many... how do i get rid of that extra "return"

so there is no space before the 2nd field

New York, NY, 10021 <-- this is from the 2nd field when i use merge fields on my form letter ?

Link to comment
Share on other sites

This topic is 6429 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.