Find Word in Column with replace

Shell Programming and Scripting
1

Hi ALL

i have file.txt with text :

4c:66:41:6b:b5:5f, 00:00,00:00, -22:-25, users1, 10.101.3.119, host1
4c:66:41:2c:c1:5a, 00:00,00:00, -21:-25, 10.101.3.112, host1
4c:66:41:6b:b1:5e, 00:00,00:00, -21:-25, users1, 10.101.3.113, host1
4c:66:41:2c:c1:5b, 00:00,00:00, -21:-25, 10.101.3.115, host1

The result should be:

4c:66:41:6b:b5:5f, 00:00,00:00, -22:-25, users1, 10.101.3.119, host1
4c:66:41:2c:c1:5a, 00:00,00:00, -21:-25, anony, 10.101.3.112, host1
4c:66:41:6b:b1:5a, 00:00,00:00, -21:-25, users1, 10.101.3.113, host1
4c:66:41:2c:c1:5b, 00:00,00:00, -21:-25, anony, 10.101.3.115, host1

Can't anybody help me?

Thanks,
DChristian

2

Try

awk -F, 'NF == 6 {$5 = " anony" OFS $5} 1' OFS="," file
4c:66:41:6b:b5:5f, 00:00,00:00, -22:-25, users1, 10.101.3.119, host1
4c:66:41:2c:c1:5a, 00:00,00:00, -21:-25, anony, 10.101.3.112, host1
4c:66:41:6b:b1:5e, 00:00,00:00, -21:-25, users1, 10.101.3.113, host1
4c:66:41:2c:c1:5b, 00:00,00:00, -21:-25, anony, 10.101.3.115, host1

If that doesn't satisfy your needs, please be way more specific when phrasing your requirement.

3

Thanks For Rudy..

for specific file :

4c:66:41:6b:b5:5f, 00:00,00:00, -22:-25, robert, 10.101.3.119, host1
4c:66:41:2c:c1:5a, 00:00,00:00, -21:-25, 10.101.3.112, host1
4c:66:41:6b:b1:5a, 00:00,00:00, -21:-25, Julia, 10.101.3.113, host1
4c:66:41:2c:c1:5b, 00:00,00:00, -21:-25, 10.101.3.115, host1
4c:66:41:6b:b1:5f, 00:00,00:00, -21:-25, Justin, 10.101.3.116, host1
4c:66:41:6b:b1:5c, 00:00,00:00, -21:-25, Fredy, 10.101.3.110, host1
4c:66:41:6b:b1:7a, 00:00,00:00, -21:-25, Josh, 10.101.3.123, host1

OUTPUT

4c:66:41:6b:b5:5f, 00:00,00:00, -22:-25, robert, 10.101.3.119, host1
4c:66:41:2c:c1:5a, 00:00,00:00, -21:-25, anony, 10.101.3.112, host1
4c:66:41:6b:b1:5a, 00:00,00:00, -21:-25, Julia, 10.101.3.113, host1
4c:66:41:2c:c1:5b, 00:00,00:00, -21:-25, anony, 10.101.3.115, host1
4c:66:41:6b:b1:5f, 00:00,00:00, -21:-25, Justin, 10.101.3.116, host1
4c:66:41:6b:b1:5c, 00:00,00:00, -21:-25, Fredy, 10.101.3.110, host1
4c:66:41:6b:b1:7a, 00:00,00:00, -21:-25, Josh, 10.101.3.123, host1

Help me please..

Thanks

4

Help you with what??? In what way did the code RudiC provided fail to produce the output you wanted?

What operating system are you using?

What shell are you using?

What command did you use (based on what RudiC suggested in post #2 in this thread)? (PLEASE show us the exact command you used in CODE tags!)

What output did that command produce? (Please show us the exact output that command produced in CODE tags!)