From ca8ba7959d45bd654c93e03648626f47d4ae8f57 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Thu, 26 Aug 2021 15:50:25 +0200 Subject: [PATCH] remote cl/lf from values --- get.pl | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/get.pl b/get.pl index 54f9994..1197f2f 100755 --- a/get.pl +++ b/get.pl @@ -31,7 +31,9 @@ while(<>) { foreach my $item ( @{ $json->{items} } ) { warn "## item = ",dump( $item ); foreach my $col ( @columns ) { - push @$row, $item->{$col}; + my $d = $item->{$col}; + $d =~ s/[\r\n\s]+/ /gs; + push @$row, $d; } } -- 2.20.1