Re: [WebDNA] Check to see if certain characters are numeric?

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 113243
interpreted = N
texte = 831--Apple-Mail=_5549B8E6-2C69-4FBD-AD0D-73923377C5FCContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiSomething like this ?[SHOWIF [GREP search=3D([^a-zA-Z ])&replace=3D*][getchars =start=3D1&end=3Dw&trim=3Dboth][MODELYEAR][/getchars][/GREP]^*]NON-NUMBERS =DETECTED[/SHOWIF]Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au> On 13 Dec. 2016, at 11:27, dale wrote:>=20> Hi,>=20> Is there a relatively easy way to check to see if the first 4 =characters of a field are numeric? I'm pulling data from another =database where the first 4 characters of a field could be the model year =of the vehicle or it would be the manufacturer name e.g. International, =Freightliner, etc. There is also the possibility that the field could be =blank.>=20> Thanks>=20> Dale> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_5549B8E6-2C69-4FBD-AD0D-73923377C5FCContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-ascii

Something like this ?

[SHOWIF [GREP search=3D([^a-zA-Z =])&replace=3D*][getchars =start=3D1&end=3Dw&trim=3Dboth][MODELYEAR][/getchars][/GREP]^*]NON-=NUMBERS DETECTED[/SHOWIF]

Kind regards

Stuart Tremain

Pharoah Lane =Software

AUSTRALIA

webdna@idfk.com.au

On 13 Dec. 2016, at 11:27, dale <dtherio@gmail.com> =wrote:

Hi,

Is there a relatively easy way to check to see if the first 4 =characters of a field are numeric? I'm pulling data from another =database where the first 4 characters of a field could be the model year =of the vehicle or it would be the manufacturer name e.g. International, =Freightliner, etc. There is also the possibility that the field could be =blank.

Thanks

Dale
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--Apple-Mail=_5549B8E6-2C69-4FBD-AD0D-73923377C5FC--. Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Check to see if certain characters are numeric? (Stuart Tremain 2016)
[WebDNA] Check to see if certain characters are numeric? (dale 2016)

831--Apple-Mail=_5549B8E6-2C69-4FBD-AD0D-73923377C5FCContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiSomething like this ?[SHOWIF [GREP search=3D([^a-zA-Z ])&replace=3D*][getchars =start=3D1&end=3Dw&trim=3Dboth][MODELYEAR][/getchars][/GREP]^*]NON-NUMBERS =DETECTED[/SHOWIF]Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au> On 13 Dec. 2016, at 11:27, dale wrote:>=20> Hi,>=20> Is there a relatively easy way to check to see if the first 4 =characters of a field are numeric? I'm pulling data from another =database where the first 4 characters of a field could be the model year =of the vehicle or it would be the manufacturer name e.g. International, =Freightliner, etc. There is also the possibility that the field could be =blank.>=20> Thanks>=20> Dale> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_5549B8E6-2C69-4FBD-AD0D-73923377C5FCContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-ascii