Andrew & all,
I am trying to get a pipe delimited file using a similar query as suggested above using fastexport. However i am getting some tabs or spaces before each row in the file generated.Here is the query i am using .
this has been discussed several times, the best solution is to switch to TPT, the latest versions can directly export delimited data without need for TRIM/concat.
Otherwise the "tabs or spaces" are a two-byte word indication the lebgth of the VarChar, you can get rid of it using an OutMod or a Unix tool like awk to simply strip of the first two bytes