Hi all, I'm looking for an SQL guru who can help me search and replace the image path in the database of my content type. I realized all of my images were going into unique folders but I would prefer just one. I've got a couple of hundred pieces of content so I'm hoping to do this as a query rather than by hand.
We actually ended up using excel to solve this. But I sure wish I could get my head around regex better.
export table to excel, highlight colulmn in question and use "text to columns" to break the path into 3 sub columns using "/" as the delimiter. Fill the ### path column with "flags" and then concatonate to reassemble into a single column.
You might also be interested in a recent tool that I found. http://nimbletext.com/ This probably could have done similar. I found nimble text when searching for a way to convert tables to def terms. Worked incredible, but I now have to learn how to use it as well. Check it out, I bet you'll find it to be interesting.