Page 1 of 1
How to quickly reverse the order of numbers in a text editor?
Posted: Sun Jun 16, 2019 5:08 pm
by Debugger
How to quickly reverse the order of numbers in a text editor?
Example:
22,34,50,15,27,74,29,25,77,6,54,40,38,73,9,67,57,70,58,60
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Sun Jun 16, 2019 8:07 pm
by therube
(Without trying) I'd think something along the lines of,
Reverse order of dot-delimited elements in a string, would do it.
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Mon Jun 17, 2019 8:20 am
by Debugger
This is Unix, I need for Windows, and certainly not commands and scripts, because it also takes time, identical to how I would manually change the order of numbers.
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Tue Jun 25, 2019 8:12 am
by Debugger
But all these scripts.... or online tools, of which there are hundreds, innumerable. But every one such app reverses numbers.
Probably it is not about "reverse" but about "inverse".
Reverse String Script - wrong
Inverse Order / Inverse Sequence - ???
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Tue Jun 25, 2019 3:07 pm
by vsub
There is probably a better way with RegEx but I am not good with it
Autohotkey
I place those numbers in the clipboard when I run the script and then sort them
Code: Select all
Clipboard = 22,34,50,15,27,74,29,25,77,6,54,40,38,73,9,67,57,70,58,60
Loop,Parse,Clipboard,`,
List .= A_Index "|" A_LoopField "`n"
Sort,List,N R
Loop,Parse,List,`n
{
If A_LoopField =
{
Sorted := SubStr(Sorted,1,-1)
Break
}
Sorted .= SubStr(A_LoopField,InStr(A_LoopField,"|",,1,1)+1) ","
}
MsgBox,% Sorted
Clipboard := Sorted
exitapp
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Tue Jun 25, 2019 5:55 pm
by Debugger
In this case, I would have to modify the script each time, adding numbers to the lines. And it would not be possible to just paste the numbers in the window, at any time and at any time, any numbers and click: run?
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Tue Jun 25, 2019 6:05 pm
by therube
and then sort them
Should it be sorted or reversed?
22,34,50,15,27,74,29,25,77,6,54,40,38,73,9,67,57,70,58,60
60,58,70,57,67,9,73,38,40,54,6,77,25,29,74,27,15,50,34,22
(The missing post was a spammer.)
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Tue Jun 25, 2019 7:27 pm
by vsub
By "and then sort them" I mean,it reverses the order...last is first
Debugger you don't need to edit the code every time,this was just an example
1.Remove the first line
2.Copy the numbers in your text editor and then run the scrips
There are man ways to make it work,I just don't know what you want to do with the values after you rearrange them
For example with this if you copy the values and then Press Shift+F1(the hotkey can be different),the script will rearrange the values and replace them
Code: Select all
+F1::
Keywait,Shift
Send,^c
ClipWait,1
Loop,Parse,Clipboard,`,
List .= A_Index "|" A_LoopField "`n"
Sort,List,N R
Loop,Parse,List,`n
{
If A_LoopField =
{
Sorted := SubStr(Sorted,1,-1)
Break
}
Sorted .= SubStr(A_LoopField,InStr(A_LoopField,"|",,1,1)+1) ","
}
Clipboard := Sorted
Send,^v
List =
Sorted =
Return
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Thu Jun 27, 2019 4:47 pm
by Debugger
You are not serious, you give some code, and you think that the other person will understand how to use it. Master, give me some corrections. Do something.
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Thu Jun 27, 2019 5:40 pm
by vsub
I am serious but you have to follow the thread
After I posted my first example,you said
In this case, I would have to modify the script each time, adding numbers to the lines. And it would not be possible to just paste the numbers in the window, at any time and at any time, any numbers and click: run?
And then I reply to that with what you have to do to be able to make the code work the way you want.
Debugger you don't need to edit the code every time,this was just an example
1.Remove the first line
2.Copy the numbers in your text editor and then run the scrips
Then I posted another code that allows you to execute that reordering and automatically replace the selected
If you want directions
First code:
1.Remove the file line and save the file
2.Select your numbers
3.Run the script
4.When the message box appear and when you hit ok,the rearranged digits will be placed into the clipboard which you can paste wherever you want
Second code:
1.Run the script(this example don't need the script to be started every time,when you start this once,it will always run and wait for you to press Shift+F1
2.Select your digits
3.Without deselecting them(clicking somewhere else),press Shift+F1 and release the buttons to run the code which will rearrange them and replace what you have selected
There are a lot of other ways to make it easier to run the script
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Fri Jun 28, 2019 11:19 am
by therube
reverse.bat:
Code: Select all
@echo off
sed -e "s/,/\r\n/g" | tac | sed -e "s/\r//" | paste -sd,
file.txt:
gvim file.txt
!!reverse.bat
results:
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Fri Jun 28, 2019 11:25 am
by therube
You'll need the Unix-like utilities.
(If you're using Win10, they may be there already?)
sed changes 1,2,3,4 to:
1
2
3
4
tac reverses those lines:
4
3
2
1
sed removes the <cr>
(may only be needed because of DOS using \r\n kind of thing?
paste
(joins things together using , as a separator)
For whatever reason, from a command prompt the output ends up like:
Code: Select all
4 ,3,2,1
called from within gvim you get:
4,3,2,1
Similarly you could do something like:
Code: Select all
reverse.bat < file.txt
or
reverse.bat < file.txt > file_reversed.txt
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Fri Jun 28, 2019 2:07 pm
by vsub
@therube I am not sure how to test this but is this actually working when the values are random,not sequential like 1,2,3,4
When they are ordered from smaller\bigger to bigger\smaller number,then there are plenty of ways to do it
Can your example reverse the order like my script and when the values are separated by coma,not new line?
22,34,50,15,27,74,29,25,77,6,54,40,38,73,9,67,57,70,58,60
to
60,58,70,57,67,9,73,38,40,54,6,77,25,29,74,27,15,50,34,22
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Fri Jun 28, 2019 4:09 pm
by therube
Yes, working.
Code: Select all
C:\TMP\>cat file
22,34,50,15,27,74,29,25,77,6,54,40,38,73,9,67,57,70,58,60
C:\TMP\>reverse.bat < file > file.out
C:\TMP\>cat file.out
60,58,70,57,67,9,73,38,40,54,6,77,25,29,74,27,15,50,34,22
C:\TMP\>
(I forgot an @echo off in the above batch file, since edited.)
Can your example reverse the order like my script and when the values are separated by coma,not new line?
The source file (aka "file", in my example) is just as you show, a single line separated by commas.
I split the file at the commas, into separate lines, only because it makes it easier to parse (to reverse the order - that's what the tac command does -- tac is the reverse of cat, BTW).
After things are reversed, I then recombine them from individual "lines" back into a single line, separated by commas.
(All this is done in a stream.)
So long as your editor can make a system call... In Vim !!reverse.bat does that (for the current line, the line you want reversed).
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Fri Jun 28, 2019 4:30 pm
by therube
Code: Select all
C:\TMP\>cat > cat
red,cat,blue,cat,one,cat,two,cat
^Z
C:\TMP\>cat cat
red,cat,blue,cat,one,cat,two,cat
C:\TMP\>reverse < cat > cat.out
C:\TMP\>cat cat.out
cat,two,cat,one,cat,blue,cat,edr
C:\TMP\>
Look at "edr"!
I have no idea how or why that happened?
(I'm on XP currently. Was on Win7 earlier. And see differences between the two.)
cat is like type.
epyt, if it existed, would be like tac
.
Re: How to quickly reverse the order of numbers in a text editor?
Posted: Sat Jun 29, 2019 6:42 am
by Debugger
I know how to turn on and run a script in PSPad 32-bit 5, but I am looking for information on how to do it in EmEditor 64-bit 18.9.10?