AnsweredAssumed Answered

Help Parsing List

Question asked by edocx on Oct 23, 2010
Latest reply on Oct 24, 2010 by LaRetta_1


Help Parsing List


I have a list made up of four fields seperated by commas. Sometimes the third field is empty sometimes the fourth field is empty. Sometimes both.

To parse field three  when field four is empty  RP,RUSH & PERSONAL SERVICE ONLY,$75.00,

I'm using  MiddleValues ( Substitute ( ClientServiceFees::List ; "," ; "¶" );3;$i )

For field four:: AW15,WITNESS FEE,,15

I'm using RightValues ( Substitute (ClientServiceFees::List ; "," ; "¶" ) ;1)

The blank fields are throwing a monkey wrench in the parsing and appear to be making field four fillin with field three's value when it should be blank and field three fillin with field four's value when it should be blank.

I would appreciate some insight and help in solving this problem.

Thanks in advance.