DSXchange

Posted: **Thu Jan 11, 2007 7:09 pm**

Hi,

I am facing difficulties in extract the last portion from the URL string
for e.g.
Source sends "root^xhtmlmp^samsung(xhtml)^samsungsgh-a701" and we need "samsungsgh-a701" from it.

Does Datastage provides any Function to do the above job?

Saur

Posted: **Thu Jan 11, 2007 7:23 pm**

Use Dcount and Field. Something like

Code: Select all

Field(InLink.RecIn, "^", DCOUNT(In.Col,"^"))

Posted: **Thu Jan 11, 2007 9:04 pm**

If DCount() does not work in the expression, use Count().

Code: Select all

Field(InLink.RecIn, "^", Count(In.Col,"^")+1, 1)

DSXchange

String Handling

String Handling