first zero is missing

[tzutzu]

hi guys,

I need your help please. i am trying to import the attached file into a workfile using wfopen command, but instead of having 010, the workfile store as 10.

i am wondering if there is anyway to import the full three digits codes from the file (maybe as a string perhaps)?

Thanks,

[EViews Chris]

If you're bringing the file in interactively, just use the combo box on the second page of the import to change the data type of the column from "Number" to "Character".

In a program, you can use a command

wfopen code.xls format=(A)

to do the same thing. (The format option has a list of comma separated column data types where 'A' is alphanumeric, 'F' is (floating point) numeric, and 'D' is date).

Chris

[tzutzu]

it works. many thanks Chris

[tzutzu]

hi Chris,

i have another question. would it be possible to import the file specify the first column being alphanumeric and the 2nd column being numeric ?

Thank you..

[EViews Gareth]

(The format option has a list of comma separated column data types where 'A' is alphanumeric, 'F' is (floating point) numeric, and 'D' is date).