Neglect the duplicate from the string

Sgiri1 · Post by **Sgiri1** » Wed May 06, 2009 3:07 am

hi

i get a field with values like

8803981188PCLAW018803981188PCLAW01
MMNQ1MMNQ1
TTHQ1VGTTHQ1VG

how do i neglect the second set of duplicate string from the above using transformer?my output should be somethng like

8803981188PCLAW01
MMNQ1
TTHQ1VG

Thanks

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed May 06, 2009 3:21 am

Substring to half its length !!

Sgiri1 · Post by **Sgiri1** » Wed May 06, 2009 4:13 am

Sainath.Srinivasan wrote:Substring to half its length !!

can u exactly tell me how that could be done?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed May 06, 2009 4:46 am

What have you tried ?

Sgiri1 · Post by **Sgiri1** » Wed May 06, 2009 4:50 am

i have tried it through stage variables.
have taken the length of the string and divided it by two to get the original length and assigned the value to a stage variable. but i'm not sure in which function i shud use the stage variable to get the substring.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed May 06, 2009 4:56 am

Substrings

Sgiri1 · Post by **Sgiri1** » Wed May 06, 2009 5:05 am

thnks it wrkd :D