Neerja,

>command used : copy to aa.txt delimited with ';'
>
>but this also gives me ;,; in txt how can i eliminate them and pick up only the 3 fields

If you want just the fields without any other characters surrounding them, do this:

COPY TO aa.txt TYPE SDF

This will output the entire length of each field, one after the other.