Skip to Content
0
Former Member
Feb 18, 2011 at 06:37 PM

I am trying to parse a string field

26 Views

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?