Hi,
I have a field I wish to break up into individual formula fields so each address line is stored seperately.
I'm attempting to use the split function to break up the field as follows :
Split({MainOrder.DeliveryAddress},Chr(013))[1]
This gives me the first line of the address field, however I can't retrieve any of the remaining 3 other lines using the syntax :
Split({MainOrder.DeliveryAddress},Chr(013))[2]
Any ideas where I'm going wrong?
I have a field I wish to break up into individual formula fields so each address line is stored seperately.
I'm attempting to use the split function to break up the field as follows :
Split({MainOrder.DeliveryAddress},Chr(013))[1]
This gives me the first line of the address field, however I can't retrieve any of the remaining 3 other lines using the syntax :
Split({MainOrder.DeliveryAddress},Chr(013))[2]
Any ideas where I'm going wrong?