Shell Programming and Scripting

Hello,

Beginning with shell scipting, I'm trying to find in a csv file, the lines where the field related to hostname is displayed as an FQDN intead the hostname. (some lines are correct) and the to correct that inside the file:

Code:

Novell,11.0,UNIX Server,bscpsiws02,TxffnX1tX1HiDoyBerrzWA==
Red Hat,4.8,,UNIX Server,bscpspas01.bsc.erp,5V2jxrVm09yIU5xgD86RKQ==

using 2 awk with a pipe, I can retrieve the 4th field sparated by comma, and then inside it the first filed separated by the dot.

But how to pass it to Sed to edit the CSV?

Moderator's Comments:

Please use code tags next time for your code and data.

Assuming that you mean that you want to change bscpspas01.bsc.erp in the 2nd line of your sample input to bscpspas01 it would be easy to do using:

Code:

awk -F, '$5 ~ /[.]/ {$5 = substr($5, 1, index($5, ".") - 1)}1' OFS="," in

But note that you said you wanted to change an FQDN in field 4 to just the hostname. It looks like you have a hostname in field 4 in the 1st line of your input, but bscpspas01.bsc.erp appears in field 5 in the 2nd line of your input.

Do you want this processing on fields 4 and 5?

Does one of your input lines have an extra comma?

Is one of your lines missing a comma?

Hi Don,

You where right... 2 times!

Your solution if 100 % effective, thanks!
and yes I did a mistake in my example... I trunked a much wide .original csv (around 45 fields for my example, with the host at the 30th position instead of fifth... and did it too quickly (just before leaving my work). My apologizes.

Kind Regards

Cedric