Change number in last row in data seperated with commas in NotePad++

Posted by user329311 on Super User See other posts from Super User or by user329311
Published on 2014-06-04T12:56:37Z Indexed on 2014/06/04 15:31 UTC
Read the original article Hit count: 193

Filed under:

notepad++

|

regex

|

csv

I have rows of data all separated with commas. How can I replace the last numbers after the last commas with the number 5 in NotePad++?

For example: How do I replace 9, 17 and 124 with 5 in the below data? I have millions of rows though of data and Excel doesn't have enough rows for all the data.

Sample data:

2009.10.21,05:31,1.49312,1.49312,1.49306,1.49306,9
2009.10.21,05:32,1.49306,1.49308,1.49303,1.49305,17
2009.10.21,05:33,1.49305,1.4931,1.49305,1.49309,124

Thank you for your help.

© Super User or respective owner

Related posts about notepad++

How to make Notepad++ take over from the standard notepad.exe

as seen on Super User - Search for 'Super User'
I could do this easily with TextPad, then I got irritated with Textpad once I'd played with Notepad++. Now that I've removed Textpad: I want Notepad++ to take over the right-click Edit option in Explorer, and I want Notepad++ to come up when I type notepad in the command prompt. I know that… >>> More
Open text file in notepad/notepad++ based on size

as seen on Super User - Search for 'Super User'
Hi, When i double click a text document, if that text file is more than 1MB(or some specified size) I want that text file to be opened in Notepad++ while the files that are smaller should be opened in notepad itself. Is there any way i can achieve this.? Thanks >>> More
Notepad++ doesn't launch (notepad++.exe present in the task manager)

as seen on Super User - Search for 'Super User'
Yesterday Notepad++ was runnable, but today it doesn't. In spite of the notepad++.exe (with its 13 process) presence is the tasks manager, Notepad++ window doesn't launch. I tried to uninstall and re-install the sofware (and the first launch works), notepad.exe is present in C:\Windows and C:\Windows\Sytem32… >>> More
EOL in Notepad++ and Notepad

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Notepad++ to create some text file, but I noticed when the generated file is opened in Windows Notepad, the file contents get mal-formated due to the fact that Notepad++ use LF and EOL character, while Notepad expects CR + LF. Is there any way to change this behavior in Notepad++?? >>> More
Useful utilities - PFE, Notepad++ and XML Notepad 2007

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
All three editors are free to download and use! PFE http://www.lancs.ac.uk/staff/steveb/cpaap/pfe XML Notepad 2007 http://www.microsoft.com/downloads/details.aspx?familyid=72d6aa49-787d-4118-ba5f-4f30fe913628&displaylang=en Notepad++ http://notepad-plus.sourceforge.net/uk/download… >>> More

Related posts about regex

Find multiple regex in each line and skip result if one of the regex doesn't match

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a list of variables: variables = ['VariableA', 'VariableB','VariableC'] which I'm going to search for, line by line ifile = open("temp.txt",'r') d = {} match = zeros(len(variables)) for line in ifile: emptyCells=0 for i in range(len(variables)): regex = r'('+variables[i]+r')[:|=|\(](-… >>> More
OWASP Regex Repository: Is this regex correct?

as seen on Stack Overflow - Search for 'Stack Overflow'
I was looking at the regular expression for validating various data types from the (OWASP Regex Repository). One of the regular expressions in there is called safetext and looks like: ^[a-zA-Z0-9\s.\-]+$ My first question is: Is this regular expression correct? complementary question If this… >>> More
Make a Perl-style regex interpreter behave like a basic or extended regex interpreter

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing a tool to help students learn regular expressions. I will probably be writing it in Java. The idea is this: the student types in a regular expression and the tool shows which parts of a text will get matched by the regex. Simple enough. But I want to support several different regex… >>> More
JS regex isn't matching, even thought it works with a regex tester

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a piece of client-side javascript code that takes a function and finds the derivative of it, however, the regex that's supposed to match with the power rule fails to work in the context of the javascript program, even though it sucessfully matches when it's used with an independent regex… >>> More
c# RegEx with "|"

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to be able to check for a pattern with | in them. For example an expression like d*|*t should return true for a string like "dtest|test". I'm no regex hero so I just tried a couple of things, like: Regex Pattern = new Regex("s*\|*d"); //unable to build because of single backslash Regex Pattern… >>> More