Yes, this question has been  but only a workaround was ever found, which is not satisfactory for my situation.  Neither is  satisfactory.    The question is, how can I change the default text qualifier in excel, from ", to say, a backtick (`).  This would avoid the CSV file breaking, because I have many instances of unmatched double quotes in the text which stand for inches, and must be left as is.  Thus with "24"" (24 inches), you can see the boundaries for the text are going to shift - which messes up the entire csv file.  You can see that having `24"` solves the problem.  But Excel doesn't seem to have an option to set your preferred text qualifier?  Edit: I'm well aware that the question has been asked multiple times before - so whilst it is strictly a duplicate, it is justified because all the other questions were already closed cases with accepted answers that were workarounds that are not satisfactory for me.  I have certain constraints which I'll elaborate on below, but I opened essentially by clarifying that I needed a different kind of solution, ideally the most direct solution, and if not, something other than the answers already posed elsewhere.  For one thing, multiple mass search and replaces is going to increase the workload to something unacceptable.  And the CSV files are provided to me already in such a way that I cannot distinguish quotes that stand for inches from quotes that serve as text boundaries in search and replace operations.
121908
I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote.  Example:  "col1","col2","col3" "01","text","&lt;html&gt;&lt;tag attrib="true"&gt;"   I decided to use another character as text qualifier, the backtick &#96; which is never present in my original file.  My data are like this now:   `col1`,`col2`,`col3` `01`,`text`,`&lt;html&gt;&lt;tag attrib="true"&gt;`   Now my CSV is totally valid, but in Excel (2013) I cannot just change the Text Qualifier, it allows me only ", ' or {none}  Is there any way to edit this list to add a new text qualifier?  I finally found another way to import it but I am just wondering why the Text Qualifier box is not editable.
71533
Can I add the comma "," to force the decimals to remove from the attribute and replace with the number?   For example, I have an Acres field column that says 506320.0750 and I want to replace the decimal with the comma, say 506,320? I want that number to be permanment.   Is that possible? I'm using ArcGIS Desktop 9.3.1
63401
Without 2k rep, code formatting is impossible, because it just adds spaces, which don't count for the 6-character-ritual-threshold.  This question is related to impossible title-improvements for a similar reason, brought up here:   A more or less  crossed my way today, which wasn't readable because of missing code-indentation. (Many regex-tools like grep, sed, awk work on a line-by-line basis, so it is essential to see, where a line starts and ends.    I put the indentation in, but got an error: at least 6 changes, not counting: white space. Uhm.    I looked for something obvious, which could be changed too - nothing.  I looked for something not so obvious, which could be changed too - nothing.  I got angry and left the page, because I didn't want to write some foobar, or a disclaimer why this disclaimer, which would be much longer than 6 characters.  I had the idea to comment my edit in the question itself - this wouldn't be foobar, but have a bit of sense.  When I finished my comment, I was informed, that meanwhile somebody else did edit that question. I left the question, angry. Lost much time in doing 6-character-gymnastics.    Conclusion: The quality of an improvement isn't much related on the quantity of changed characters, especially not, if whitespace doesn't count.   P.S.: I suggest the new "6-character-rule"-tag.
4966
CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this:    It's probably because when Excel thinks "comma-separated values", it actually searches for some other delimiter (I think it's semicolon but it's not important).  Now when I have already opened this file in Excel, is there a button or something to tell it "reopen this file and use comma as a delimiter"?  I know I can import the data into a new worksheet etc. but I'm asking specifically for a help with situation where I already have a CSV file with commas in it and I want to open it in Excel without creating new workbook or transforming the original file.
25473
If you don’t have 25k reputation, the  contains a stub text:        As you can see on the image, the dot should be moved outside the quotes. Also, on ruSO we need to  from “” to «», but this is not possible via Transifex, because there is no full sentence available to translate.
94564
Starting code is as follows. I'd like a hanging indent for first text column:  MWE:  \documentclass{article} \usepackage[utf8]{inputenc} \usepackage[english]{babel} \usepackage{blindtext} \usepackage{paracol} \usepackage{parskip} \setlength{\parindent}{15pt} \usepackage[utf8]{inputenc} \usepackage[english]{babel} \usepackage{blindtext} \usepackage{paracol} \usepackage{parskip} \setlength{\parindent}{15pt} \usepackage{CJKutf8}  \begin{document}  \section*{Random Text} \begin{paracol}{2} %\hangindent  Person 1: "\blindtext" %\hangafter \switchcolumn \noindent Person 2: "\blindtext" \end{paracol}  \end{document}   Random text on subsequent lines needs to be justified to the opening quote of first line. This should continue until I indicate it to end even with new lines.
40764
I am developing some tables on LaTeX environment and I am having some troubles with the spacing. Originally, I was able to generate the tables using the standard \begin{table}, but then I tried to add some features, as the capability to break the table if it is too long (using longtable) the issue appears. I also want to align numbers by decimal point and center, reason why I use siunitx package. The problem is on the last column, which had a width almost the double than the others. If I specify the column width, the problem "disappear", but I'm really interested in the possibility of automatically generate the width of the table.  The code is the following:  \documentclass[paper=a4, fontsize=11pt]{scrartcl} \usepackage[english]{babel} \usepackage{siunitx} \usepackage{longtable} \usepackage{booktabs}  \begin{document} \begin{longtable}{l*{4}{S}} % no problem specifying the column width\begin{longtable}{l*{4}{S[table-column-width=1.25cm]}} \caption{Univariate Item Descriptives}\\ \toprule \multicolumn{1}{l}{\textbf{Item}} &amp; \multicolumn{1}{c}{\textbf{Mean}} &amp;    \multicolumn{1}{c}{\textbf{Variance}} &amp; \multicolumn{1}{c}{\textbf{Skewness}} &amp; \multicolumn{1}{c}{\textbf{Kurtosis}} \\ \midrule \endfirsthead \multicolumn{5}{c}% {\tablename\ \thetable\ -- \textit{Univariate Item Descriptives (Continued from previous page)}} \\ \toprule \textbf{Item} &amp; \textbf{Mean} &amp; \textbf{Variance} &amp; \textbf{Skewness} &amp; \textbf{Kurtosis} \\ \midrule \endhead \hline \multicolumn{5}{r}{\textit{Continued on next page}} \\ \endfoot \bottomrule \endlastfoot 2. EX +         &amp; 2.788   &amp;    1.060 &amp;        -0.120   &amp;   -0.368\\ 3. DS +         &amp; 4.080   &amp;    0.853 &amp;        -1.141   &amp;    1.379\\ 4. AM +         &amp; 3.684   &amp;    0.705 &amp;        -0.541   &amp;    0.744\\ 5. EX +         &amp; 3.653   &amp;    1.043 &amp;        -0.709   &amp;    0.149\\ 6. DS -         &amp; 2.240   &amp;    1.665 &amp;         0.725   &amp;   -0.603\\ 7. AM +         &amp; 4.292   &amp;    0.876 &amp;        -1.627   &amp;    2.705\\ 8. EX -         &amp; 2.419   &amp;    1.588 &amp;         0.449   &amp;   -0.897\\ 9. AM +         &amp; 3.255   &amp;    0.923 &amp;        -0.234   &amp;   -0.037\\ 10. DS -        &amp; 3.449   &amp;    1.408 &amp;        -0.453   &amp;   -0.599\\ 11. EX +        &amp; 3.678   &amp;    1.232 &amp;        -0.669   &amp;   -0.219\\ 12. AM -        &amp; 2.830   &amp;    1.162 &amp;         0.029   &amp;   -0.565\\ 13. EX -        &amp; 3.452   &amp;    1.205 &amp;        -0.410   &amp;   -0.336\\ 14. DS -        &amp; 2.442   &amp;    1.374 &amp;         0.310   &amp;   -0.893\\ 15. AM -        &amp; 2.114   &amp;    1.168 &amp;         0.729   &amp;   -0.176\\ 16. EX -        &amp; 3.070   &amp;    1.085 &amp;        -0.176   &amp;   -0.347\\ 17. AM +        &amp; 3.893   &amp;    1.116 &amp;        -0.954   &amp;    0.544\\ 18. EX +        &amp; 3.311   &amp;    0.964 &amp;        -0.238   &amp;   -0.066\\ 19. AM -        &amp; 2.674   &amp;    1.404 &amp;         0.245   &amp;   -0.780\\ \end{longtable} \end{document}
38035
Does anyone know a package for ?    Failing that, is anyone interested in writing a command to create one? I'm thinking of something that would have optional and configurable separators above and below (e.g., lines or large quotation marks), and option to float left, right, or center. Ideally the command should print the argument and the pull quote so you do not have to duplicate the text that you want to quote.   To avoid duplicating existing questions, perhaps we should focus on single column documents, so that the pull quote has to be boxed?
74810
I have an equation in my document which is unbreakable and does not fit on one line using the twocolumn global option. Am I forced to shrink the text size here? And how do I go about doing it? \resizebox does not function in math mode.    \documentclass[twocolumn]{ltxdoc} \usepackage{amsmath} \begin{document} \begin{equation} \sum_{q_\mathrm{total}=0}^{q_A+N_A+q_B+N_B-2}\left(\sum_{q_A=0}^{q_\mathrm{total}}\left(\binom{q_A+N_A-1}{q_A}\binom{q_B+N_B-1}{q_B}\right)\right)x^{q_\mathrm{total}} \end{equation} \end{document}
77943
I am trying to find and replace the * (star, or shift+8) character in a bunch of formulas in Excel 2007.  * of course matches the ENTIRE contents of the cell, which is not what I want.  How do I disable this behavior?
69275
I have data (generated from a database, not manually typed in) that mostly fits into a table cell with fixed width, but sometimes overflows because there are long words for which no hyphenation is found.  The problem can be demonstrated with the following example:  \documentclass{article} \usepackage[utf8]{inputenc} \begin{document} \begin{tabular}{|p{1cm}|p{4cm}|} 1 &amp; Cell where normal hyphenation is possible ÄÖÜ \\ 2 &amp; CellwherenormalhyphenationisnotpossiblebutshouldwrapinsteadofoverflowÄÖÜ \end{tabular} \end{document}   My requirements are:   Text never overflows the cell (assuming some minimum width such that at least a handful characters have place) First priority measure to achieve 1. is the normal hyphenation If 2. fails, it is allowed to break the word at any character, so fill the line and break just before overflow would happen (disregarding normal hyphenation rules)   In the example, the overflow in cell 1 is prevented by measure 2., the normal hyphenation. The second cell overflows. I would like to have this cell treated by measure 3.  For the answer please consider:   Package seqsplit didn't help me The custom macro \wrap proposed in the answer to  comes near my wish, but can't handle the non-ascii characters ÄÖÜ (independent if they are input with utf8 input encoding or with \"A\"O\"U) As the text comes from a database, no manual editing of the cell content is wanted.   One of my ideas was to insert \linebreak[0] after every character, to tell LaTeX that a break can be made if no better opportunities exist. But this doesn't work like intended.  Thanks for your suggestions!
5365
Related to  I have a CSV file which contains a mixture of numeric and text fields: ID,Txt,Int,Dbl 12345,abc,45,56.78 12346,9,65,23.12 12347,10,66,23.13  According to this  if the top 8 rows contain a text value, the field will be classified as text, yet I am finding that the second field is classified as Long. This means that the value &quot;abc&quot; is omitted:  How can I force ArcMap to recognise this as a text field, while maintaining the data in CSV format? A workaround will be to create a geodatabase table, define the field as text, and Load the data, but I'm hoping to keep the table in CSV (it's the output of another process).
56650
What is the best way of editing an existing LaTeX table? I need to swap the order of two columns and can't think of an efficient way of doing this.  My table is a long creature of the following structure:  A &amp;     -0.523 &amp;      26.94 &amp;     0.8243 &amp;     0.0000 &amp;     -12.67 \\ B &amp;     -0.614 &amp;      30.02 &amp;     0.8509 &amp;     0.0000 &amp;     -13.12 \\ C &amp;     -0.630 &amp;      32.92 &amp;     0.9254 &amp;     0.0000 &amp;     -21.45 \   I need to change the values so that it is:   A &amp;     26.94 &amp;      -0.523 &amp;     0.8243 &amp;     0.0000 &amp;     -12.67 \\ (etc)   The thoughts that I had were to import it into Excel and to drag columns around, and then use the concatenate() function to produce the number &amp; number structure. I feel like there might be a better way of doing this that I am unaware of.
90637
Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV I tried to convert it to text number and general but after i save it and reopen it again it goes back to 5.03E+02  How do I stop this from happening?
102810
I am adding a number of strings together to create a linestring but as such I need spaces between the initial XY values and the end XY values, plus a comma in between the two halves.  Should result in LINESTRING(97763.88319  434314.9609 , 97620.90369  434175.115) but the space is not recognized like it would be in excel I don't want to make another attribute which only holds a space to then include it as a variable.  This is the expression I used:  concat("LINESTRING(", "X", " ", "Y", " , ", "newX", " " , "newY")
13614
I want to generate a CSV file for user to use Excel to open it.  If I want to escape the comma in values, I can write it as "640,480".  If I want to keep the leading zeros, I can use ="001234".  But if I want to keep both comma and leading zeros in the value, writing as ="001,002" will be splitted as two columns.  It seems no solution to express the correct data.  Is there any way to express 001, 002 in CSV for Excel?
80572
I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text".   When I save the Excel file to a text file in Unicode format, the text which contains the double quote is saved as three double quotes, for example """text""".  There are some places where I even have text which contains comma (,). For example, text, which is converted into "text," in the Unicode file. It is adding double quotes to the text, which I guess contains special characters.  How can I avoid this?