Export to delimited file - text qualifiers only on text.

I'm trying out AETL-E Version 5.7.2.10
Source .xls file
using a transformation

Can't figure out how to export a | delimited file and only have " qualifiers on non null text.
right now I've got:
|""|"02/26/1964"|"2500 waterhole road"|""|"Colchester"|"1"

what I want is:
||02/26/1964|"2500 waterhole road"||"Colchester"|1|

Read the rules
www.etl-tools.com/forum/rules

version number?
Source type?
How do you export it using package or transformation?

Mike

Version 5.7.2.10
Source .xls file
using a transformation

thx

You can just remove quote fro writer and use if null + ensure prefix/suffix functions to enclose values when necessary

see pictures attaches

Peter

can that be combined into 1 operator somehow? I have to apply it to 137 fields.

Can you try the following please

1. Make sure that the writer has only one field
2. Remove leading/closing spaces from all fields using trim function
3. Join all fields using quote and | as delimiter
4 Replace |"" with |

Let us know the outcome
Peter