using isnumeric

[Joey]

I am using an import process that scans an html file and exports data to
a sql database table.

One of the fields I import, on occasion has 2 numeric characters at the
very end. For example "thename 04".

What I need to do is delete those numeric characters, if they exist.

I thought about something like this:
if isnumeric(right(thename,2))=TRUE then

....but what's next? How do I make a new THENAME field without those
last two numeric characters if they exist?

Thanks for the help!

 

[Bob Barrows [MVP]]

I am using an import process that scans an html file and exports data
to a sql database table.

One of the fields I import, on occasion has 2 numeric characters at
the very end. For example "thename 04".

What I need to do is delete those numeric characters, if they exist.

I thought about something like this:
if isnumeric(right(thename,2))=TRUE then

...but what's next? How do I make a new THENAME field without those
last two numeric characters if they exist?

To do it in vbscript, you would do this:

thename = left(thename,len(thename)-2)


Bob Barrows

 

[Manohar Kamath]

You say "if they exist" -- meaning they may not? If so, you could do the
following:

Dim stringArray
dim namePart

' Split the string on the empty space
stringArray = Split(theName, " ")

' Retrieve the string before the space. if the space does not
' exist, you will get the entire string
namePart = stringArray(0)