Using sed to remove digit separation commas enclosed in quotes and quotes itself from CSV? How can I can use sed to remove from before-last column the group digit char comma and quotes itself?  Please note that in the sample below the target column is not contained in double quotes.  0,1,,,"10,815,197", 6,7,010202,,"5,589", 6,7,010202,,589,   An expetect result would be:  0,1,,,10815197, 6,7,010202,,5589, 6,7,010202,,589,
Remove only the commas present within the double quotes In a text file, I want to remove , (commas) and also the " (quotes) (only if the double quotes  contains  numbers separated by commas).  56,72,"12,34,54",x,y,"foo,a,b,bar"   Expected ouput  56,72,123454,x,y,"foo,a,b,bar"   Note: I show the above line just as an example. My text file contains many lines like above and the numbers separated by commas present within the double quotes should vary. That is,  56,72,"12,34,54",x,y,"foo,a,b,bar" 56,92,"12,34",x,y,"foo,a,b,bar" 56,72,"12,34,54,78,76,54,67",x,y,"foo,a,b,bar" 56,72,x,y,"foo,a,b,bar","12,34,54" 56,72,x,y,"foo,a,b,bar","12,34,54","45,57,84,92","bar,foo"   Expected output:  56,72,123454,x,y,"foo,a,b,bar" 56,92,1234,x,y,"foo,a,b,bar" 56,72,12345478765467,x,y,"foo,a,b,bar" 56,72,x,y,"foo,a,b,bar",123454 56,72,x,y,"foo,a,b,bar",123454,45578492,"bar,foo"   There a n number of numbers present within the double quotes separated by commas. And also leave the double quotes which contains characters as it is.  I love sed text processing tool. I'm happy if you post any sed solution for this.
How can I make a .jar file executable? How to make a VGA monitor display a white screen at all time? This question is asked in various forms here but the question boils down to:  I know shrinking a database is risky. In this case, I've removed so much data and I'll never use it again.   How can I shrink my database? What files do I shrink?  What should my considerations be while doing this?  Should I do anything after? What if it is a large database? Can I shrink it in smaller increments? I'm a bit surprised from my US Visa. I plan to go to a conference on 3rd of April. Amazingly though, the visa expiration date is written as April 3rd.  So what does that mean. Can I enter the US on April 3rd? or should I enter one day earlier? Why draw blood from veins rather than arteries? Why draw blood from veins rather than arteries? Is it more convenient or safer? I'm writing a contribution for a double-blind submission system.   Since I would like to supply more data than I could show on a small number of pages, I'm looking for a way to reference supplemental data in my manuscript, such as software scripts, figures or databases.  I could upload on GitHub, RPubs, Figshare and Zenodo, but all of these would expose my real user name (and I don't feel like making a throwaway e-mail account with a new repository for every anonymous publication that I intend to write).  Is there any way to get the above services to do what I want? Or is there a similar service that would allow anonymous hosting of research data?   It would be even better if I could later (e.g. after publication) declassify the information, with the link from the manuscript still being intact. Is there any way to include an animated GIF directly? Is there any way to include an animated GIF directly in either PDFLaTeX or XeLaTeX? I realize the animate package can include animations in a PDF, but it doesn't support animated GIFs and you have to split them up manually into EPS or PNG files as far as I can tell. How to normalize data between -1 and 1? I have seen the min-max normalization formula but that normalizes values between 0 and 1. How would I normalize my data between -1 and 1? I have both negative and positive values in my data matrix. Updating a field programmatically, hook_node_update Say, for example, you have a card that is still legal in standard but the version you have of it comes from a set that has since been rotated out. Can you still play the version from your older set? Community FAQ For sites in the Stack Exchange 2.0 network To see a list of commonly used words and phrases, see the . For official guidance from Stack Exchange, visit the . Asking questions                            Answering questions                 Accepting answers        Working with posts  What does it mean when a question or answer is...  ?  ?  ?  ?                                       Comments             Etiquette                         Promotion         Editing and Formatting                                    Tagging                      Reputation, badges, and voting                                         Moderation                                                 Searching and RSS feeds        Accounts, registration and logging in                                     Other                                 ()                                 Site-specific entries Stack Overflow             Meta Stack Exchange       Other     External links           Is your question not part of the FAQ? First look at questions tagged  to see if there is a question not in this index that might have the answer you seek. If you still can't find an answer, then see the following instructions for proposing an FAQ question. How can a question be added to this FAQ?  Ask only the question, stated plainly and simply, in the question body. The answer goes in an answer.  Link back to this index. Paste this at the end of the question:  [Return to FAQ index](/q/7931)   Tag as  and .  When a post seems to have hit a mature state, it will have  added by a moderator.  Flag for a moderator to mark community wiki.  Any FAQ post not yet community wiki should be made into a community wiki.  After the post has the  tag added to it, add a link in the above . In 1735 Euler gave the value of $\gamma$ as $0.577218.$ The constant is generally defined as the limit of the difference between the harmonic series and $\log n:~\gamma= \lim_{n\to\infty}\sum_{k=1}^{n}\frac{1}{k}-\log n.$ Euler apparently relished this sort of calculation and must have taken quite a few terms to get such a good approximation.  My question is whether without a computer one can now prove that  $$\gamma &lt;  \sqrt{1/3}$$   with at least some savings in terms of the type of work Euler apparently expended? I don't think there's any point in raising the bar to $\gamma &lt; \ln 2\sqrt{\frac{23}{29}} $  because it seems to be the same sort of question.       My own thought was to compare $\frac{1}{2}\int_0^{1/3}\frac{dx}{\sqrt{x}}$ to something like $(-1)\cdot\int_0^\infty e^{-u}\ln u~du$ but I expect there's a better way. Is there a published way to take text that may have accent marks and remove the accent marks?  For example:  System.assertEquals('Hello', transform('Ḧéļḻṏ'));   I believe there is an equivalent method in Java, C# and JavaScript. I can't seem to find the Apex equivalent and I'm disturbed that I might have to do it on my own. After looking into the different OAuth types and reading , I'm still confused on the specific pros and cons of user-agent vs web server flows.  The best explanation I can find says that user-agent tends to be used for mobile but it seems that they can both be used for desktop.   What makes it more appropriate to use one over the other in certain scenarios? Find the value of $y(1)$ of the ODE $y'+y=|x|$. Let $y$ be the solution of $$y'+y=|x|$$ for $x\in\mathbb{R}$ and $y(-1)=0$. Then the value of $y(1)$ is    $\frac{2}{e}-\frac{2}{e^2}$ $\frac{2}{e}-2e^2$ $2-\frac{2}{e}$ $2-2e$   I don't know what to do with the absolute value function in this problem. So I started like the regular first order equation by calculating integrating factor, and got $$ye^x=\int |x|e^x dx+C.$$ Now I got stuck as how to tackle the absolute value function? Help me to solve this. Thanks! If I had a very shallow question, then I am sorry. $x,y,z\in\mathbb{N}^{+}$ and$$\frac{x}{y+z}+\frac{y}{x+z}+\frac{z}{y+x}=4$$find $x,y,z$.  I try with AM-GM, just get$$ \frac{x}{y+z}+\frac{y}{x+z}+\frac{z}{y+x}\geq\frac{3}{2}$$  This means that the equation must have a real solution, but can not be sure there is an integer solution.  Let: $x=ay=abz$, then the equation becomes:$$\frac{ab}{a+b}+\frac{b}{ab+1}+\frac{1}{a^2+ab}=4$$  Which makes the problem become non-homogeneous, and seems to become more difficult. I have no more ideas. Could anyone help me? Thanks a lot. Can more than one antibody bind the same antigen I'd like to clear something up about antibodies that I'm not sure I've understood in the articles I've read. Looking at concepts such as "affinity maturation", "monovalent antigens" and "polyvalent antigens" it seems as if there are multiple antibodies which can bind to the same antigen. (Although I think I'm right in saying that individual antibodies can only bind to one antigen?) However, when I read sentences like "It has been estimated that humans generate about 10 billion different antibodies, each capable of binding a distinct epitope of an antigen" on the Wikipedia page (for antibody) it does make it sound like it's one antibody per antigen? Is this the case? Or is it one antibody per epitope. Either way, to put this question in a nutshell:  Is it true to say that the same substance could bind with (and, therefore, be recognised by) more than one antibody, or not?  Also, if the answer is no, does that mean that antibodies with different binding affinities are classed as the same antibody or not? Objects disappear when looking through camera I want to save a backup of my data on a remote server, but never want the backup server to see the data unencrypted. Editing a single file and backing up should not result in everything being encrypted and sent again. The remote server should preferably not even know the directory structure (and especially not the directory names).  Is there such a solution? What is the name of a squircle with three, five, six or more corners? I know that the second shape is a squircle, but what are the other shapes called? Is there an actual name for them?    The shapes do not simply have rounded corners, but the sides have a "circularity". Here is a triangle with rounded corners next to the shape that I do not know the name of:    "Trircle", "Triarcle", and "Pentircle" do not seem to be used for them, at least Google's image search does not provide any results.