errecord.blogg.se - Notepad++ regex find nth

LIST: in this case the "LIST" has only a single element, a string containing the values of fields -4 and -3 joined by a comma.

splice -4, 2, ARRAY: perl's default array when used with -F or -a options, similar to awk's $1, $2, $3 field numbers. There are several forms for using it, but the form I'm using here is: splice ARRAY,OFFSET,LENGTH,LIST Splice is perl's built-in general purpose array manipulation function.

Then it prints the entire array with semi-colons as the field separator. Then it replaces the fourth-last and third-last fields with a single string containing the values of both fields separated by a comma. This splits the line into the array, using as the separator.

$ perl -F' ' -lane 'splice print input.csv Sed is good when you're working with entire lines, but awk and perl are better when you need to work with fields/columns within a line.