It’s because you’ve assumed the “convert” was in NPP, but really it’s in WordPress.

When you copy a selection from Excel and paste into a textual context, every line ends with a newline character (so if you only select one column, every CELL ends with a newline character), and multiple columns are separated by TABs. When you paste that text into WordPress, it appears to be converting the newline into a <br />. But when you paste it into NPP, it just interprets it as an end-of-line.

I don’t have WordPress convenient right now, but my next debugging steps would be:

What happens if you paste into NPP, then re-copy from NPP and paste into WordPress? What happens if you paste into NPP, then use column-select (alt+drag selection), copy, then paste into WordPress?

Search > Replace dialog

Find what : ^\R Replace with : (empty) Search Mode : ☑ Regular Expression Hit Replace All

@Scott-Sumner

You are right, if multiple panels are in one group it is different, also freeing the panel
doesn’t work if you click on windows title instead one needs to double click the tab field.

And it seems behaving awkward, to be honest - at least on linux it draws only half
of the panel first and then once updated the rest. (??)

Cheers
Claudia

The problem was solved once I showed the file extensions in Windows. Not sure how that fixed it but it now is saving the modified file with the .csv ext instead of defaulting to .txt which happened before even when selected All Files .. Thank you!

Thanks Meta Chuch.
It works. The name of version I’d dowloaded has the suffix x64, but obviously it wasn’t the right file.

Apply the shortcut you want to the feature you want. Then go to the conflicting function, and either change or delete its shortcut.

@Sagor

sorry, afaik there is no such setting available.

Cheers
Claudia

Ah, yes, forgot all about the Search/Replace on whole folders. I might be able to automate things a bit more through autohotkey.

Thanks for the suggestions! I’ll fiddle with that until I can get where I want with Python (and come back if I manage something elegant enough to be shared).

Have a nice week-end!

thank you. i am new and did not know that existed

Oh, that’s a good idea. I didn’t know these gists existed. I guess I will post my code in these things instead, then link remains the same, but code changes :)

Never mind! It’s WORD. The problem is that section of the style area is so complicated that it took a while to load, and I was being impatient clicking one after the other (with no indicator that anything was loading as I clicked), so I assumed WORD had the same settings as the last thing I clicked.

@Mutahar-Jy

Pointed you to the answer in the nearly identical thread you started…

Hi, @barishamil, @scott-sumner and All,

Yes, Scott ! Sorry , for forgetting that obvious and nice solution, which, in addition, allows you to set a user shortcut for any specific macro ;-))

Cheers,

guy038

@Gogo-Neatza said:

Use Notepad++ with the RegEx Helper plugin

A downside there is that the RegEx Helper has to be manually activated upon every run of Notepad++, and that regex entered into its UI again. At least that my understanding of that plugin.

Seems like the OP would like something more “automatic”.

@Rocky-Marquiss

yes - that’s what I assumed as well.

Cheers
Claudia

Hello, @frank-kirschner, @claudia-frank, @scott-sumner and All,

I thought about a third regex which, in addition, looks if :

The END:VCALENDAR string is preceded by a line-break

The BEGIN:VCALENDAR string is followed by a line-break

and, in replacement, this regex S/R adds a line-break, if not initially present, in O.P.'s text

So, assuming the four possible cases, below :

blah blah bla bla blaEND:VCALENDAR 3F68636A-A88D-4B6D-95C7-DC5B65910335.ics ZÔúƒ4504b552cef6ac7c1141ef12fba9a94a ²VEVENT ZÚ p ZÚˆ3F68636A-A88D-4B6D-95C7-DC5B65910335€ $ (È„ P€ „ Í`õ
¢
BEGIN:VCALENDARblah blah blah bla bla... blah blah bla bla blaEND:VCALENDAR 3F68636A-A88D-4B6D-95C7-DC5B65910335.ics ZÔúƒ4504b552cef6ac7c1141ef12fba9a94a ²VEVENT ZÚ p ZÚˆ3F68636A-A88D-4B6D-95C7-DC5B65910335€ $ (È„ P€ „ Í`õ
¢
BEGIN:VCALENDAR blah blah blah... bla bla... blah blah bla bla bla END:VCALENDAR 3F68636A-A88D-4B6D-95C7-DC5B65910335.ics ZÔúƒ4504b552cef6ac7c1141ef12fba9a94a ²VEVENT ZÚ p ZÚˆ3F68636A-A88D-4B6D-95C7-DC5B65910335€ $ (È„ P€ „ Í`õ
¢
BEGIN:VCALENDARblah blah blah bla bla... blah blah bla bla bla END:VCALENDAR 3F68636A-A88D-4B6D-95C7-DC5B65910335.ics ZÔúƒ4504b552cef6ac7c1141ef12fba9a94a ²VEVENT ZÚ p ZÚˆ3F68636A-A88D-4B6D-95C7-DC5B65910335€ $ (È„ P€ „ Í`õ
¢
BEGIN:VCALENDAR blah blah blah bla bla...

then the regex S/R :

SEARCH (?s-i)((\R)?END:VCALENDAR).*?(BEGIN:VCALENDAR(\R)?)

REPLACE (?2:\r\n)\1\r\n\3(?4:\r\n)

would gives the following text ( four identical blocks of text ) :

blah blah bla bla bla END:VCALENDAR BEGIN:VCALENDAR blah blah blah bla bla... blah blah bla bla bla END:VCALENDAR BEGIN:VCALENDAR blah blah blah... bla bla... blah blah bla bla bla END:VCALENDAR BEGIN:VCALENDAR blah blah blah bla bla... blah blah bla bla bla END:VCALENDAR BEGIN:VCALENDAR blah blah blah bla bla...

Et voilà !

Notes :

You may, either, click several times on the Replace button or once, only, on the Replace All button

In search :

First the (?s-i) modifiers forces :

The search to be performed in a sensitive way ( NON-insensitive ! )

The special dot character . to be considered as any single character, even an End of Line one

Then group 1 contains the string END:VCALENDAR, possibly preceded with a line-break

The part (\R)? ( identical to the form (\R){0,1} ) represents an optional line-break ( group 2 )

Now, the .*? part ( identical to .{0,}? ) stands for the smallest range of any character, between the two strings END:VCALENDAR and BEGIN:VCALENDAR

The group 3 contains the string BEGIN:VCALENDAR, possibly followed with a line-break

Finally, the part (\R)? ( identical to the form (\R){0,1} ) represents an optional line-break ( group 4 )

In replacement :

The conditional replacement feature (?2:\r\n), rewrites a line-break, only if group 2 ( \R ) does not exist, before the string END:VCALENDAR

The block \2\r\n\3 adds the strings END:VCALENDAR and BEGIN:VCALENDAR, separated with a line-break ( \r\n )

The conditional replacement feature (?4:\r\n), rewrites a line-break, only if group 4 ( \R ) does not exist, after the string BEGIN:VCALENDAR

Cheers,

guy038