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

does your data contains comma (,)

other than the delimiter.

Jump to Post

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 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.