Data loading - quoting and delimiter issue

[selracir]

I have a dataset that it is split by a pipe delimeter (¦) and in some cases the string has quotations.

I have tried the select data with quoting none and the quotations appear in the fields 

If I try it with standard the quotes don't appear, but the split does not work. It adds the full row (within quotes) in the first field

Any ideas on how I can split it out correctly?

[dwforest]

Since the split is correct using None, try using Replace() to get rid of the quotes.
Replace(@1,'"','')

[selracir]

Perfect, thanks