Support » Plugin: TablePress » Can’t replace in TablePress

  • Resolved casiomeron

    (@casiomeron)


    Thank you for a wonderful plugin.
    I am in trouble because I can not replace words in table.

    target="_blank">example</a>

    ↑ I want to convert this to the following. ↓

    target="_blank" rel="nofollow">example</a>

    Better Search Replace is used for substitution.

    Although it does not hit even if it searches as follows, is it wrong?
    target=\"_blank\">example<\/a>

    This was useless too.

    target="_blank">example<\/a>

    Is the position of \ incorrect?

    I referred to this topic. https://wordpress.org/support/topic/find-and-replace-across-all-tables-on-a-site/?replies=10

    Sorry for the poor English. It is a fan of your plugin. from Japan.

    • This topic was modified 8 months, 2 weeks ago by  casiomeron.
    • This topic was modified 8 months, 2 weeks ago by  casiomeron.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    This looks all correct to me. Can you maybe check in the mySQL database what the content looks like there? And are you sure that your search/replace plugin is replacing in every database table?

    Regards,
    Tobias

    Thank you for the reply. I think that it is difficult to read because I am using Google translation. I’m sorry.

    The “example” part is actually a Japanese character string. If it is English it may cause the search to hit character code.

    I do not know how to hit Japanese if I decode Japanese … · · ·.
    http://www.encodemaniax.com/

    Is there any hint to search Japanese from the MySQL database table?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    You should really check how the content looks like in mySQL, e.g. using a tool like phpMyAdmin.

    Most likely, you will find that the Japanese characters are encoded as UTF-8 entities (looking like \u1234, with some other number). This is what you will have to use in the search/replace).

    Regards,
    Tobias

    I appreciate your help.
    phpMyAdmin used “UTF – 8”. Even when converting a character string, we are still searching for a solution method without hitting the search.

    I will report it if there is progress.

    Thank you very much.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    Maybe you can then try searching/replacing directly using an SQL query in phpMyAdmin?

    Regards,
    Tobias

    I’m sorry for replying late.

    In conclusion, we have found the converted character string from “phpMyAdmin” → “post_content”!

    I can not thank you enough.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Can’t replace in TablePress’ is closed to new replies.