Search and replace characters in certain columns

  • Resolved goodlab

    (@goodlab)


    4 years, 8 months ago

    Hi,
    We’ve discovered that in many tables there are characters that we’d like to replace. 2 examples

    in Col 2 there are <br> tags that we’d like to remove. Yes we can remove all of them

    In col 5 there are “|” characters that we’d like to replace with <br>

    So I am wondering if you have any ideas or general direction on how the data is stored and how we can run these search and replaces. I’m guessing we’ll have to do it through sql queries? I checked for a tablepress custom post type but didn’t see one. Is the table data stored in regular posts?

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 years, 8 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    TablePress tables are indeed stored as a Custom Post Type in the wp_posts database table. All tables are encoded as two-dimensional JSON arrays and have a value of tablepress_table in the post_type table column.

    You could probably do SQL search/replaces on those, but it might be easier to simply export the table to a CSV file in TablePress, do the search/replace in a text editor, and re-import the CSV file, choosing to replace the old version.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Search and replace characters in certain columns’ is closed to new replies.