The specified input format is illegal.

[Bob_Patton]

What am I doing wrong? I'm trying to file/ import/ transactions/ generic. My input format is:
YY ,MM ,DD ,TRAN ,SYMB ,BNUM, ANUM

My transactions file looks like this:

1998 3 12 BUY FDGFX 75.614 2000
1998 3 23 BUY FDGFX 74.377 2000
1998 9 4 REINV_D FDGFX 0.525 12

or this:

1998,3,12,BUY,FDGFX,75.614,2000.00
1998,3,23,BUY,FDGFX,74.377,2000.00
1998,9,4,REINV_D,FDGFX,0.525,12.00

I tried both the cvs and txt formats and keep getting the error message:
The specified input format is illegal.
Thanks for your help.

Bob

[Mark]

Hi Bob,

The first problem is you don't have CNUM in your format string or data. It is a required field. Even if the commission is 0, you still need to specify it to be 0, you can't omit it.

1998 3 12 BUY FDGFX 75.614 2000
1998 3 23 BUY FDGFX 74.377 2000
1998 9 4 REINV_D FDGFX 0.525 12

For this format, you don't have commas between the fields, so you wouldn't include them in your format string either. You have spaces, so use a space. A single space matches all white space, so you can use this format string for the above:

YY MM DD TRAN SYMB BNUM ANUM CNUM

(I added CNUM, but you'd have to include that field in your data file too)

1998,3,12,BUY,FDGFX,75.614,2000.00
1998,3,23,BUY,FDGFX,74.377,2000.00
1998,9,4,REINV_D,FDGFX,0.525,12.00

Here you are using commas, and have no spaces, so you do not want a space in your format string, or it will not match. For this you would use:

YY,MM,DD,TRAN,SYMB,BNUM,ANUM,CNUM

[Bob_Patton]

Yeah, that fixed it. Thank you.

Bob