SHOW IF statement Help

[Simon Gare]

Hi,

how could apply a 'Show IF' statement that would only show an entry if the
entry was a building name and not a number to the section below.

<td class="Collection"><span
class="DataSetText"><%=(Pricing.Fields.Item("COLL_ BUILDING_NAME_NO").Value)%

</span>

Example

want to show 1st line below

Heathrow Terminal 1 (This is stored in
Pricing.Fields.Item("COLL_BUILDING_NAME_NO").Value )
Croydon Road
Hounslow

Dont want to show first line below

23 ( This is also stored in
Pricing.Fields.Item("COLL_BUILDING_NAME_NO").Value )
South Audley Street
London
W1

Its just the numbers I dont want to show but i need to see the text.

Thanks in advance
Simon

[Mike Brind]

Simon Gare wrote:

Hi,

how could apply a 'Show IF' statement that would only show an entry if the
entry was a building name and not a number to the section below.

<td class="Collection"><span
class="DataSetText"><%=(Pricing.Fields.Item("COLL_ BUILDING_NAME_NO").Value)%

</span>

Example

want to show 1st line below

Heathrow Terminal 1 (This is stored in
Pricing.Fields.Item("COLL_BUILDING_NAME_NO").Value )
Croydon Road
Hounslow

Dont want to show first line below

23 ( This is also stored in
Pricing.Fields.Item("COLL_BUILDING_NAME_NO").Value )
South Audley Street
London
W1

Its just the numbers I dont want to show but i need to see the text.

Thanks in advance
Simon

Regular expressions:

<%
Dim str, re, retVal
str = Pricing.Fields.Item("COLL_BUILDING_NAME_NO").Value
Set re = new RegExp
re.Pattern = "[a-z]+"
re.Global = true
re.IgnoreCase = true
retVal = re.Test(str)
If retVal = true Then Response.Write str
Set rs = Nothing
%>

--
Mike Brind
%>

[Simon Gare]

Thanks Mike,

Simon
"Mike Brind" <pa*******@hotmail.com> wrote in message
news:11**********************@c74g2000cwc.googlegr oups.com...

Simon Gare wrote:

Hi,

how could apply a 'Show IF' statement that would only show an entry if the

entry was a building name and not a number to the section below.

<td class="Collection"><span

class="DataSetText"><%=(Pricing.Fields.Item("COLL_ BUILDING_NAME_NO").Value)%

</span>

Example

want to show 1st line below

Heathrow Terminal 1 (This is stored in
Pricing.Fields.Item("COLL_BUILDING_NAME_NO").Value )
Croydon Road
Hounslow

Dont want to show first line below

23 ( This is also stored in
Pricing.Fields.Item("COLL_BUILDING_NAME_NO").Value )
South Audley Street
London
W1

Its just the numbers I dont want to show but i need to see the text.

Thanks in advance
Simon

Regular expressions:

<%
Dim str, re, retVal
str = Pricing.Fields.Item("COLL_BUILDING_NAME_NO").Value
Set re = new RegExp
re.Pattern = "[a-z]+"
re.Global = true
re.IgnoreCase = true
retVal = re.Test(str)
If retVal = true Then Response.Write str
Set rs = Nothing
%>

--
Mike Brind
%>