Row Delim
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
Hi swapnil,
This is not which we designed its a delivered job from people soft and iam analysing the job the design is like this.
RDBMS
|
|
\/
interprocess
| | |
\/
rowmerge------>transformer-->transformer---->rowsplit-->transformer
|
interprocess
|
|
\/
RDBMS
and 2 hash files refernce and update to second transformer
and i see this code in first transformer
This is not which we designed its a delivered job from people soft and iam analysing the job the design is like this.
RDBMS
|
|
\/
interprocess
| | |
\/
rowmerge------>transformer-->transformer---->rowsplit-->transformer
|
interprocess
|
|
\/
RDBMS
and 2 hash files refernce and update to second transformer
and i see this code in first transformer
This code takes fields 1-4 of string Merge_Out.CRC_ROW as delimited by value of the character in RowDelim and then trims all blanks from the beginning and end of the string.
for example, if RowDelim is the semicolon character ";" then
if
Then the result would be "Hello;there;Fellow;DSXchangers"
for example, if RowDelim is the semicolon character ";" then
if
Code: Select all
Merge_Out.CRC_ROW = " Hello;there;Fellow;DSXchangers ;in; the;internet"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
There is a reason for premium memberships to DSXChange and in this case there would seem to be two possible choices, either I could post the answer again as a non-premium message or you could change to premium membership. I am sure you can understand why choice 2 is the better route.
Of course another alternative would be if someone else would post an example.
Of course another alternative would be if someone else would post an example.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
Hi Raji,
Please verify RowDelim should be defined some where.
As there is no keyword in DS as "RowDelim"...
Trim(Field(Merge_Out.CRC_ROW,RowDelim,1,4),' ','B')
As per Field function definition ... it will treat value of RowDelim as delimiter and will return data between 3rd and forth occurrence of Delimiter.
Its a Difficult situation when u do not have sample input data ..
Please verify RowDelim should be defined some where.
As there is no keyword in DS as "RowDelim"...
Trim(Field(Merge_Out.CRC_ROW,RowDelim,1,4),' ','B')
As per Field function definition ... it will treat value of RowDelim as delimiter and will return data between 3rd and forth occurrence of Delimiter.
Its a Difficult situation when u do not have sample input data ..
Thanks
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"