Replace String

kumar66 · Post by **kumar66** » Wed Nov 05, 2014 9:45 am

Hi All,

I have a requirement where the last field in a row needs to contain unique value

for e.g.
input

aaa,rrrr,1|2|1|3
bbb,eee,1|2|2|3

output:
aaa,rrrr,1|2|3
bbb,eee,1|2|3

Please advise.

Thanks.

chulett · Post by **chulett** » Wed Nov 05, 2014 10:14 am

What have you tried?

kumar66 · Post by **kumar66** » Wed Nov 05, 2014 10:53 am

I tried by breaking the last filed through looping and remove duplicate on the entire row so no two rows are loaded.

But trying to find out to replace rather than breaking the field.

Thanks

chulett · Post by **chulett** » Wed Nov 05, 2014 10:55 am

I don't believe you have any other option here. I don't see a way off the top of my head to do any kind of intelligent "replace string" to remove randomly placed duplicate values.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 05, 2014 3:32 pm

I don't think there's a solution without creating a routine.

In a routine you can do whatever you're skilled enough to accomplish programmatically.

priyadarshikunal · Post by **priyadarshikunal** » Thu Nov 06, 2014 7:43 am

pivot > remove duplicate > vertical pivot

priyadarshikunal · Post by **priyadarshikunal** » Thu Nov 06, 2014 7:44 am

but please check if it fits in to your situation.

stuartjvnorton · Post by **stuartjvnorton** » Thu Nov 06, 2014 6:14 pm

Off the top of my head, I'm thinking transformer loop, Field, reconstruct with dedupe inside the loop, push out on end of loop.