R 4
U 4
L 3
D 1
R 4
D 1
L 5
R 2
Direction = Left([Data], FindString([Data], " "))
Steps = ToNumber(SubString([Da...
Step
Int32
4
1
[Step] <= [Steps]
[Step] + 1
X
New Field
Int32
4
Empty
IF [Direction] IN ("U", "D")
THEN [Row-1:X]
ELSEIF [Direction] = "L"
THEN [Row-1:X] - 1
ELSE [Row-1:X] + 1
ENDIF
IF [Direction] IN ("U", "D")
THEN [Row-1:X]
ELSEIF [Direction...
Y
New Field
Int32
4
Empty
IF [Direction] IN ("L", "R")
THEN [Row-1:Y]
ELSEIF [Direction] = "D"
THEN [Row-1:Y] - 1
ELSE [Row-1:Y] + 1
ENDIF
IF [Direction] IN ("L", "R")
THEN [Row-1:Y]
ELSEIF [Direction...
Tail_Coordinates
New Field
Int32
4
Nearest
IF ABS([X] - ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")))) > 1 OR ABS([Y] - ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1))) > 1
THEN IF [X] = ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")))
THEN IF [Y] > ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1))
THEN Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1)) - 1)
ENDIF
ELSEIF [Y] = ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1))
THEN IF [X] > ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ","))) + 1) + SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ","))) - 1) + SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ","))
ENDIF
ELSEIF [X] > ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")))
THEN IF [Y] > ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1)) - 1)
ENDIF
ELSEIF [X] < ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")))
THEN IF [Y] > ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates], FindString([Row-1:Tail_Coordinates], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates]
ENDIF
IF ABS([X] - ToNumber(Left([Row-1:Tail_Coordinates], FindStri...
L 2
D 2
R 2
U 1
L 1
U 1
R 1
U 2
R 2
U 2
L 2
R 2
U 2
L 2
U 1
R 1
U 1
R 2
U 1
D 2
U 2
L 2
R 1
U 2
R 2
U 2
L 1
D 1
L 1
R 2
L 2
D 1
L 1
R 2
U 2
L 1
U 1
L 2
R 1
L 1
D 2
U 2
L 2
D 1
R 2
D 1
U 2
D 2
L 2
D 1
L 1
R 1
D 2
U 2
L 2
U 1
L 1
U 2
R 2
D 1
U 2
R 2
U 1
L 2
R 2
D 2
U 2
D 2
L 2
D 1
U 2
L 1
R 1
L 1
D 2
U 1
D 1
L 2
D 1
L 1
R 1
U 1
L 2
R 2
U 2
D 2
L 1
R 2
D 1
R 2
D 2
L 1
U 2
R 1
D 2
L 1
D 2
U 2
D 1
U 2
R 1
D 1
L 1
D 2
R 2
U 1
R 1
D 2
L 2
R 2
D 1
R 3
U 1
D 1
U 1
R 2
U 2
R 3
U 3
L 3
D 2
L 3
D 1
L 3
D 3
R 3
D 3
R 3
L 2
D 3
R 1
L 3
U 1
L 1
U 1
L 2
R 3
D 2
U 3
R 3
D 2
L 3
R 3
D 1
L 3
U 1
D 1
L 1
D 2
L 2
U 1
L 1
R 1
U 3
R 2
L 3
U 2
R 2
U 1
D 3
U 1
L 1
U 2
R 1
D 3
R 3
U 3
D 2
U 1
L 1
D 3
L 2
U 3
D 1
R 1
D 1
R 3
U 2
L 1
U 3
R 1
U 2
L 3
R 2
L 1
R 1
U 2
L 1
D 2
L 3
D 3
R 3
D 1
U 3
D 1
R 3
U 2
L 2
D 1
U 1
R 3
L 2
D 2
L 2
D 2
R 1
D 3
L 1
R 2
L 2
R 3
L 1
U 1
D 2
R 2
U 3
R 1
L 2
R 3
U 1
L 3
D 3
L 1
D 1
U 4
R 2
L 1
D 3
U 1
D 3
R 2
L 2
D 2
L 3
U 4
D 4
L 4
U 1
D 2
L 3
R 1
L 1
U 2
D 1
U 3
L 2
R 2
D 2
L 2
R 4
D 1
L 2
R 4
U 4
L 3
R 3
D 1
L 3
U 3
L 1
U 3
L 1
D 4
U 1
R 3
L 2
R 3
D 2
L 4
U 1
D 4
L 2
U 2
D 3
L 2
U 3
R 1
U 1
R 2
U 3
L 1
R 4
D 2
R 1
D 1
L 4
R 3
U 1
D 2
L 3
R 4
L 1
U 1
D 2
U 1
D 3
R 3
L 3
U 1
L 3
R 3
D 2
U 2
L 2
R 1
L 3
U 3
R 4
D 1
U 4
D 1
R 2
D 4
L 2
R 1
L 2
R 1
D 3
U 3
R 1
U 1
R 1
D 2
R 4
D 4
L 3
D 4
R 1
D 1
U 1
L 1
R 1
D 4
L 1
R 1
U 4
R 5
D 4
R 5
U 1
D 1
R 1
U 4
L 3
D 5
U 3
L 2
D 3
R 5
U 1
D 1
R 2
L 1
R 3
D 4
R 5
L 1
U 3
D 3
R 1
D 4
R 1
L 4
R 3
U 1
D 1
U 5
R 2
L 3
U 1
L 4
D 1
R 3
L 4
D 2
R 3
L 5
D 2
L 3
D 2
L 2
R 4
D 1
R 3
L 5
U 2
L 4
D 3
L 2
R 4
D 5
L 5
R 4
U 5
D 2
U 4
D 4
L 3
U 3
L 3
D 1
R 4
D 4
U 3
R 4
L 3
D 2
L 4
D 2
L 4
R 3
L 5
R 2
L 3
R 3
U 4
D 4
L 4
R 2
D 4
U 3
L 3
U 1
D 2
U 5
L 2
D 3
U 1
R 5
D 2
L 3
U 1
D 2
L 2
U 2
R 5
L 4
R 4
L 2
D 3
R 1
U 5
R 2
L 5
U 3
L 3
R 6
D 2
L 2
R 2
U 1
D 6
U 6
D 1
L 3
R 6
U 6
R 3
D 6
R 5
U 5
D 1
R 4
L 2
U 2
R 4
D 6
U 4
R 4
D 6
R 2
U 1
D 5
U 3
R 1
L 2
R 1
U 6
R 1
L 1
U 4
R 1
D 6
U 2
D 5
R 2
D 6
R 3
L 3
U 1
R 3
L 4
D 6
L 3
U 3
D 1
U 4
R 6
L 3
D 2
U 6
R 2
D 4
R 3
D 5
U 2
L 1
D 4
R 1
L 3
R 5
U 4
D 1
L 3
U 4
R 2
D 6
R 4
D 5
R 5
D 3
R 6
L 4
U 2
L 4
U 2
L 5
D 2
R 3
D 2
R 6
U 4
R 5
U 1
R 6
D 4
L 2
D 2
U 2
L 5
R 1
U 2
R 3
U 5
L 3
D 1
L 1
R 1
L 3
U 1
L 4
R 3
L 6
U 4
L 2
D 2
U 7
R 7
U 4
R 5
D 4
L 7
U 5
L 5
U 1
D 5
L 3
R 4
D 3
R 5
L 3
D 3
L 4
U 5
L 4
R 2
L 5
U 4
L 4
D 4
U 5
L 3
U 7
R 2
L 1
U 2
L 7
U 5
R 4
D 5
R 1
L 3
D 6
R 7
L 1
R 5
D 4
U 4
L 7
D 6
U 7
R 4
U 2
R 2
U 2
R 7
D 6
R 4
L 1
R 4
D 3
U 5
R 3
L 5
R 2
L 3
D 2
R 1
D 3
L 7
D 4
L 7
U 7
D 5
R 6
U 7
R 5
D 6
R 5
L 4
U 1
D 2
L 4
D 5
L 5
D 2
L 7
R 2
U 7
L 6
D 3
U 3
D 6
U 1
R 3
L 1
U 7
R 2
D 2
U 3
L 6
D 5
U 5
D 2
R 6
D 3
L 3
R 2
L 6
D 1
L 2
D 1
L 7
U 1
D 2
U 3
L 5
D 7
R 2
L 8
U 7
L 4
U 4
D 1
U 4
D 3
R 8
U 3
L 4
R 1
L 5
R 1
L 1
D 8
R 5
L 2
U 1
L 8
U 8
D 1
R 3
U 1
R 1
U 5
R 4
L 4
U 7
D 1
U 8
L 4
D 7
U 8
L 5
D 2
R 4
L 3
R 2
L 2
D 1
U 4
D 2
L 8
U 1
R 6
D 5
R 7
D 2
U 4
L 4
R 3
U 2
D 8
R 3
L 3
U 2
R 1
D 5
U 2
R 5
D 8
R 7
U 2
L 6
U 2
D 1
L 4
U 1
D 7
U 4
L 3
U 5
R 5
D 4
R 7
U 4
L 6
R 4
U 5
D 7
U 5
D 3
L 5
U 1
L 8
D 8
R 3
L 6
R 6
U 1
R 8
L 8
U 6
R 2
L 6
U 2
L 4
D 1
L 1
U 5
D 3
R 6
D 6
L 7
D 7
L 1
R 7
U 4
L 7
U 6
R 1
L 8
D 6
L 5
U 2
D 7
R 8
D 1
L 6
R 1
L 8
D 3
R 8
L 8
U 7
R 3
U 6
L 2
R 9
L 3
R 9
D 1
L 2
R 7
L 8
U 1
D 9
U 7
L 9
R 1
L 8
D 7
R 4
L 9
U 1
L 2
D 7
R 7
D 5
L 4
D 7
U 9
R 9
D 4
R 6
D 5
L 1
R 8
U 8
L 6
R 4
L 3
U 4
D 7
R 8
D 8
R 2
L 4
R 4
U 1
L 8
U 5
L 9
U 4
R 9
L 1
R 1
D 5
L 5
D 8
U 2
L 4
U 5
D 4
L 1
D 1
R 1
U 9
R 4
D 2
U 6
L 5
R 7
D 9
L 3
U 2
L 8
U 6
D 4
R 1
U 4
R 1
U 6
D 8
U 7
R 5
D 4
R 2
D 6
U 6
R 1
U 3
D 8
U 2
R 1
U 8
D 9
U 3
R 3
D 6
R 8
D 1
L 2
D 2
R 3
D 3
U 3
D 2
R 2
L 5
R 1
U 9
L 9
D 3
R 2
L 10
R 6
L 5
R 4
L 6
R 8
D 2
L 1
R 2
D 4
L 9
D 6
U 2
R 7
U 9
D 5
R 2
L 10
D 7
L 8
U 3
R 4
U 4
L 7
U 10
R 8
L 7
U 10
R 9
D 4
R 2
L 10
R 9
L 4
D 7
L 10
D 5
U 4
R 3
L 7
D 3
L 3
R 3
D 10
R 2
L 6
D 5
R 10
L 7
U 1
D 6
L 3
D 4
L 3
D 7
R 10
U 6
R 2
U 5
R 7
U 3
R 2
U 6
R 5
L 9
R 5
D 3
U 4
L 5
R 6
U 1
L 6
U 7
D 10
R 10
U 9
L 10
D 10
R 6
L 1
U 8
R 10
U 8
R 10
U 1
D 8
U 10
R 9
D 8
R 4
D 10
L 4
U 9
L 1
D 3
R 1
L 3
D 1
L 9
R 5
D 7
R 3
L 4
R 8
U 6
D 7
U 3
R 1
D 8
L 3
R 9
U 8
R 11
D 5
L 5
U 3
R 6
U 10
R 8
D 1
U 3
D 1
R 11
D 8
U 11
R 7
U 6
R 7
U 6
L 7
D 4
U 10
L 4
U 1
L 10
D 3
R 3
U 9
L 11
U 10
R 6
U 10
R 10
D 9
L 10
R 6
L 2
R 6
L 1
D 10
U 8
D 11
U 2
L 9
U 7
R 8
L 10
R 11
D 4
L 9
R 3
U 1
L 8
D 1
L 9
U 8
D 8
U 5
R 6
D 5
R 9
D 1
L 11
R 4
D 11
R 9
L 11
R 1
U 5
L 3
D 4
R 6
D 9
R 4
L 7
U 3
D 6
U 8
D 1
U 8
D 5
U 11
R 7
U 1
L 1
U 5
L 4
D 1
R 1
L 8
U 9
D 10
U 4
L 1
R 4
D 11
R 8
D 8
R 11
D 12
U 3
L 12
U 10
L 9
R 11
D 10
R 5
D 12
U 6
L 12
R 3
D 7
U 11
L 6
U 5
R 8
D 3
U 8
D 8
R 10
D 12
L 4
R 10
L 10
U 1
L 7
R 10
L 7
U 4
R 1
L 10
R 8
D 11
L 2
U 2
L 6
U 9
R 10
L 2
R 10
U 4
R 9
D 7
L 1
U 7
L 12
D 1
L 9
U 7
L 8
R 12
L 3
D 9
U 7
L 11
D 6
R 4
D 2
R 11
U 10
R 8
D 12
U 10
R 4
L 11
R 2
U 11
L 7
R 6
L 12
R 5
U 7
L 6
R 12
D 6
R 2
L 10
U 4
D 5
U 11
R 3
D 10
L 2
U 9
L 3
D 6
U 10
L 3
U 10
L 7
R 8
U 10
D 3
R 3
L 12
D 12
L 9
R 2
D 2
R 9
L 4
D 5
L 2
R 12
D 2
R 4
U 2
D 4
U 3
R 13
L 3
U 9
R 5
U 2
D 8
L 7
D 10
L 1
U 2
R 13
D 11
L 7
D 6
L 11
R 12
U 2
D 9
R 11
U 9
D 9
L 2
D 13
U 3
L 7
D 3
L 10
R 5
U 4
L 5
U 8
L 4
U 11
R 3
L 3
D 1
L 12
D 8
R 12
L 1
U 6
D 2
U 13
L 5
U 4
R 12
L 11
U 1
D 3
U 11
D 1
R 2
L 6
D 11
R 5
D 7
R 2
U 9
L 5
R 4
U 4
R 9
U 9
L 9
U 3
R 10
L 5
R 5
U 13
D 2
U 2
L 3
R 1
U 11
D 10
L 7
D 8
R 10
U 10
L 13
U 3
L 9
D 2
R 13
U 2
D 10
U 8
L 5
U 1
D 10
L 11
R 5
D 8
L 11
D 3
R 13
D 11
L 8
D 6
L 3
U 13
L 9
U 8
R 8
U 11
D 1
U 7
D 2
R 8
L 4
D 6
U 10
L 6
R 2
D 8
R 5
L 7
U 4
D 9
U 4
D 12
L 12
R 3
L 12
D 7
L 3
U 10
D 3
U 5
R 3
U 4
L 4
R 9
L 8
R 11
D 5
R 10
D 13
U 1
L 4
D 5
R 13
U 1
R 8
U 9
D 2
R 8
D 4
U 14
R 14
D 13
U 2
R 1
U 3
D 11
L 3
U 2
D 10
L 6
U 9
R 13
D 10
U 13
D 4
L 11
D 9
U 6
L 6
U 6
D 4
L 7
D 14
L 11
D 1
L 12
R 2
L 10
U 3
D 5
U 12
D 6
U 6
D 3
U 8
R 3
D 11
R 7
D 4
R 3
U 12
R 10
D 9
U 12
R 6
L 13
D 1
L 3
U 1
R 14
L 8
D 11
L 5
U 10
L 12
D 9
R 11
L 14
D 8
L 2
R 9
D 7
U 4
L 9
D 9
U 6
D 5
R 5
L 10
R 12
L 13
U 8
L 2
D 3
L 8
U 3
R 14
D 9
U 8
D 7
U 2
L 5
R 11
U 12
L 3
U 13
D 4
R 9
U 8
D 14
R 14
L 5
D 4
U 12
L 1
D 11
R 1
U 12
D 1
U 9
L 14
D 4
R 15
D 10
U 14
R 13
U 11
D 8
L 1
U 5
R 2
D 10
U 9
R 11
D 2
L 15
R 3
U 2
D 4
U 15
D 8
L 6
D 1
L 4
U 2
D 11
R 6
U 2
R 13
U 4
L 5
D 2
R 5
U 10
R 4
D 1
R 9
D 11
L 13
U 13
R 2
L 3
R 7
U 10
R 14
L 15
R 1
U 12
D 6
R 10
L 12
R 13
D 11
U 15
R 8
L 12
D 6
R 10
D 4
L 1
R 5
L 10
U 2
R 1
L 9
D 15
R 7
U 8
D 8
L 1
D 14
U 5
D 4
L 1
R 6
L 15
U 13
D 6
L 5
D 13
R 9
D 7
L 15
R 2
D 14
R 12
D 13
L 6
U 5
L 13
U 16
L 3
D 12
L 13
U 11
L 5
U 6
D 5
L 15
D 2
R 6
L 2
R 5
L 6
R 16
D 4
L 10
R 9
L 9
D 5
R 6
D 8
U 6
D 1
R 4
U 6
D 10
R 4
L 12
D 10
R 2
D 5
U 15
R 12
U 6
D 15
R 5
D 1
L 9
U 16
R 3
D 6
L 1
R 12
D 12
U 3
R 1
D 2
L 11
R 7
D 7
U 10
L 8
U 15
L 7
U 12
D 10
R 2
L 8
R 12
D 16
R 13
L 15
U 1
R 1
U 13
L 6
R 12
L 5
D 5
U 12
D 4
L 7
R 11
L 12
U 16
D 11
U 7
L 1
U 11
D 7
U 14
D 14
R 10
D 4
R 5
D 2
R 13
L 13
D 6
L 16
R 1
L 4
D 3
U 15
R 1
U 2
D 2
U 2
D 3
U 7
D 16
U 11
L 8
R 1
D 6
U 1
R 5
L 6
U 5
D 3
L 13
U 8
L 11
D 17
U 12
L 16
U 1
D 6
U 17
D 7
U 12
R 3
U 6
L 10
R 1
L 14
U 11
L 8
U 10
L 14
D 4
R 3
L 14
D 13
L 17
R 12
U 9
D 7
U 2
R 10
L 16
U 9
R 17
D 14
U 9
L 13
R 13
L 5
U 14
L 4
R 10
U 2
L 9
D 17
L 17
U 9
D 9
L 4
U 15
L 2
U 17
R 1
L 5
R 2
U 5
R 5
L 17
R 4
U 12
R 11
L 17
U 11
D 15
U 10
R 7
D 9
L 15
U 1
D 6
L 13
R 7
D 12
L 6
U 14
R 11
D 2
L 4
R 14
L 17
R 2
D 1
R 13
L 12
D 12
L 16
D 14
L 4
R 14
U 15
L 17
U 9
D 13
R 6
D 2
R 4
L 8
U 16
R 10
L 6
U 7
D 4
L 15
D 2
U 14
L 5
R 8
L 2
D 14
U 7
R 5
U 13
L 9
D 2
U 18
R 9
U 13
R 9
L 5
D 10
U 18
D 13
U 13
D 14
L 3
R 2
L 13
D 11
R 17
L 15
D 3
L 1
U 10
L 14
D 15
L 13
R 12
D 4
L 1
D 2
R 16
D 10
U 11
L 12
U 1
D 2
R 3
U 2
R 12
L 6
D 1
L 13
R 11
U 8
L 8
D 10
R 5
U 6
L 7
R 4
U 9
L 6
D 10
L 14
U 11
D 1
L 7
R 3
U 16
L 11
D 13
L 14
U 10
L 3
R 12
U 9
R 11
U 10
L 8
D 5
U 9
L 16
R 17
D 3
R 5
D 13
U 8
R 5
U 16
R 2
U 13
D 16
L 9
D 14
L 15
U 15
L 1
D 8
L 7
D 1
R 11
D 16
R 9
U 14
L 18
U 4
D 14
L 14
D 9
R 6
L 1
R 4
L 11
D 17
L 9
R 10
L 19
U 12
D 15
R 9
L 3
D 13
R 6
D 19
R 9
D 1
L 13
D 8
L 19
U 14
R 18
D 10
R 7
L 18
U 18
D 5
L 1
U 10
D 10
U 19
R 14
L 7
D 19
U 10
L 3
U 17
D 1
L 5
U 7
R 16
D 3
U 8
D 17
U 17
D 17
L 14
D 19
R 8
D 14
L 7
U 7
L 5
D 6
L 1
U 14
L 10
U 15
L 7
D 14
L 11
R 5
D 14
L 13
R 2
L 19
D 7
R 8
L 16
U 4
L 9
U 17
R 15
L 8
U 15
D 5
R 8
L 16
R 6
D 17
U 19
D 19
R 10
D 4
U 12
D 2
L 18
D 13
L 7
U 17
L 13
D 5
U 2
L 6
R 4
U 19
L 4
D 8
U 7
L 3
R 4
U 17
L 1
U 6
R 9
D 16
R 4
D 9
R 9
L 11
U 17
D 18
U 18
R 16
L 7
R 18
U 5
L 4
D 7
Step
Int32
4
1
[Step] <= [Steps]
[Step] + 1
Head_Coordinates
New Field
Int32
4
Nearest
IF [Direction] = "U"
THEN Left([Row-1:Head_Coordinates], FindString([Row-1:Head_Coordinates], ",")+1) + ToString(ToNumber(SubString([Row-1:Head_Coordinates], FindString([Row-1:Head_Coordinates], ",")+1)) + 1)
ELSEIF [Direction] = "D"
THEN Left([Row-1:Head_Coordinates], FindString([Row-1:Head_Coordinates], ",")+1) + ToString(ToNumber(SubString([Row-1:Head_Coordinates], FindString([Row-1:Head_Coordinates], ",")+1)) - 1)
ELSEIF [Direction] = "R"
THEN ToString(ToNumber(Left([Row-1:Head_Coordinates], FindString([Row-1:Head_Coordinates], ","))) + 1) + SubString([Row-1:Head_Coordinates], FindString([Row-1:Head_Coordinates], ","))
ELSE ToString(ToNumber(Left([Row-1:Head_Coordinates], FindString([Row-1:Head_Coordinates], ","))) - 1) + SubString([Row-1:Head_Coordinates], FindString([Row-1:Head_Coordinates], ","))
ENDIF
IF [Direction] = "U"
THEN Left([Row-1:Head_Coordinates], Find...
Tail_Coordinates_1
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Head_Coordinates], FindString([Head_Coordinates], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")))) > 1 OR ABS(ToNumber(SubString([Head_Coordinates], FindString([Head_Coordinates], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1))) > 1
THEN IF ToNumber(Left([Head_Coordinates], FindString([Head_Coordinates], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")))
THEN IF ToNumber(SubString([Head_Coordinates], FindString([Head_Coordinates], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1))
THEN Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Head_Coordinates], FindString([Head_Coordinates], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1))
THEN IF ToNumber(Left([Head_Coordinates], FindString([Head_Coordinates], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ","))) + 1) + SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ","))) - 1) + SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ","))
ENDIF
ELSEIF ToNumber(Left([Head_Coordinates], FindString([Head_Coordinates], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")))
THEN IF ToNumber(SubString([Head_Coordinates], FindString([Head_Coordinates], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Head_Coordinates], FindString([Head_Coordinates], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")))
THEN IF ToNumber(SubString([Head_Coordinates], FindString([Head_Coordinates], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_1], FindString([Row-1:Tail_Coordinates_1], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_1]
ENDIF
IF ABS(ToNumber(Left([Head_Coordinates], FindString([Head_Coo...
Direction = Left([Data], FindString([Data], " "))
Steps = ToNumber(SubString([Da...
Tail_Coordinates_2
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")))) > 1 OR ABS(ToNumber(SubString([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1))) > 1
THEN IF ToNumber(Left([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1))
THEN Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1))
THEN IF ToNumber(Left([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ","))) + 1) + SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ","))) - 1) + SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ","))
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_1], FindString([Tail_Coordinates_1], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_2], FindString([Row-1:Tail_Coordinates_2], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_2]
ENDIF
IF ABS(ToNumber(Left([Tail_Coordinates_1], FindString([Tail_C...
Tail_Coordinates_3
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")))) > 1 OR ABS(ToNumber(SubString([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1))) > 1
THEN IF ToNumber(Left([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1))
THEN Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1))
THEN IF ToNumber(Left([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ","))) + 1) + SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ","))) - 1) + SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ","))
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_2], FindString([Tail_Coordinates_2], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_3], FindString([Row-1:Tail_Coordinates_3], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_3]
ENDIF
IF ABS(ToNumber(Left([Tail_Coordinates_2], FindString([Tail_C...
Tail_Coordinates_4
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")))) > 1 OR ABS(ToNumber(SubString([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1))) > 1
THEN IF ToNumber(Left([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1))
THEN Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1))
THEN IF ToNumber(Left([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ","))) + 1) + SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ","))) - 1) + SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ","))
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_3], FindString([Tail_Coordinates_3], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_4], FindString([Row-1:Tail_Coordinates_4], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_4]
ENDIF
IF ABS(ToNumber(Left([Tail_Coordinates_3], FindString([Tail_C...
Tail_Coordinates_5
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")))) > 1 OR ABS(ToNumber(SubString([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1))) > 1
THEN IF ToNumber(Left([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1))
THEN Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1))
THEN IF ToNumber(Left([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ","))) + 1) + SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ","))) - 1) + SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ","))
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_4], FindString([Tail_Coordinates_4], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_5], FindString([Row-1:Tail_Coordinates_5], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_5]
ENDIF
IF ABS(ToNumber(Left([Tail_Coordinates_4], FindString([Tail_C...
Tail_Coordinates_6
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")))) > 1 OR ABS(ToNumber(SubString([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1))) > 1
THEN IF ToNumber(Left([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1))
THEN Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1))
THEN IF ToNumber(Left([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ","))) + 1) + SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ","))) - 1) + SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ","))
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_5], FindString([Tail_Coordinates_5], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_6], FindString([Row-1:Tail_Coordinates_6], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_6]
ENDIF
IF ABS(ToNumber(Left([Tail_Coordinates_5], FindString([Tail_C...
Tail_Coordinates_7
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")))) > 1 OR ABS(ToNumber(SubString([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1))) > 1
THEN IF ToNumber(Left([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1))
THEN Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1))
THEN IF ToNumber(Left([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ","))) + 1) + SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ","))) - 1) + SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ","))
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_6], FindString([Tail_Coordinates_6], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_7], FindString([Row-1:Tail_Coordinates_7], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_7]
ENDIF
IF ABS(ToNumber(Left([Tail_Coordinates_6], FindString([Tail_C...
Tail_Coordinates_8
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")))) > 1 OR ABS(ToNumber(SubString([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1))) > 1
THEN IF ToNumber(Left([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1))
THEN Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1))
THEN IF ToNumber(Left([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ","))) + 1) + SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ","))) - 1) + SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ","))
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_7], FindString([Tail_Coordinates_7], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_8], FindString([Row-1:Tail_Coordinates_8], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_8]
ENDIF
IF ABS(ToNumber(Left([Tail_Coordinates_7], FindString([Tail_C...
Tail_Coordinates_9
New Field
Int32
4
Nearest
IF ABS(ToNumber(Left([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) - ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")))) > 1 OR ABS(ToNumber(SubString([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) - ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1))) > 1
THEN IF ToNumber(Left([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) = ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1))
THEN Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1)) + 1)
ELSE Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1) + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(SubString([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) = ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1))
THEN IF ToNumber(Left([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ","))) + 1) + SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ","))
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ","))) - 1) + SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ","))
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) > ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ","))) + 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1)) - 1)
ENDIF
ELSEIF ToNumber(Left([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) < ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")))
THEN IF ToNumber(SubString([Tail_Coordinates_8], FindString([Tail_Coordinates_8], ","))) > ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1))
THEN ToString(ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1)) + 1)
ELSE ToString(ToNumber(Left([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ","))) - 1) + "," + ToString(ToNumber(SubString([Row-1:Tail_Coordinates_9], FindString([Row-1:Tail_Coordinates_9], ",")+1)) - 1)
ENDIF
ELSE "0"
ENDIF
ELSE [Row-1:Tail_Coordinates_9]
ENDIF
IF ABS(ToNumber(Left([Tail_Coordinates_8], FindString([Tail_C...
Horizontal
AoC_2022_Day_9