Personally, I think using a semi-colon for a delimiter is a very bad idea. It is recognized as a line continuation character for one thing.

However, you also have to have each field separated with a comma. If you do a global replace of all your semi-colons with ;,;, the append works.


>Hello All:
> I used the append from command to insert record to a cursor from a ascii file. I do not know what did I do wrong that only two fields were insert to the cursor for each record. Please take a look of my codes and help:
>
>CREATE CURSOR SOURCE(clEntity C(2), QT_ID C(7),clInsured C(81),;
> clDBA C(30), clAddr1 C(30), clAddr2 C(30), clCity C(20),;
> clState C(2), clZip C(5), qtPolicyNo C(9),;
> qtEffDate D, qtExpDate D, RAgtName C(30),AG_ID C(9),;
> RISKNUM N(1), calLocCity C(20), caLocState C(2), ;
> caRiskYear C(4),caRiskMake C(20),caRiskVin C(17), ;
> caBody C(15), caAddIns C(30),;
> caAIType C(25), caFormID C(25))
>
>append from test.txt delimited with ";"
>
>The ascii file looks like this:
>IN;BUSHJ01 ;JOSEPH BUSH ; ;RTE 1 BOX 108A ; ;LOWVILLE ;NY;13367 ;TN276532 ;07/21/00;07/21/01;W.B. PAYNE CO., INC. ;0950990; 1;LOWEVILLE ;NY;2000;FORD ;1FDWX37F9YEC89844 ;TRUCK ;
>IN;BUSHJ01 ;JOSEPH BUSH ; ;RTE 1 BOX 108A ; ;LOWVILLE ;NY;13367 ;TN276532 ;07/21/00;07/21/01;W.B. PAYNE CO., INC. ;0950990; 2;LOWVILLE ;NY;1985;EBY ;1E9LG222XF1011240 ;TRAILER ;
>IN;BUSHJ01 ;JOSEPH BUSH ; ;RTE 1 BOX 108A ; ;LOWVILLE ;NY;13367 ;TN276532 ;07/21/00;07/21/01;W.B. PAYNE CO., INC. ;0950990; 3;LOWEVILLE ;NY;2001;BARRETT ;1B9P2420X11014262 ;TRAILER ;CA0012 ;CA0022 ;CA0112 ;CA0225 ;CA2232 ;CA3107 ;CA9944 ;IL0017 ;IL0183 ;IL0185 ;INVOICE ;N2500 ;T006 ;T047 ;T217 ;T224 ;T237NY ;T344NY ;TD01NY ;TJ01NY ;