String Handling

saur_classic · Post by **saur_classic** » 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

DSguru2B · Post by **DSguru2B** » Thu Jan 11, 2007 7:23 pm

Use Dcount and Field. Something like

Code: Select all

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

ray.wurlod · Post by **ray.wurlod** » 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)