Remove dashes in Lotus Approach 9.8

5 pts.
Tags:
Lotus Approach
I have a number column (1234-12-1234) in a Real Estate Database. I need to remove the dashes so it reads 1234121234. This is not a single cell it is for over 300,000 cells. The entire column.


Software/Hardware used:
LOTUS APPOACH V9.8
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Select the column. Go to Edit on the Main Menu. Choose Find and Replace Text. Replace – with nothing.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Use the Replace() function to replace the characters you don't wont with the ones you want if you want to remove the character a empty string for the replacement character will give this result.
    141,290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: