Everything re: Tables and this forum. - Neowise - 02-08-2021
Tables and using notpad++ as go between between google sheets and this forum
SpoilerShow Content
Install notepad++ if you have not already.
open notepad++.
We shall now create the macro to do the magic.
I will be writing in a codebox so that forum ignores the codes i will be using.
important, make it so you can read this post and type in notepad++, as you will need to type exactly what is between the inverted commas below, and not cut and paste, as the macro record wont pick that up.
Code: with notepad open at a new blank documnent, click macro->start recording
then press CRTL+HOME (to return us to the start of the file)
type "[table=30]" and press enter
click search->replace...
click extended search mode
in find what type "\t"
in replace type "[/td][td]"
click replace all
in find what type "\n"
in replace type "[/td][/tr]\n[tr][td]"
click replace all
click close
press CRTL+END and type "[/td][/tr][/table]"
click macro->stop recording
click save current recorded macro and name it "make table"
Done....
now to test..
Copy a table from sheets and paste into a blank notepad++
then click macro->make table
If everything went correct you will have a correctly formatted table with an extra /td /tr at the top after table you can trim off.
[/td][/tr]
OrderDate | Region | Rep | Item | Units | UnitCost | Total |
1/6/2020 | East | Jones | Pencil | 95 | 1.99 | 189.05 |
1/23/2020 | Central | Kivell | Binder | 50 | 19.99 | 999.5 |
2/9/2020 | Central | Jardine | Pencil | 36 | 4.99 | 179.64 |
2/26/2020 | Central | Gill | Pen | 27 | 19.99 | 539.73 |
3/15/2020 | West | Sorvino | Pencil | 56 | 2.99 | 167.44 |
4/1/2020 | East | Jones | Binder | 60 | 4.99 | 299.4 |
4/18/2020 | Central | Andrews | Pencil | 75 | 1.99 | 149.25 |
5/5/2020 | Central | Jardine | Pencil | 90 | 4.99 | 449.1 |
5/22/2020 | West | Thompson | Pencil | 32 | 1.99 | 63.68 |
6/8/2020 | East | Jones | Binder | 60 | 8.99 | 539.4 |
6/25/2020 | Central | Morgan | Pencil | 90 | 4.99 | 449.1 |
now that most of the grunt work is done, you can beauitify it by using th for header
OrderDate | Region | Rep | Item | Units | UnitCost | Total |
1/6/2020 | East | Jones | Pencil | 95 | 1.99 | 189.05 |
1/23/2020 | Central | Kivell | Binder | 50 | 19.99 | 999.5 |
2/9/2020 | Central | Jardine | Pencil | 36 | 4.99 | 179.64 |
2/26/2020 | Central | Gill | Pen | 27 | 19.99 | 539.73 |
3/15/2020 | West | Sorvino | Pencil | 56 | 2.99 | 167.44 |
4/1/2020 | East | Jones | Binder | 60 | 4.99 | 299.4 |
4/18/2020 | Central | Andrews | Pencil | 75 | 1.99 | 149.25 |
5/5/2020 | Central | Jardine | Pencil | 90 | 4.99 | 449.1 |
5/22/2020 | West | Thompson | Pencil | 32 | 1.99 | 63.68 |
6/8/2020 | East | Jones | Binder | 60 | 8.99 | 539.4 |
6/25/2020 | Central | Morgan | Pencil | 90 | 4.99 | 449.1 |
Code: to convert from sheets to here:
prepend [table=30]
find replace
\t with [/td][td]
\n with [/td][/tr]\n[tr][td]
append [/td][/tr][/table]
RE: Tables and using notpad++ as go between between google sheets and this forum. - Neowise - 02-08-2021
comments and improvements and alternatives welcome
RE: Tables and using notpad++ as go between between google sheets and this forum. - Neowise - 02-08-2021
For Notepad++
alternative to making the macro is to import the one i have already created by editing the shortcuts.xml file for notepad++ and adding this macro inside the <macros> section.
Code: <Macro name="make table" Ctrl="no" Alt="no" Shift="no" Key="0">
<Action type="0" message="2316" wParam="0" lParam="0" sParam="" />
<Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
<Action type="3" message="1601" wParam="0" lParam="0" sParam="\n" />
<Action type="3" message="1625" wParam="0" lParam="1" sParam="" />
<Action type="3" message="1602" wParam="0" lParam="0" sParam="[/td][/tr]\n[tr][td]" />
<Action type="3" message="1702" wParam="0" lParam="770" sParam="" />
<Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />
<Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
<Action type="3" message="1601" wParam="0" lParam="0" sParam="\t" />
<Action type="3" message="1625" wParam="0" lParam="1" sParam="" />
<Action type="3" message="1602" wParam="0" lParam="0" sParam="[/td][td]" />
<Action type="3" message="1702" wParam="0" lParam="770" sParam="" />
<Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />
<Action type="0" message="2316" wParam="0" lParam="0" sParam="" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="[" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="t" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="a" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="b" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="l" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="e" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="=" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="3" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="0" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="]" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="
" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="
" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="[" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="t" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="r" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="]" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="[" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="t" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="d" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="]" />
<Action type="0" message="2318" wParam="0" lParam="0" sParam="" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="[" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="/" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="t" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="d" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="]" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="[" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="/" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="t" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="r" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="]" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="
" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="
" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="[" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="/" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="t" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="a" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="b" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="l" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="e" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="]" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="
" />
<Action type="1" message="2170" wParam="0" lParam="0" sParam="
" />
</Macro>
path to shortcuts.xml on windows "C:\Users\your_username\AppData\Roaming\Notepad++\shortcuts.xml"
as added bonus, this one no longer has the extra /tr /td at the start
RE: Tables and using notpad++ as go between between google sheets and this forum. - nothing - 12-08-2021
I've been using this site for my MSPaint tables
https://www.teamopolis.com/tools/bbcode-table-generator.aspx
RE: Tables and using notpad++ as go between between google sheets and this forum. - Neowise - 12-08-2021
ah, very good..
I went looking and found this Table Convertor
copy paste from excel or google sheets
Only thing I had to do was edit [ table ] and change to [ table=60 ]
OrderDate | Region | Rep | Item | Units | UnitCost | Total |
1/6/2020 | East | Jones | Pencil | 95 | 1.99 | 189.05 |
1/23/2020 | Central | Kivell | Binder | 50 | 19.99 | 999.5 |
2/9/2020 | Central | Jardine | Pencil | 36 | 4.99 | 179.64 |
2/26/2020 | Central | Gill | Pen | 27 | 19.99 | 539.73 |
3/15/2020 | West | Sorvino | Pencil | 56 | 2.99 | 167.44 |
4/1/2020 | East | Jones | Binder | 60 | 4.99 | 299.4 |
4/18/2020 | Central | Andrews | Pencil | 75 | 1.99 | 149.25 |
5/5/2020 | Central | Jardine | Pencil | 90 | 4.99 | 449.1 |
5/22/2020 | West | Thompson | Pencil | 32 | 1.99 | 63.68 |
6/8/2020 | East | Jones | Binder | 60 | 8.99 | 539.4 |
6/25/2020 | Central | Morgan | Pencil | 90 | 4.99 | 449.1 |
RE: Everything re: Tables and this forum. - Necro - 19-08-2021
Handy table converter here that Trigger found: https://theenemy.dk/table/
Takes your excel/sheets info and wraps BBC Code around it.
The only alteration you need to make is the first table in square brackets needs to have an '=' added to it.
Edit: Lol it's the same one Neo found. I've only realised it now as his link is a bit broken
RE: Everything re: Tables and this forum. - Neowise - 19-08-2021
(19-08-2021, 07:51 PM)Necro Wrote: Handy table converter here that Trigger found: https://theenemy.dk/table/
Takes your excel/sheets info and wraps BBC Code around it.
The only alteration you need to make is the first table in square brackets needs to have an '=' added to it.
Edit: Lol it's the same one Neo found. I've only realised it now as his link is a bit broken
fixed the link. yeah, cool site, makes it way handy.
RE: Everything re: Tables and this forum. - Neowise - 07-09-2021
making it so [ table ] works now just at full width. should hopefully fix te bug where things mess up if you post a [ table ] and let it go thru.
OrderDate | Region | Rep | Item | Units | UnitCost | Total |
1/6/2020 | East | Jones | Pencil | 95 | 1.99 | 189.05 |
1/23/2020 | Central | Kivell | Binder | 50 | 19.99 | 999.5 |
2/9/2020 | Central | Jardine | Pencil | 36 | 4.99 | 179.64 |
6/25/2020 | Central | Morgan | Pencil | 90 | 4.99 | 449.1 |
RE: Everything re: Tables and this forum. - DejaBoo - 04-10-2021
I have to try these for mspaint, may use this post as a tester if that is ok?
LINK | DESCRIBE | PAINT |
1 | Edser | nothing |
2 | Wichita Lineman | Leg End Reject |
3 | Trigger | aaronjennings |
4 | cee_jay | [open] |
5 | HildaSilvioOgden | [open] |
later | [open] | *Homer J. Fong* (aft 14th) |
Oh sheesh Trigs (I forgot about preview) ...Thanks! it worked, thanks!!!
(How did you get the colours in the header line, Neo?)
RE: Everything re: Tables and this forum. - Trigger - 04-10-2021
Best way to try it is put it in your post and hit preview post and see if it works..
You can try it here no problem
RE: Everything re: Tables and this forum. - Neowise - 04-10-2021
(04-10-2021, 06:02 PM)DejaBoo Wrote: I have to try these for mspaint, may use this post as a tester if that is ok?
LINK | DESCRIBE | PAINT |
1 | Edser | nothing |
2 | Wichita Lineman | Leg End Reject |
3 | Trigger | aaronjennings |
4 | cee_jay | [open] |
5 | HildaSilvioOgden | [open] |
later | [open] | *Homer J. Fong* (aft 14th) |
Oh sheesh Trigs (I forgot about preview) ...Thanks! it worked, thanks!!!
(How did you get the colours in the header line, Neo?)
first line, replace table data for table header, that is (td)data(/td) (th)blue header(/th)
RE: Everything re: Tables and this forum. - Neowise - 04-10-2021
(04-10-2021, 06:02 PM)DejaBoo Wrote: I have to try these for mspaint, may use this post as a tester if that is ok?
LINK | DESCRIBE | PAINT |
1 | Edser | nothing |
2 | Wichita Lineman | Leg End Reject |
3 | Trigger | aaronjennings |
4 | cee_jay | [open] |
5 | HildaSilvioOgden | [open] |
later | [open] | *Homer J. Fong* (aft 14th) |
Oh sheesh Trigs (I forgot about preview) ...Thanks! it worked, thanks!!!
(How did you get the colours in the header line, Neo?)
editing your table
RE: Everything re: Tables and this forum. - DejaBoo - 04-10-2021
(04-10-2021, 09:23 PM)Neowise Wrote: (04-10-2021, 06:02 PM)DejaBoo Wrote: I have to try these for mspaint, may use this post as a tester if that is ok?
LINK | DESCRIBE | PAINT |
1 | Edser | nothing |
2 | Wichita Lineman | Leg End Reject |
3 | Trigger | aaronjennings |
4 | cee_jay | [open] |
5 | HildaSilvioOgden | [open] |
later | [open] | *Homer J. Fong* (aft 14th) |
Oh sheesh Trigs (I forgot about preview) ...Thanks! it worked, thanks!!!
(How did you get the colours in the header line, Neo?)
first line, replace table data for table header, that is (td)data(/td) (th)blue header(/th) k, so lets see if i can mess up your clear instructions, (cos its my special skill)
I change the first line from...
(table)(tr)(td)LINK(/td)(td)DESCRIBE(/td)(td)PAINT(/td)(/tr)
to... emm - this?
(table)(tr)(th)LINK(/th)(th)DESCRIBE(/th)(th)PAINT(/th)(/tr)
Let's see how dis works...
LINK | DESCRIBE | PAINT |
1 | Edser | nothing |
2 | Wichita Lineman | Leg End Reject |
3 | Trigger | aaronjennings |
4 | cee_jay | [open] |
5 | HildaSilvioOgden | [open] |
later | [open] | *Homer J. Fong* (aft 14th) |
>WOOHOO< it worked (amazeballs!) Thanks Neo, appreciate it!
...and Trigs, the preview post is VERY helpful! Thank you!
RE: Everything re: Tables and this forum. - Neowise - 04-10-2021
(04-10-2021, 10:50 PM)DejaBoo Wrote: (04-10-2021, 09:23 PM)Neowise Wrote: first line, replace table data for table header, that is (td)data(/td) (th)blue header(/th) k, so lets see if i can mess up your clear instructions, (cos its my special skill)
I change the first line from...
(table)(tr)(td)LINK(/td)(td)DESCRIBE(/td)(td)PAINT(/td)(/tr)
to... emm - this?
(table)(tr)(th)LINK(/th)(th)DESCRIBE(/th)(th)PAINT(/th)(/tr)
Let's see how dis works...
LINK | DESCRIBE | PAINT |
1 | Edser | nothing |
2 | Wichita Lineman | Leg End Reject |
3 | Trigger | aaronjennings |
4 | cee_jay | [open] |
5 | HildaSilvioOgden | [open] |
later | [open] | *Homer J. Fong* (aft 14th) |
>WOOHOO< it worked (amazeballs!) Thanks Neo, appreciate it!
...and Trigs, the preview post is VERY helpful! Thank you!
also, if you want smaller table, you can do table=50 for a 50% screen size table,
or like i done to your table, 30%
RE: Everything re: Tables and this forum. - DejaBoo - 04-10-2021
(04-10-2021, 11:37 PM)Neowise Wrote: (04-10-2021, 10:50 PM)DejaBoo Wrote: k, so lets see if i can mess up your clear instructions, (cos its my special skill)
I change the first line from...
(table)(tr)(td)LINK(/td)(td)DESCRIBE(/td)(td)PAINT(/td)(/tr)
to... emm - this?
(table)(tr)(th)LINK(/th)(th)DESCRIBE(/th)(th)PAINT(/th)(/tr)
Let's see how dis works...
LINK | DESCRIBE | PAINT |
1 | Edser | nothing |
2 | Wichita Lineman | Leg End Reject |
3 | Trigger | aaronjennings |
4 | cee_jay | [open] |
5 | HildaSilvioOgden | [open] |
later | [open] | *Homer J. Fong* (aft 14th) |
>WOOHOO< it worked (amazeballs!) Thanks Neo, appreciate it!
...and Trigs, the preview post is VERY helpful! Thank you!
also, if you want smaller table, you can do table=50 for a 50% screen size table,
or like i done to your table, 30%  I do like the smaller size better thank you greatly for the info and demo, Neo!
RE: Everything re: Tables and this forum. - jp liz v1 - 01-01-2022
How to spoiler tag please
RE: Everything re: Tables and this forum. - Neowise - 01-01-2022
(01-01-2022, 08:16 PM)jp liz v1 Wrote: How to spoiler tag please
a spoilerShow Content
either use the spoiler tag button
![[Image: nbV9m5l.png]](https://i.imgur.com/nbV9m5l.png)
this is in spoiler
SpoilerShow Content
or type [ spoiler ] spoiler stuff [ /spoiler ]
|