Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to remove extra double quotes from .txt file?
Store command throws error for 'no quotes'.
AFAIK it's not possible. The for the store/export used MS library is quite old and not very flexible. This means you need to remove all quotes from your data - maybe replacing the needed delimiter with another char. By many tools you are able to define which char should be used as quote-char if you want to import it there.
Further possible is to adjust (removing/replacing the appropriate chars) the txt-file with various third-party tools.
An alternatively could also be not to store/export the data else to write them with macro:
Export-to-CSV-with-quotation-marks
- Marcus
AFAIK it's not possible. The for the store/export used MS library is quite old and not very flexible. This means you need to remove all quotes from your data - maybe replacing the needed delimiter with another char. By many tools you are able to define which char should be used as quote-char if you want to import it there.
Further possible is to adjust (removing/replacing the appropriate chars) the txt-file with various third-party tools.
An alternatively could also be not to store/export the data else to write them with macro:
Export-to-CSV-with-quotation-marks
- Marcus