Please help me write a line in dos dbaseiv
I want to copy to a text file with trimming. Would like to say:
Use databasename
copy to my.txt fields rtrim(firstfieldname)(+ or , whichever best) rtrim(secondfieldname) for thirdfieldname='namewantedthen' (SDF or delimited with ",")
I can't get it to work with trim. It does work without trim and using the + and ending with SDF but that leaves me with lots of spacing I don't want.
I want to copy to a text file with trimming. Would like to say:
Use databasename
copy to my.txt fields rtrim(firstfieldname)(+ or , whichever best) rtrim(secondfieldname) for thirdfieldname='namewantedthen' (SDF or delimited with ",")
I can't get it to work with trim. It does work without trim and using the + and ending with SDF but that leaves me with lots of spacing I don't want.