Splitting of a single record into 2 records in FDMEE Import scripts

Hi All,

We have a requirement to split the line of a trial balance  - 1000, COPP, 715205, Analysis Charges, 1000, 100120, 102,940.15-, MT, 350,282.65

into 2 lines                                              

1000, COPP, 715205, Analysis Charges, 1000, 100120,,, 350,282.65

1000QTY, COPP, 715205, Analysis Charges, 1000, 100120,,, 940.15-

1. The account code will be changing

2. Amount field will pick up a different value.

We have achieved this functionality in the import script of FDQM - 11.1.2.1

Currently we are migrating to FDMEE 11.1.2.4 and we are at a fix how to solve this.

We have tried writing the below Import script but the is giving an error

strWorkTableName = RES.PstrWorkTable

set rsAppend = DW.DataAccess.farsTable(strWorkTableName)

  if isnumeric(DW.Utilities.fParseString(strRecord, 16, 14, "|")) :