List of Contributions

As Steve said, this would work: out1.ProtocolNumber = in1.ProtocolNumber.split('|')[0] ------------------------------ Jay Reilly Precisely Software Inc. ------------------------------

Thanks Henrik. I'll give that a go. ------------------------------ Jay Reilly Precisely Software Inc. ------------------------------

I am looking to "flatten" several rows into a single row preserving values in different fields. The values will never clash (in the example below a single account would never have a colour Red in one row and Blue in another row with a need to figure out which to preserve). My data looks like this: ...