Login

***Neowise*** · (This post was last modified: 12-08-2021, 10:13 PM by Neowise.)

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]

***Neowise*** · 02-08-2021, 10:28 PM

comments and improvements and alternatives welcome

***Neowise*** · (This post was last modified: 12-08-2021, 10:15 PM by Neowise.)

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="&#x000D;" />

            <Action type="1" message="2170" wParam="0" lParam="0" sParam="&#x000A;" />

            <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="&#x000D;" />

            <Action type="1" message="2170" wParam="0" lParam="0" sParam="&#x000A;" />

            <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="&#x000D;" />

            <Action type="1" message="2170" wParam="0" lParam="0" sParam="&#x000A;" />

        </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 Big Grin

nothing · 12-08-2021, 08:08 PM

I've been using this site for my MSPaint tables

https://www.teamopolis.com/tools/bbcode-...rator.aspx

***Neowise*** · (This post was last modified: 19-08-2021, 11:17 PM by Neowise.)

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

***Necro*** · (This post was last modified: 19-08-2021, 08:06 PM by Necro.)

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

***Neowise*** · 19-08-2021, 11:18 PM

(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.

***Neowise*** · 07-09-2021, 03:08 PM

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

DejaBoo · (This post was last modified: 04-10-2021, 07:03 PM by DejaBoo.)

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?)

***Trigger*** · (This post was last modified: 04-10-2021, 06:22 PM by Trigger.)

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

***Neowise*** · 04-10-2021, 09:23 PM

(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)

***Neowise*** · 04-10-2021, 09:24 PM

(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 Big Grin

DejaBoo · 04-10-2021, 10:50 PM

(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 Big Grin

(amazeballs!) Thanks Neo, appreciate it!
...and Trigs, the preview post is VERY helpful! Big Grin

Thank you!

***Neowise*** · 04-10-2021, 11:37 PM

(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% Big Grin

DejaBoo · 04-10-2021, 11:43 PM

(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 Smile

thank you greatly for the info and demo, Neo!

01-01-2022, 08:16 PM

How to spoiler tag please

***Neowise*** · 01-01-2022, 09:16 PM

(01-01-2022, 08:16 PM)jp liz v1 Wrote: How to spoiler tag please

a spoilerShow Content

SpoilerShow Content

Login
Username:
Password:	Lost Password?
	Remember me