10 posts by 3 authors in: Forums > CMS Builder
Last Post: February 9, 2016   (RSS)

I need to edit about 10,000 text fields by adding in a number zero in front of all of them.

Example: My text field is now saying 12345 and i need them to say 012345 instead.

Can this be done on the CMS itself or can anyone suggest a simple solution.

Thank you.

Hi,

If you have experience with mySQL you could run a mySQL command to prepend the field to add 0.

This could be done via phpMyAdmin or using the MySQL Console Add-On here:

http://www.interactivetools.com/add-ons/mysql-console/

Be sure to make a complete backup of your database first. And if you have a staging environment,  that would be preferred.

---------------------------------------------------
Cheers,
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

I have ZERO experience with mySQL. Any step-by-step assistance with this will be greatly appreciated. Thank you.

I just sent an email to consulting@interactivetools.com concerning this. Please let me know if it was received and the next step in getting this sorted out. Thank you.

Hi there.

This is Ross in consulting. Just wanted to let you know I haven't seen your email yet.  Could you check on your end to see if it's stuck in an outgoing mail box or maybe just send another one?

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Resent from another email address. khayam.trinicarsforsale@gmail.com

Hi Arif

Thanks for sending the email again. I got this one and replied to it already.

We can continue the conversation via that email thread.

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Apparently some of my emails are not going through. I sent a response. Let me know if you got it. Thank you.

Thanks for the heads up.  Looks like our emails are coming through fine.  We can continue the conversation via email moving forward.

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/