RECORDING PAST ACTIONS

[potamito]

3,1 will return 1 character from the 3rd position

means the last action is at the most left position of the string, so second to last is the one next to it.

It reads from left to right ok so assuming I have all the actions labeled using 2 characters and also taking into account i can either use the "," or just leave it black it will either way count as a character if i wanted to isolate the last 10 actions individually the last portion of the expression will go like...

10th - 01, 02) (last action)
9th - 03, 02)
8th - 05,02)
.
.
.
.
1st - 19, 02)

Did i get it right?

[BillGatesIII]

If you do not use a separator character you got it right, else it would be:

Last action: 01, 02)
Second to last: 04, 02)
etc.

[potamito]

Yeah I'm using a separator or a character as a separator but I'm not getting the proper results, just ceros but when comparing it with the "Last 10 Actions" expression it does display results so there must be something wrong with what I'm doing.

Assuming the next action string where "OR" is the last action was taken (most recent) and "LF" was the 10th action taken moving backward so...

OR,OF,OL,R4,RC,RF,3B,3F,34,LF,

10th - 01, 02) (last action) - So it would be OR right?
9th - 04, 02) - For OF
8th - 07,02) - For OL
.
.
.
2nd - 25, 02) - For 34
1st - 28, 02) - For LF

[potamito]

got it to work, i had the expression net to number, thanks¡!

[BillGatesIII]

Good to hear

By the way, there is also a substr(string, from, length) function that can be used in a stat expression. So you don't need to create ten different columns for what you want to achieve.

[tommyborstal]

thanks to all who followed up on this thread.

i now have things nearly the way i want them.

cheers