Page 1 of 1
Last 8 Digits
Posted: Fri Aug 24, 2007 9:13 am
by irajasekharhexa
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
Re: Last 8 Digits
Posted: Fri Aug 24, 2007 9:22 am
by gateleys
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?
Re: Last 8 Digits
Posted: Fri Aug 24, 2007 9:31 am
by gateleys
Another way -
Fmt(InputString, "R#8")
Re: Last 8 Digits
Posted: Fri Aug 24, 2007 9:39 am
by mujeebur
gateleys means is below:
MyString = "ABCDEF"
MySubStr = Right(MyString, 3) ;* answer is "DEF"
Re: Last 8 Digits
Posted: Fri Aug 24, 2007 10:41 am
by irajasekharhexa
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
Re: Last 8 Digits
Posted: Fri Aug 24, 2007 11:21 am
by gateleys
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.
Posted: Fri Aug 24, 2007 3:59 pm
by ray.wurlod
Apendix A, Parallel Job Developers Guide