Clean up bad data

[rittermd]

I have a situation where I have data coming in on multiple records due to formatting differences.

So I have 1 record with Smith,John in a field.  Then I have another records with Smith, John (space after the comma).  I want to combine these 2 into a single record with Smith,John in the load script.

Not quite sure how to tackle this.

Thanks

[Or · Accepted solution]

If your only issue is excess spaces, you could use PurgeChar(Name,' ') to remove them (or, if you'd always like to have the space, Replace(PurgeChar(Name,' '),',',', ')

You can then group by using this field, etc.