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?..

Recommended Answers

All 2 Replies

does your data contains comma (,)

other than the delimiter.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.