Change number in last row in data seperated with commas in NotePad++
- by user329311
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.