|
| |||||||
| Sponsored Links |
 | « Previous Thread | Next Thread » |
| | LinkBack (1) | Thread Tools | Display Modes |
 #1
May 8th, 2008, 07:16 AM
| ||||
| ||||
 Remove Duplicates From a String Say i have the following in a field <DeveloperBarn, Forums, Forums> How can i remove the duplicate words in a query? Thanks AOG
__________________ If i helped you, make me famous by clicking the  Last edited by AOG123; May 8th, 2008 at 07:35 AM. |
| Sponsored Links |
|
#2
May 8th, 2008, 10:25 AM
| ||||
| ||||
| This will need to be done in vba: Code: Dim pos1 as integer Dim pos2 as integer Dim newstring as string pos1=1 pos2=0 newstring="" Do while instr(pos1,me.yourfield, ",") > 0 Pos2=instr(pos1,me.yourfield, ",") if instr(pos1,newstring, mid(me.yourfield, pos1, pos2 - pos1))=0 newstring=newstring & mid(me.yourfield, pos1, pos2 - pos1) &", " End If Pos1 = Pos2+1 Pos2 = 0 Loop Me.yourfield = newstring Last edited by sbenj69; May 8th, 2008 at 11:20 AM. |
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| remove comma | todd2006 | JavaScript Programming | 12 | May 7th, 2008 10:55 AM |
|
LinkBacks (?)
LinkBack to this Thread: http://www.developerbarn.com/microsoft-access/175-remove-duplicates-string.html | ||||
| Posted By | For | Type | Date | |
| Remove duplicate words from a string - ASP Free | This thread | Refback | May 8th, 2008 11:14 AM | |
Linear Mode
