remove duplicates from one cell at a time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheVedek - 01 Nov 2007 19:37 GMT

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

Reply to this Message

Jeff Boyce - 01 Nov 2007 20:52 GMT

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

>I am trying to get rid of dups from a table that I imported.
>
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

TheVedek - 01 Nov 2007 21:14 GMT

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

> 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
[quoted text clipped - 24 lines]
> >
> > Thanks

Reply to this Message

Jeff Boyce - 01 Nov 2007 23:39 GMT

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

> Jeff,
>
[quoted text clipped - 34 lines]
>> >
>> > Thanks

Reply to this Message