Linux·4,562 discussions

Change values from a dataset variable in Bash

Locked

Tags: Linux

Hi
I am new in Bash and I am trying to change the values of a column from the file data.csv coma delimitted.

In the dataset I have the variable sex with only 2 possible values ‘Female’ and ‘Male’ and I would like to transform Male into ‘m’ and Female into ‘f’. I have tried this:

#!/bin/bash
sex=$(cut -d , -f 5 data.csv) #I select column 5 related with the variable sex
for i in $sex; do
if [[$i=’Female’]]; then
$i=’f’
fin
done
The code is wrong and I do not know how to modify it.

Besides, I would like to update my data.csv with the new values in sex.

Topic

[kees_b]

Reply To: Change values from a dataset variable in Bash

In reply to Change values from a dataset variable in Bash

https://www.unix.com/shell-programming-and-scripting/234311-update-field-value-csv-file.html tells how to do it with awk.

awk is a tool (a script language) in unix/linux designed for text processing.

If all you want to do is to change it one time, use LibreOffice Calc. Only use a script if you want to do it repeatedly and automatic.

• This reply was modified 2 years, 4 months ago by kees_b.
• This reply was modified 2 years, 4 months ago by kees_b.

Reply To: Change values from a dataset variable in Bash

In reply to Change values from a dataset variable in Bash

# bash
while read line
do
line=${line/,Male,/,m,}
line=${line/,Female,/,f,}
echo $line
done < data.csv > output2.csv

# sed
sed ‘s/,Male,/,m,/; s/,Female,/,f,/’ data.csv > output3.csv

Regards,
TG

[Author]

Replies