Forum Discussion
AlexKaras
11 years agoChampion Level 3
I would add:
-- If you have #2 but don't want to resort to custom separator, you may try aqString.Quote() which will quote the string and double quote every quote within the string (e.g [1 1/2"] will become "[1 1/2""]"). This should make it possible for the csv file to be imported into Excel without the necessity of any additional setting.
Note: I did not check explicitly the above, but this is what I seem to remember from the documentation.
-- If you have #2 but don't want to resort to custom separator, you may try aqString.Quote() which will quote the string and double quote every quote within the string (e.g [1 1/2"] will become "[1 1/2""]"). This should make it possible for the csv file to be imported into Excel without the necessity of any additional setting.
Note: I did not check explicitly the above, but this is what I seem to remember from the documentation.
Related Content
Recent Discussions
- 2 days agoMW_Didata