asp cut

crmpicco · April 1st, 2005, 07:07 AM

This code:

Code:

<%
response.write pnrxml.documentElement.childNodes.item(1).childNodes.item(j).childnodes.item(14).text
%>

gives me either:

Business Class
Economy Class

____________

How do i cut the value by the space?

So that the value is only Business or Economy?

Picco

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt

Santhi · April 1st, 2005, 07:13 AM

Use substring and extract the text till space.

crmpicco · April 1st, 2005, 07:16 AM

how do i do that?

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt

Santhi · April 1st, 2005, 07:25 AM

DO like this...
dim strS = pnrxml.documentElement.childNodes.item(1).childNod es.item(j).childnodes.item(14).text
dim pos = Instr(1,strS," ", CompareMethod.Text)
Response.write Left(strS,pos)

Instr will get the position of the space character and Left will get the extract substring from the text till mentioned position starting from the left.

crmpicco · April 1st, 2005, 07:31 AM

I get error:

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/mackenzie/asp/multileg3.asp, line 897, column 9
dim strS = pnrxml.documentElement.childNodes.item(1).childNod es.item(j).childnodes.item(14).text

with this code:

Code:

<%
dim strS = pnrxml.documentElement.childNodes.item(1).childNodes.item(j).childnodes.item(14).text
dim pos = Instr(1,strS," ", CompareMethod.Text)
Response.write Left(strS,pos)
%>

thanks for your help btw!

what is wrong with this code?

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt

crmpicco · April 1st, 2005, 07:36 AM

I have this code:

Code:

<% if pnrxml.documentElement.childNodes.item(1).childNodes.item(j).childnodes.item(14).text="Economy Class" then%>
              Economy
              <% elseif pnrxml.documentElement.childNodes.item(1).childNodes.item(j).childnodes.item(14).text="Business Class" then%>
              Business
              <% end if %>

but its unsuitable for other classes!

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt