remove duplicates from one cell at a time

[TheVedek]

I am trying to get rid of dups from a table that I imported.


ID Data
1 string1, string2, string1, string4
2 string2, string6, string2, string1

I want it to look like

ID Data
1 string1, string2, string4
2 string2, string6, string1

How would I go about doing this.

Thanks

 

[Jeff Boyce]

Are you saying that you want to end up with a field that contains multiple
facts (e.g. "string1, string2, string4")? This is not a good database
design.

You may be receiving data structured like this, but if you want to make the
best use of Access' relationally-oriented features and functions, you'll
need to do a bit more normalization.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[TheVedek]

Jeff,

No I don't want this in my access table, I want to export it to excel. I
use access as a conduit because there is bunch of other data I add to the
export.

Thanks

 

[Jeff Boyce]

It isn't clear from your description if the multiple "strings" in the field
are in any particular order, so I'm guessing they are not. In that case,
you may be limited in how you can handle it in Access.

Consider, however, exporting the data to Excel and using the Parse function
to create separate fields/columns for each value (i.e., separated by ","s).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP