how do I change the field delimiter after the nth column

Question

I have a file with thousand of lines like below

32322621661395926569;adverline;www.societe.com_societe;identite;Salarie2;fiche;btp_et_construction;CA4 32322621661395926569;adverline;www.societe.com_societe;identite;Salarie2;fiche;energy;CA4;nunuc_muchemuche

The delimiter is done with ;. I'm trying to change the delimiter after the 4th column. So every semi-colon after identite will be changed to a ,.

I've tried that

awk '$4=$4' FS=";" OFS="," filename

but it is changing everything to a comma.

if you have any tips, I'm all ears.

Hi HuStmpHrrr, how? :)

Andy K
– Andy K

2014-12-22 14:33:08 +00:00
Commented Dec 22, 2014 at 14:33 — Andy K
– Andy K, Commented Dec 22, 2014 at 14:33

Steve · Accepted Answer · 2014-12-22 14:34:44Z

You can specify the occurrence using sed:

sed 's/;/,/4g' file

Results:

32322621661395926569;adverline;www.societe.com_societe;identite,Salarie2,fiche,btp_et_construction,CA4 32322621661395926569;adverline;www.societe.com_societe;identite,Salarie2,fiche,energy,CA4,nunuc_muchemuche

Jason Hu · Accepted Answer · 2014-12-22 14:37:41Z

this piece of perl code should work.

#!/usr/bin/perl open FH, $filename; # fill it in while (<FH>){ my @elems = split ';', $_; push @elems, join ',', splice @elems, 3, @elems - 3; print join ';', @elems; }

Collectives™ on Stack Overflow

how do I change the field delimiter after the nth column

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related