Posts by Facter

Facter · May 25th 2016

Re: Incrementing multiple values in a cell

Quote from crushdrinker06;771306

If you put

into A1 then put

Code

=CONCATENATE("UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=",MID(A1,73,1)+1,"]', '[nggallery id=",MID(A1,73,1)+1," display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=",MID(A1,73,1)+1,"]';")

into A2 and fill down it should work.

Hi Crushdrinker - thnakyou very much for your assistance! I have no idea how that forumla works as I dont know much about the concatenate one .. but, it looks good!

I did test it, and it looks like it is veyr veyr close to wroking! however, when it hits row "10" it resets and starts again from "2" - Ive added it below so you can check it out! And again, thankyou. You guys here are like excel magicians haha

Code

[TABLE="width: 936"]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=1]', '[nggallery id=1 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=1]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=2]', '[nggallery id=2 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=2]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=3]', '[nggallery id=3 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=3]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=4]', '[nggallery id=4 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=4]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=5]', '[nggallery id=5 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=5]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=6]', '[nggallery id=6 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=6]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=7]', '[nggallery id=7 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=7]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=8]', '[nggallery id=8 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=8]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=9]', '[nggallery id=9 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=9]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=10]', '[nggallery id=10 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=10]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=2]', '[nggallery id=2 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=2]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=3]', '[nggallery id=3 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=3]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=4]', '[nggallery id=4 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=4]';[/TD]
[/TR]
[TR]
[TD]UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=5]', '[nggallery id=5 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=5]';[/TD]
[/TR]
[/TABLE]

Display More

Facter · May 24th 2016

Hi guys

I've looked all over and tried a few of my own attempts at a forumal, but nothing is working.

I have a nextgen gallery and I am trying to change all the galleries to a different display format - nextgen does not offer this ability (which is stupid), which means I need to run a SQL query on about ohh, a thousand galleries to change it in the database. The problem is, is that doing over a thousand of these changes will be cumbersome .. I'd like tot ry and use Excel to do the incremental numbering -but, there are several numbers in each string and I dont know how to make these increment with a formula in excel ...

UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=1]', '[nggallery id=1 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=1]';

desired output

UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=2]', '[nggallery id=2 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=2]';
UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=3]', '[nggallery id=3 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=3]';
UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=4]', '[nggallery id=4 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=4]';

etc etc. Can someone help with a formula to allow these increments within the string?