how to get last value in each row

jhansi · Post by **jhansi** » Wed Jun 20, 2012 2:01 am

source
a
a_b
a_b_c
a_b_c_d

target
a
b
c
d

chetan.c · Post by **chetan.c** » Wed Jun 20, 2012 2:22 am

Hi,

In the output derivation:

field(DSLink2.val,"_", @INROWNUM)

Transformer has to run in sequential mode.

Thanks,
Chetan.C

chulett · Post by **chulett** » Wed Jun 20, 2012 7:07 am

I seriously doubt that example actually represents the incoming data such that you can assume the last field will always match the row number. A generic answer would be to count() the delimiters and pull the "count+1" field from the "_" delimited string.

trammohan · Post by **trammohan** » Thu Jun 21, 2012 9:51 am

DSLink8.val[ Len(Trim(DSLink8.val )),1]

chulett · Post by **chulett** » Thu Jun 21, 2012 10:43 am

trammohan wrote:DSLink8.val[ Len(Trim(DSLink8.val )),1]

Again, I think people are putting too much faith in the accuracy of the example posted. They want the last "value" / field, not the last character.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 21, 2012 5:31 pm

Code: Select all

Field(InLink.TheString, delimiter, Count(InLink.TheString, delimiter) + 1, 1)

ray.wurlod · Post by **ray.wurlod** » Thu Jun 21, 2012 5:32 pm

Code: Select all

Field(InLink.TheString, delimiter, Count(InLink.TheString, delimiter) + 1, 1)

chulett · Post by **chulett** » Thu Jun 21, 2012 5:32 pm

Just like I said.