So, I would suggest you to use, for instance, the Tabulation character ( \t ) as a delimiter, A) The following regex S/R will add a dummy character ( ), non-existant in your file, at the end of any of these standard lines, B) The following regex S/R will replace any comma with a tabulation char, only if the line ends with the dummy char and will, also, delete the dummy character when all commas of the current line have been replaced. If it does not work it would be great to see data that was adversely affected before it was changed. Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. Browse other questions tagged, Start here for a quick overview of the site, Detailed answers to any questions you might have, Discuss the workings and policies of this site. I added the part \x20*, located outside the group3, to remove unnecessary blank chars, at end of last kept field \3, I also used lazy quantifiers +? The problems is that there are multilined cells. Generally speaking, I do this by pasting into excel, so I am not looking for a workaround but rather a quick way of getting a column wholly within notepad++. So when you replace, the entire row gets replaced with whatever you want. Based on that file, it turns out the problem is not malformed CSV. Setup: Use the plugin manager in Notepad++ to install the "Python script" plugin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |