Bulk search & replace approach

  • Resolved cigiloviccom

    (@cigiloviccom)


    2 years ago

    Hey Tobias,

    Just wanted to ask you a specific challenge I would like to overcome.

    I have a table I created in TablePress which contains 1300 rows and 3 columns.

    I need to bulk update a link attribute, but as the table is huge I am not able to open and edit it with a Chrome extension (Find replace). It’s definitely not an issue of TablePress as I’m pushing the limits of browsers as well ??

    What I want to find out is how can I access to SQL table that my TablePress uses? Had a look but couldn’t find it.

    My plan is to get the plain text version of this data and do the changes.

    Any suggestions?

    Many thanks!

    Kind regards,
    Osman

Viewing 1 replies (of 1 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Doing this in SQL will be pretty ugly and is risky, as you would be dealing with a JSON format inside the mySQL code, so challenges with quotation marks and slashes would be waiting…

    Instead, I recommend to simply export the table to the CSV format. Then, you can open that CSV file in any text editor or programming IDE, do your search/replace there, and re-import the CSV file, choosing to replace the existing table.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Bulk search & replace approach’ is closed to new replies.