Question

3

Replace commas with colons and move all values to one line

rated 0 times [ 3] [ 0] / answers: 1 / hits: 3934 / 3 Years ago, sat, october 23, 2021, 7:52:49

I entered a list of number in Calc and saved it as CSV so that all the values on one line are separated by commas. I will describe what I'm seeking with bash in the following example:

INPUT

22,33

45,533

OUTPUT

22:33,45:533

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

calronze

Add To Favorites

Follow

Total Points: 0

Total Questions: 110

Total Answers: 112

Location: Belarus

Member since Thu, Aug 11, 2022

2 Years ago

calronze questions

1 Crash / reboot on boot with Ubuntu 22.04 and AMD RX5500

Sun, Jan 9, 22, 13:41, 2 Years ago

1 Is it possible to alias a command prefix for redirecting stdout?

Thu, Jun 30, 22, 20:03, 2 Years ago

1 dpkg error when trying to install ceph-deploy

Wed, Feb 15, 23, 01:41, 1 Year ago

1 Default sshd_config file for Ubunu 20.04

Sat, Jul 23, 22, 21:03, 2 Years ago

1 How to just gain root permission without running anything?

Sat, Feb 5, 22, 01:57, 2 Years ago

View All

answered 3 Years ago ndaavi · Accepted Answer

Not sure if I understand correctly, but for the input and output you shown, the following sed command can do the transformation, taking into account that your input file contains CR-LF line terminators:

sed 's/,/:/g;s/ /,/g' <<<$(tr -d '

' <input_file) | tee output_file.tmp

mv output_file.tmp input_file