Replace copy/paste bullets with TW Style?

[Stobot]

As I work in a corporate Microsoft/Windows environment, I'm very commonly copying in bulleted list email content like this:

Blah blah blah:

• Yada yada yada
• Yada yada yada
• Blah blah blah
• More stuff
• Even more stuff

I'm wondering if anyone has something light built to just replace the text characters that are used during copy/paste into TiddlyWiki into the corresponding 

Blah blah blah:

* Yada yada yada

** Yada yada yada

** Blah blah blah

* More Stuff

* Even more stuff

I've seen some (and use) some copy/paste tables from Excel and return the |TiddlyWiki|Style|Tables but nothing for the bullet characters.

Anyone have something they can point me to?

[TonyM]

Stobt,

Hopefully someone will point out prior work one this. However

This would be very helpful but it may be more meaning full to provide information on the current result of such copy and paste actions, what is appearing after pasting bullets from word, excel, html pages, text only pastes etc... such that we can see what needs to change. This would help us identify the actions required, and see if any existing tools can help if not solve your problem.

Example Copy iconised buttet list from https://inkscape.org/en/

(1) Pastes here 

• Flexible drawing tools
• Broad file format compatibility
• Powerful text tool
• Bezier and spiro curves

(2) A text editor and tiddlywiki edit mode receives

    Flexible drawing tools

    Broad file format compatibility

    Powerful text tool

    Bezier and spiro curves

But dragging the content and dropping it on a TiddlyWiki, and importing

Displays as in case (1)

The content of the imported tiddler is HTML

<ul class="ticks">

<li>Flexible drawing tools</li>

<li>Broad file format compatibility</li>

<li>Powerful text tool</li>

<li>Bezier and spiro curves</li>

</ul>

This is a reasonable working alternative?

If you then defined ticks, wa la

Regards

Tony

[Stobot]

Thanks TonyM,

Unfortunately either copy/pasting or dragging/dropping doesn't give me the HTML (don't know that's what most Office programs use). Below is a more detailed example with the "after"

Example content from Outlook

This is a list

• Point 1
• Point 2
• 2a
• 2b
• 2ai
• 2aii
• 2c
• Point 3

Copy/Pasted into TiddlyWiki returns:

• Point 1

• Point 2

o 2a

o 2b

 2ai

 2aii

o 2c

• Point 3

The character codes appear to be:

First: 0149 followed by 0032

Second: 0111 followed by 0032

Third: 0063 followed by 0032

So I believe this should be easy with some kind of find/replace plugin. Multiple times per day right now I manually go in and hand-replace the dot with *, open dot with **, square dot with *** etc.

I finally found the "CSV to Table" copy/paste thing I was referring to was http://tobibeer.github.io/tb5/#convertable. I use this all the time to copy/paste ranges from Excel into my wiki. I imagine it essentially does find/replace based on tab characters or something replacing with pipes. 

Does that help explain it better? Sometimes I feel like I'm one of the only people here in a traditional old-fashioned corporate environment running Microsoft tools, but I appreciate the help! 

[TonyM]

Stobot,

Opps, I assumed your copy and paste was coming from websites etc.. in the browser. I am a big user of Office but I not longer get much of my incoming data from office documents, So I have not played with this too much. I will look into it and post any leanings.

Perhaps http://skplugins.tiddlyspot.com/#FindReplace would help.

I have a lot of office and office 365 cloud experience and keen to resolve this for future clients as well.

Here are some possible tips

• Copy and past content as plain text then use Editor tool bars to add back bullets and formatting
• .http://skplugins.tiddlyspot.com has quite a few editor tool bar enhancements
• Paste into an advanced text editor and manipulate before pasting into TiddlyWIki eg; notepad ++
• Save/Export an office document as html and copy from there (but tricky at moment)

Sadly recent changes to FireFox have made a number of my preferred addons go the way of the Dodo, so I need to revisit this subject.

Regards

Tony

[Stobot]

Thanks Tony - I'll check out the link. Looks promising.