Jump to content

removing all data but numbers in a text field


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

Recommended Posts

Hi all

I have this text field into which I store phone numbers. Entries usually look like this : 751-862-7845. I'm looking for a way to only keep numbers, so the field would now look like this 7518627845...is there a way to do this?

thanks in advance

:-)

Luc

Version: v6.x

Platform: Windows XP

Link to comment
Share on other sites

Hi Luc,

I can think of a couple of ways to do this depending on what you want the permanent data to be. You could strip the field using a loop script and the Replace Script Step with the Calculation of Substitute(YourPhoneField, "-", "") - This removes the "-" permanently.

Or

You could create a second field and make it a calculation using the Substitute calculation above - this preserves the original field.

HTH

Lee

Link to comment
Share on other sites

thanks guys

waow...I did not know 7 was out...I'll download the trial version(french will most probably come out later though...what a drag! wink).

I'll try your suggestions and let you know the result. Being a text field, I have other words sometimes included in there besides "-"...will that cause a problem in the substitute function that you suggested?

have a great day and thanks again for your input.

Luc

Link to comment
Share on other sites

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