Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memo to Number field

Status
Not open for further replies.

luxvivens

Technical User
May 20, 2010
27
CA
Using Crystal X.
I have a Memo field with a provider number displayed as
'123456'

I would like to make this field a number field to show as
123456

I tried to make the memo field a text field and I did.
I then tried to make the new text field a number and it did not like that.

I wish to strip out the ' both at the beginning and end.

Hope all are safe on the blizzard like day in NorthEast.
 
Thanks. You know how all you mavens always instruct us to search on previous posts before submitting an inquiry.

Well, i did that after the fact. Some previous posts by SynapseVampire and LBass helped. I stripped the text field by using the replace function and that did the trick. I was then able to convert the string to a number.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top