Sub-Text

[George]

Hi.

I am VERY new to AA, but have a great deal of experience with other automation products.

I have defined a variable to be a list from a file. The task loops fine with no problems.

The issue is that I need to assign different parts of the variable from the list and cannot find how to do this.

For example, the variable is $PORecLin$, and it looks something like:
PORecLin=10000100123,10000100245,10000100360
where positions 1-6 are the purchase order number, 7-9 are the line number and 10-11 are the quantity received. When I loop the list, I get the entire line, but how do I parse this line into the separate variables?

Thank you very much.

[forumsupport]

Hello George,

You can do something as follows

Loop for List $PORecLin$

If $Counter$ >= 1 Then
If $Counter$ <= 6 Then
Assign PORecLin to $Clipboard$
Assign $Clipboard$ to $PONumber$
Do something with $PONumber$
End If
End If

If $Counter$ > 6 Then
If $Counter$ <= 9 Then
Assign PORecLin to $Clipboard$
Assign $Clipboard$ to $LineNumber$
Do something with $LineNumber$
End If
End If

If $Counter$ > 9 Then
If $Counter$ <= 11 Then
Assign PORecLin to $Clipboard$
Assign $Clipboard$ to $Quantity$
Do something with $Quantity$
End If
End If

End Loop

You will need to define the three value type variables i.e. PONumber, LineNumber and Quantity.

Counter increments by 1 every time the loop goes to the next iteration. It starts with 1.

Hope that helps.