Last 8 Digits

irajasekharhexa · Post by **irajasekharhexa** » Fri Aug 24, 2007 9:13 am

Hi In one of my job i has a requirement where I need to pick only last 8 digits of a particulor Column.

Can pls anybody help?

Regds

gateleys · Post by **gateleys** » Fri Aug 24, 2007 9:22 am

irajasekharhexa wrote:Hi In one of my job i has a requirement where I need to pick only last 8 digits of a particulor Column.

Can pls anybody help?

Regds

Right?

gateleys · Post by **gateleys** » Fri Aug 24, 2007 9:31 am

Another way -

Fmt(InputString, "R#8")

mujeebur · Post by **mujeebur** » Fri Aug 24, 2007 9:39 am

gateleys means is below:

MyString = "ABCDEF"
MySubStr = Right(MyString, 3) ;* answer is "DEF"

irajasekharhexa · Post by **irajasekharhexa** » Fri Aug 24, 2007 10:41 am

mujeebur wrote:gateleys means is below:

MyString = "ABCDEF"
MySubStr = Right(MyString, 3) ;* answer is "DEF"

Mujeeb/Gateley.

Thansks lot. It's working fine.

Is these kind of built in functions where can i find in the manuals?

Regds

gateleys · Post by **gateleys** » Fri Aug 24, 2007 11:21 am

irajasekharhexa wrote:
Is these kind of built in functions where can i find in the manuals?

In the Transformer, right click on any column derivation for the DSTransforms and DSRoutines, among other things. You may want to click on Help to find out further details about each of these functions.

And may be, you could mark the topic as Resolved.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 24, 2007 3:59 pm

Apendix A, Parallel Job Developers Guide

DSXchange

Last 8 Digits

Last 8 Digits

Re: Last 8 Digits

Re: Last 8 Digits

Re: Last 8 Digits

Re: Last 8 Digits

Re: Last 8 Digits