Remove Any Duplicate Words From Text Field

[DMT Dave]

Hi Guy's what is the method of finding and removing any duplicate words from a text field ?

Would something like:



Set rs = Currentdb("Select * From Table")

If Instr(rs.Fields")

then

replace("rs.Fields")

be a method ?

I can't think of the correct method but would imagine i would need to use Instr and Replace functions ?

Kindest

[Welshgasman]

No idea, but I know where I would start.

https://www.google.com/search?q=remo...hrome&ie=UTF-8

[DMT Dave]

WGM durrr silly me, I did search google but slightly different to how you searched

yes create a find duplicate query, copy the SQL and Run SQL

will give that a shot (no silly errors from me this time), i have copied the table in case I remove data i dont want to remove

[Welshgasman]

Well there was a function in one of those links.
The duplicate query is for records, not duplicate words in a field, so I would look again?

[Gicu]

Here is a module with a few very useful string manipulation functions that I've been using for years.

Cheers,

[DMT Dave]

Thanks Vlad, will have a look

[DMT Dave]

WGM, yes i realized that when i tried the wizard!!

Hi Vlad, that modFunction is a BAS file, is that correct as my PC is trying to find a program to open it ?

[Gicu]

Yes, that is the default when you export a module from Access VBA interface. Just open it with Notepad (you could even change the extension to .txt) and copy and paste it in a new module or import it from within your Access project.

Cheers,

[DMT Dave]

OK Vlad, thank you, i have never come across a BAS File before, now understand

Will take a look

Kindest