Perl script to add comma if...

[Ratzie]

Thanks to the many that help with my script I have know been able to get it to working order.

There is something that I still need to do with it...
Sometimes I may have a column with empty data. I need to insert a comma there. (For a deliminated file)
So after all is said and down the script produces this output...

5555642,00 0 00 18,CUSTOMER HAS
5555656,MATCHING CUTTELN
5555661,00 0 06 08,TELN NOT

I need to put an if statement after my script..
while (<>) {
chomp; # Will remove the leading , or new line
s,^\s+,,; #Remove leading spaces
my @cols=split m/\s{2,}/, $_, -1; # Split on two (or more) white space characters
print join (',',@cols)."\n";
}

That will, if 7digits (together), comma then characters, add a comma.

So the output will look like this...
5555642,00 0 00 18,CUSTOMER HAS
5555656,,MATCHING CUTTELN
5555642,00 0 00 18,CUSTOMER HAS

[Fred Ruffet]

If I really understand, your script ends with 3 fields lines and 2 fields lines. For these ones, you want to insert an empty field between one and two...

here it is (to put before print) :
@cols=($cols[0],"",$cols[1]) if $#cols=1;

regards,

Fred

[H.Merijn Brand (procura · Accepted solution]

Fred, better to write that using splice

@cols == 2 and splice @cols, 1, 0, "";


==>

while (<>) {
chomp; # Will remove the TRAILING optional new line
s/^\s+//; #Remove leading spaces
my @cols = split m/\s{2,}/, $_, -1; # Split on two (or more) white space characters
@cols == 2 and splice @cols, 1, 0, "";
print join (",", @cols), "\n";
}

Enjoy, Have FUN! H.Merijn

[Fred Ruffet]

Procura,

I never noticed that a 0 length in splice inserts elements... You are a living perldoc ! Are you eating a camel every morning for breakfast ? :)

Best regards,

Fred

[Ratzie]

Thanks