I have a file with multiple lines/rows, and each line contains a variable amount of columns:
Name1 String111 String112
Name2 String121 String122 String123
Name3 String131 String132 String133 String134
And so on and so forth (no pattern as to what line has how many entries). I would like to add the name in the first column to the beginning of every column in that line/row such that I end up with:
Name1 Name1String111 Name1String112
Name2 Name2String121 Name2String122 Name2String123
Name3 Name3String131 Name3String132 Name3String133 Name3String134
We can start it simple and get more complicated:
How to add a string such as "Test" to the beginning of every column?
How to add the value in column 1 to every column in that row, including column 1?
How to add the value in column 1 to every column in that row, not including column 1?
My best guesses:
I do not know how to call "every column" and I do not know how to make the command access the currently column so I can only add a string or the value in column 1 to a single other column:
awk -F'\t' -vOFS='\t' '{ !$1 = "hello" $2}'
awk -F'\t' -vOFS='\t' '{ !$1 = $1 $2}'
Is there a good resource on where I can learn this syntax?