'shell / bash script - Add value to a single filtered row in csv - awk / sed

sorry my english. Im working with a script for the onboarding process for new employees, something like a "zero-touch" and im facing some issues manipulating a csv with shell bash script.

Sample of my input csv tmp.csv:

SN,HOSTNAME,OWNER,MODEL,USER
C02G1,,[email protected],MacBook Pro,
C02G71X,HOSTNAME0001,[email protected],MacBook Pro,
FVFGH0S,,[email protected],MacBook Pro,
PC24Q,,[email protected],Macbook Air,

Desired output (could be a new file or editing the input file):

SN,HOSTNAME,OWNER,MODEL,USER
C02G1,,[email protected],MacBook Pro,
C02G71X,HOSTNAME0001,[email protected],MacBook Pro,username
FVFGH0S,,[email protected],MacBook Pro,
PC24Q,,[email protected],Macbook Air,

My script :

#!/bin/sh
# Get the current device's serial number
SERIAL=$(system_profiler SPHardwareDataType | awk '/Serial/ {print $4}')
# File name
tmpFile=$'tmp.csv'

# Download the CSV from Google Drive, file must be set to Shared With Anyone with Link (or Shared with Anyone)
curl -L -o $tmpFile 'https://docs.google.com/spreadsheets/d/XXXXXXXX/export?format=csv'

# Delete unwanted characters
sed -i'BAK' "s/$(printf '\r')\$//" $tmpFile

# Get username MAC
user=$(id -un)

while IFS=, read -r SN HOSTNAME OWNER MODEL USER
    do
      if [ "$SN" == "$SERIAL" ]
        then            
            hostname=$HOSTNAME
            awk -F, -v old="$USER" -v new="$user" '{gsub(old,new,$5);print $0}' $tmpFile > tmp3.csv
            fi
done < $tmpFile

sudo scutil --set HostName $hostname
sudo scutil --set LocalHostName $hostname
sudo scutil --set ComputerName $hostname
dscacheutil -flushcache

etc etc etc......

Output with my script:

SN,HOSTNAME,OWNER,MODEL,USER
C02G1,,[email protected],MacBook Pro,username
C02G71X,HOSTNAME0001,[email protected],MacBook Pro,username
FVFGH0S,,[email protected],MacBook Pro,username
PC24Q,,[email protected],Macbook Air,username

SUMMARY: So what i need is to add $user on the column USER of the csv only in the row that matches SN with $SERIAL

THANKS IN ADVANCE, if someone feels that this code may help i could send it when I finished it!

bashshellcsvsearchawk


Solution 1:[1]

First, I don't know how you got the output with , as separators. I have to explicitly set it, otherwise awk is using space.

But back to the question, you can use two rules:

  • one that matches the row and updates 5th field,
  • another that matches everything and prints the whole line
$1 == sn { $5 = user }
{ print $0 }

In the script it will look like this:

#!/usr/bin/env bash

SN_TO_MATCH="C02G71X"
USER_TO_ADD="foobar"

awk -F, -v OFS=, -v sn="${SN_TO_MATCH}" -v user="${USER_TO_ADD}" '$1==sn {$5=user} {print $0}' tmp.csv

The output:

SN,HOSTNAME,OWNER,MODEL,USER
C02G1,,[email protected],MacBook Pro,
C02G71X,HOSTNAME0001,[email protected],MacBook Pro,foobar
FVFGH0S,,[email protected],MacBook Pro,
PC24Q,,[email protected],Macbook Air,

Solution 2:[2]

It's not awk, but it could useful for you. I'm using Miller

It' a simplified example

#!/bin/bash

serial="C02G71X"
user="tom"

mlr --csv put 'if($SN=="'"$serial"'"){$USER="'"$user"'"} then {$USER=""}' input.csv >output.csv

+---------+--------------+---------------+-------------+------+
| SN      | HOSTNAME     | OWNER         | MODEL       | USER |
+---------+--------------+---------------+-------------+------+
| C02G1   |              | [email protected]    | MacBook Pro |      |
| C02G71X | HOSTNAME0001 | [email protected]  | MacBook Pro | tom  |
| FVFGH0S |              | [email protected] | MacBook Pro |      |
| PC24Q   |              | [email protected]   | Macbook Air |      |
+---------+--------------+---------------+-------------+------+

that gives to you

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 danadam
Solution 2

Related Questions