Replace last value in row with 0

Daniel Holzmann

Hi,

I have a .csv file, which I need to zero out as part of our monthly process. The file has the following structure:

Year;MPC ID;Company;Unit;Costcode;Name;Headcount
2017;16699101;12000000;1001;1271120000;N. Jensen ;1
2017;16699201;12000000;1001;1271120000;N. Jensen ;1
2017;16699101;2009;5936;2010;A. Fevang ;1
2017;16699201;2009;5936;2010;A. Fevang ;1
2017;16699101;2009;4100;3050;L. Halstein ;1
2017;16699201;2009;4100;3050;L. Halstein ;1
2017;16699124;2009;4403;2260;K. Basalt ;1
2017;16699224;2009;4403;2260;K. Basalt ;1
2017;16699101;2009;92;9010;M. Kalsas ;1
2017;16699201;2009;92;9010;M. Kalsas ;1
2017;16699103;2009;3541;2100;B. Fonag ;0.5
2017;16699203;2009;3541;2100;B. Fonag ;1
2017;16699101;2009;4403;2260;S. Jørgensen ;0.35
2017;16699201;2009;4403;2260;S. Jørgensen ;1
2017;16699101;2009;4403;2260;K. Pedersen ;0.69
2017;16699201;2009;4403;2260;K. Pedersen ;1

Currently I copy/paste the content over to Excel where it’s easy for me to apply zeroes in the last column. However I would really like to process this within Notepad++. So how would I replace any ending value ‘;x’ with ‘;0’?

I have been trying to find relevant examples in the forum, however didn’t succeed to adapt similar solutions for my problem.

Thank you in advance

Scott Sumner

A regular expression replace will work for your situation:

Find-what box: [\d.]+$
Replace-with box: 0
Search mode: Regular expression

The rough English explanation of the parts of this is:
[\d.]: look for digit or period in any order
[\d.]+: look for one or more digits or periods in any order
[\d.]+$: look for one or more digits or periods in any order at the end of a line

Daniel Holzmann

That worked like a charm. Thanks a stack Scott. :)
And also thanks for elaborating. That’ll really help going onwards to getting more acquainted with these strings.