Import bitweaver table format to tablepress

I have imported content into WP from a wiki page that was using bitweaver…the format of the tables in the wiki platform are quite different and i wonder if there is a query i can run in phpmyadmin to change the wiki table syntaxto regular html..

the wiki format sample is as below which when viewed is a table…

||RANK|COUNTRY|MILLION USA DOLLARS
1|South Africa|8,967
2|Egypt|8,133
3|Morocco|6,899
4|Tunisia|2,999
5|Mauritius|1,302
6|Kenya|1,182
7|Ghana|910
8|Ethiopia|639
9|Botswana|539||

Hi,

thanks for your question, and sorry for the trouble.

This format looks very similar to CSV, so that I suggest that you simply try to import it as that.

To increase the changes that the auto-detect works, you could a text editor and search/replace the bar | with a semicolon ;.

Regards,
Tobias

Tobias,

Thanks for the response, i replaced it and tried but was unable to import the table as a csv.

Hi,

what does the content that you then used look like?
Are you getting any error messages?

Regards,
Tobias

Hello,

I was able to import as csv all i did was edit the 2 bars at the beginning and end and remove them so i got as below and imported as csv…thanks.

RANK|COUNTRY|SCORE
1|Country A|74
2|Country b|70
3|Country c|69
4|Country d|3

Hi,

ah, nice find! Hadn’t really noticed those. Yes, if you remove them, this looks like regular CSV. Good to hear that importing worked with that!

Best wishes,
Tobias

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