Tidy Clipboard Text to Remove Blank Lines inc Space and Tabs

Questions and Help
1

Hello again. One of my team has this specific use case that I can't quite work out. It's hopefully the final script we need migrate from AutoHotkey.

Basically we want to take the contents of the Clipboard and clean it up.

Here is link to an example text file that can be used test this.

Example.TXT

As you can see from this screenshot of the above file, that there are some spaces, tabs etc in the file.

Screenshot_20230122_085336
Screenshot_20230122_085336850×423 9.14 KB

Now what should happen is this

All Multiple Blank lines should be removed. A blank line may have just a space , or a tab, or just a line break or carriage return character. A single blank line should not be modified.

So this clipboard text

Screenshot_20230122_083917
Screenshot_20230122_083917966×459 28.6 KB

Should end up looking like this.

Screenshot_20230122_084050
Screenshot_20230122_084050966×459 28.2 KB

Many thanks in advance for the help as always.

2

Hi @AndyPage ,
Does something like this works?

{text="Ep 1607: What Doesn’t Kill Us (Available to stream Thursday, January 19)

With the fate of the Sicarius investigation hanging in the balance, the BAU takes a case in West Virginia, where an UnSub practices his own twisted form of Old Testament vengeance.





Written by: Sullivan Fitzgerald
Directed by: Aisha Tyler



dd

d


Last Line
"}{=text}
#############
{=replaceregex(text, "(\n\s)\s{1,}", "$1", "sg")}

1 Like
3

Wow, that's works brilliantly. Thank you so much.

1 Like