[spiros]

I will try to simply recreate what was done in the video.

Lets suppose you have two texts.

text 1 is this

So you mean the user should expect one behaviour from paste text
pushing content below further down) and a different one from
paste text from multi selection (mixing pasted text with content
already below on a line by line basis)? It does not make sense

And further down you have text 2

1
2
3
4
5

If you copy the whole text 1 and you paste before line one in text 2, text 2 will be pushed down, ie not affected in any sense. Ok so far?

Now, try multiple selection and select all the bits from text 1 in bold. Now paste before line one in text 2. The behaviour is completely different as text strings copied from text 1 are merged with text bits in text 2!

The expected behaviour is exactly the same as with simple paste, ie text 2 being moved down without being affected whatsoever.

Is it clearer now?

[spiros]

So you mean the user should expect one behaviour from paste text (pushing content below further down) and a different one from paste text from multi selection (mixing pasted text with content already below on a line by line basis)? It does not make sense to me, nor I find it practical. Have you seen such an implementation of paste after multiple selection in any other tool? MS Word pushes other text down, Notepad++ outputs all in one line without affecting text below.

[spiros]

Sorry, it was an autodelete link (after a week or so), I uploaded again: https://ibb.co/Gs4GmTs

[spiros]

Just wondering, have you seen this?

[spiros]

You can drag and drop selected cells if you drag the border of the selection.

Wow, cool, I did not know you could do that. However, when dropping cell to another cell, it overwrites it (no option to move down, etc).

But I guess your macro should do what I described.

[spiros]

Yes, of course. I thought it would be a good suggestion to have as a standard command.

For example, Notepad++ has in Edit > Blank operations > Trim leading and trailing spaces and “Remove unnecessary blank and end of line”

[spiros]

Thanks, but if I am not wrong, these simply insert lines after or before text in standard mode (not tsv). What I describe is manipulating cell positions and adjusting the surrounding cells according to the options above, I.e. Shift cells right and Shift cells down. For example if in the following table I shift down “b”

1 – 2 – a
3 – 4 – b
5 – 6 – c
7 – 8 – d

The result will be:

1 – 2 – a
3 – 4 –
5 – 6 – b
7 – 8 – c
—- —- d

You can see what I mean by checking the relevant commands on Excel (right click on cell, select Insert).

[spiros]

Ah, sorry, I did not understand how they would be entered. Yes, they are entered when selected!

I found an easier way though to automate. Use multiple selection, copy, paste, select pasted text and run a macro that replaces commas and line breaks with pipe.
I was not sure how to trim spaces left and right of pipe so I added some extra lines for that. I was not sure either if a macro could paste directly like this after multiple selection and copy (I tried using your macro with paste after multiple copy, but it did not add the delimiter.).

document.selection.Replace(", ","|",eeFindReplaceSelOnly | eeReplaceAll,0);
document.selection.Replace(" |","|",eeFindReplaceSelOnly | eeReplaceAll,0);
document.selection.Replace("| ","|",eeFindReplaceSelOnly | eeReplaceAll,0);
document.selection.Replace("\\n","|",eeReplaceSelOnly | eeReplaceAll | eeFindReplaceRegExp,0);

[spiros]

Yes, understood. But running the macro does not paste the text. It only produces the pop-up in the image.

[spiros]

Right clicking in the macros list does nothing for me. Please see image

https://ibb.co/vvqkxzp

[spiros]

Please see here
https://ibb.co/YB7nhHX

[spiros]

Also, the paste options box (Show clipboard History on Paste), could also have the options “Paste all” (with associated hotkey), “Delete all” and in “Customize” an option could be added so that the user can set the delimiter for “Paste all”. Currently, it only has “Select all” which can be useful only if one wants to delete all (requiring 2 steps to delete).

[spiros]

Wow, interesting!
I copied multiple items, then ran the macro, but it just displayed a pop-up with each item separated by line break.
Maybe it would be easier to have a delimiter setting for the paste of multiple selection items? I can imagine many people could find that useful since they could use the delimiter of their choice to match their situation.

