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.

</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]

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.




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
%>

 

[Simon Gare]

Thanks Mike,

Simon

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)%


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
%>