I am reading a field from a table that contains several comma seperated control fields. Like this -
TYPE=A,CREATE USER=amanger ,MODIFIED USER=amanger ,SHORT PAID ITEM 03P89-24 TO
CONTRACT PRICE OF 5.36 EA PER BUYER LYNNE HENRY.
I need to check position 6 to see if it is an A or a C, if it is then I need return all the rest of the string after the 3rd comma. In this case it would be
SHORT PAID ITEM 03P89-24 TO CONTRACT PRICE OF 5.36 EA PER BUYER LYNNE HENRY.
I tried this
if (Left ({L_HAPI.OBJECT}, 6) = "A")
or (Left ({L_HAPI.OBJECT}, 6) = "C")
then Split ({L_HAPI.OBJECT}, "," , 3 )
else ""
but it did not work.
I need to set up a formula that will work, can anybody help me?