[spiros]

For example, issues that may arise is conflicting encodings and encoding declarations between various .dic and .aff files.
I.e. in Greek files I see Windows-1253 and in en_US.aff I see Western European and at the beginning of the file I see:

SET ISO8859-1

Creating versions of the files in UTF-8 did not work (suggestions were question mark symbols).

[spiros]

Thanks! I had tried combining them in the past but it did not work. As far as UserDic.bin is concerned you mean append both .aff and .dic files?

[spiros]

Thank you so much! There was no way I could figure out by myself that something like that was possible!

[spiros]

Interesting, the same behaviour with Notepad++. Not though with MS Word, or LibreOffice Writer.

The point is that the first the last line are not wholly selected, but partly selected. The behaviour I would expect is the behaviour one gets now by pressing 1) DEL 2) TAB.

[spiros]

Got it. Yes, now it does not have these issues. However, one has to adapt the file from the 4 column format (.tsv used in batch import) to a 2 column format and then select with right click on the linked file whether Match whole word or/and Mach case apply.

Thank you!

[spiros]

1. Yes, I did it, no more errors.

Test text:

εσσα, εν, poet. for [[κυκλικός]], <span class="sense"><span class="bld">A</span> [[circular]], ἀγορᾶς θρόνος <span class="bibl">S.<span class="title">OT</span>161</span> (lyr.); ἴτυς <span class="title">AP</span>7.232 (Antip.).</span>

[spiros]

Thank you so much!

I get an error
https://ibb.co/JjQfq7C
https://ibb.co/zZ6sBJd

When I click, it indicates the line of the document (8) where I added the code.

document.selection.StartOfDocument(false);
document.selection.Replace("(<span class=\x22bld\x22>)(.*?)(</span>)","<{\\2}>",eeReplaceAll | eeFindReplaceRegExp,0);
document.selection.Replace("</?\\w+((\\s+\\w+(\\s*=\\s*(?:\x22.*?\x22|\x27.*?\x27|[\\^\x27\x22>\\s]+))?)+\\s*|\\s*)/?>","",eeReplaceAll | eeFindReplaceRegExp,0);
document.selection.Replace("<{","<br><span class=\x22bld\x22>",eeReplaceAll,0);
document.selection.Replace("}>","</span>",eeReplaceAll,0);
document.selection.Replace("Definition=<br>","Definition=",eeReplaceAll,0);
document.selection.Replace(" <br>","<br>",eeReplaceAll,0);
if( document.selection.Find( "<span class=\"bld\">", eeFindAround | eeFindCount ) <= 1 ) {
	document.selection.Replace( "<br><span class=\"bld\">A</span>", " ", eeReplaceAll );
}
document.selection.SelectAll();
document.selection.Copy(eeCopyUnicode);
editor.ExecuteCommandByID(4120);

[spiros]

Yes, sorry about the macro, my error, I used forward slash instead. The point is whether it makes sense for the replacement of [\google] to become [google] in standard regex and requiring [\\google] in order to replace as expected.

[spiros]

Thank you for the reply! I can do it already using regex (or the Excel plugin I linked to which I would encourage you to install and test it, it could give you further ideas). My point was with a focus of improving this great piece of software.
I can see right next to it in Pivot Table there is a number of settings. And it is strange to have a full icon for just a simple (and rare) action without any settings.

The simple functionality could be maintained without causing confusion in the user. For example, he would have to select a full column for the options to appear.

[spiros]

Correction: The example is for transpose per 2 rows

[spiros]

Well, it is pretty much a standard Turkish letter :)

The Turkish alphabet (Turkish: Türk alfabesi) is a Latin-script alphabet used for writing the Turkish language, consisting of 29 letters, seven of which (Ç, Ğ, I, İ, Ö, Ş and Ü) have been modified from their Latin originals
https://en.wikipedia.org/wiki/Turkish_alphabet

[spiros]

I get an error “A critical error occurred while operating the file”. I can confirm there is enough space in temp folder.

[Author]

Posts