By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,276 Members | 2,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,276 IT Pros & Developers. It's quick & easy.

SHOW IF statement Help

P: n/a
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
Jun 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

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

Jun 14 '06 #2

P: n/a
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
%>

Jun 14 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.