AutoHotkey Community

[rockit0]

This is my var:

Date,Open,High,Low,Adj Close,Volume
2008-03-20,23.03,23.65,22.92,23.00,3155500
2008-03-19,24.94,25.16,23.70,23.70,1788600
2008-03-18,24.42,25.30,24.03,24.90,1893100
2008-03-14,26.85,26.93,24.60,25.46,1751900
2008-03-13,26.55,26.92,26.00,26.30,1620600
2008-03-12,27.50,27.75,26.51,27.19,2040400
2008-03-11,26.60,27.38,26.31,27.35,2645600
...

Every line has 6 information separated by ,
the NeedleRegEx looks like (.*),(.*),(.*),(.*),(.*),(.*) for each line

How can i set up my var to looks like:
$1,$2,$3,$5,$4

ex:
2008-03-11,26.60,27.38,26.31,27.35,2645600
will be:
2008-03-11,26.60,27.38,27.35,26.31

Thank's for help

[evan]

read whole line as a variable
then string split the , as:
var1=2008-03-11,
var2=26.60,
var3=27.38,
var4=26.31,
var5=27.35,
var6=2645600
replace the , to space
the append the line as %var1%,....%var5%,%var4%
loop another line...continue...

[Tuncay]

@evan
Loops and StringSplits are good practice and a some easier understand from many beginners. But calling it with one RegExReplace function is drastically faster. But regular expressions are often a bit tricky.

@rockit0
Here is my solution:

If I have understand it correctly, you want to ...:

1. ... Cut out the sixth element of every line
   
2. ... and swap element 5 with every element 4 of every line.

Script:

[evan]

i have no clue how to use that syntax @@
the lines i usually use is around 10-50(max)
its not going to take more than 0.1 second to finish the job with replace, split etc

but i am interested in learning something better
RegExMatch sounds a good thing to learn in order to speed up my memory reading/writing

[rockit0]

EXCELENT

Thank's