Access Query: Adding a space after a comma...

[NuGG]

I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!)

Now I am trying to create a query that can add these spaces in automatically so I don’t end up spending weeks manually adding spaces to all the data in every record.

The field is called meta_keyword, and the data looks something like this:

[123abc,456def,789ghi,]

...but I need it to look like this:

[123abc, 456def, 789ghi, ]

Anyone got any suggestions on how spaces can be added after each comma automatically using an update query?..

[debasisdas]

does your data contains comma (,)

other than the delimiter.

[ChrisPadgham]

UPDATE Rooms SET Rooms.meta_keyword = Replace([meta_keyword],",",", ");