Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to replace two or more spaces with one comma?
Top Forums UNIX for Dummies Questions & Answers How to replace two or more spaces with one comma? Post 302780589 by Scottie1954 on Thursday 14th of March 2013 06:16:50 PM
Old 03-14-2013
How to replace two or more spaces with one comma?
I'm using sh on hp-ux. I've got a file that looks like this.

Code:
-5.65   175
-16.17  160
-13.57  270
-51.72  260
-8.30   360
-42.71  460
-.38    375
-.20    375
-4.15   170
-21.53  560
-18.84  360

I'd like to replace all the whitespace between the columns with one comma. I can't seem to get the awk, sed, and tr examples I've found to handle the repeating spaces very well.

Thank you!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace , (comma) with space

Hi, what is the better way to replace the , (comma) with a space char? Example:STRING=dir1,dir2,dir3 toSTRING=dir1 dir2 dir3 And.. how to find if in the string there is a comma? Thanks :) (6 Replies)
Discussion started by: mbarberis
6 Replies

2. Shell Programming and Scripting

replace comma(,) with Tab

hi all, i have a file with commas(,). i want to replace all the commas with tab(\t). Plz help...its urgent... (3 Replies)
Discussion started by: vikas_kesarwani
3 Replies

3. Shell Programming and Scripting

Replace comma with newline

Hi, for some reason I cant seem to figure this out. I have a file which looks something like this word word word word word,word,word word word word,word,word,word,word word word Basically I want this whole thing to be a list with 1 word on each line like this... word word word... (1 Reply)
Discussion started by: eltinator
1 Replies

4. Shell Programming and Scripting

How to Use Sed Command to replace white spaces with comma from between two fields - Mayank

SHELL SCRIPT Hi I have a file in the following format Mayank Sushant Dheeraj Kunal ARUN Samir How can i replace the white space in between and replace them with a comma?? The resultant output should be Mayank,Sushant Dheeraj,Kunal ARUN,Samir i tried using sed -e... (8 Replies)
Discussion started by: mayanksargoch
8 Replies

5. Shell Programming and Scripting

Replace the | with Comma

Hi, The input file structure is given below: The Col1 and Col2 will be there always. But from Col3 there can be more columns. And Col3 will be always Col4 and Col5 will always be with Col6. I need to replace the | with comma. There are scnearios where there wont be no data.Below, the row 2... (6 Replies)
Discussion started by: bharathappriyan
6 Replies

6. Shell Programming and Scripting

Replace newline with comma.

I have output from a file like this: 15,01,11,14:06 235 I would like to change this to: 15,01,11,14:06,235 Removing newline and change to "," I now this can be done with tr cat OUT | tr '\n' ','' My problem is that tr is not implemented in this shell. sed is, show it should be... (7 Replies)
Discussion started by: Jotne
7 Replies

7. UNIX for Dummies Questions & Answers

Need help removing leading spaces from one field in comma seperated file

Using awk or sed, I'd like to remove leading spaces after a comma and before a right justified number in field 6. Sounds simple but I can't find a solution. Each field's formatting must stay intact. Input: 40,123456-02,160,05/24/2012,02/13/1977, 10699.15,0 Output:... (5 Replies)
Discussion started by: Scottie1954
5 Replies

8. Shell Programming and Scripting

How to replace NewLine with comma using sed?

Hi , I have a huge file with following records and I want to replace the last comma with ',NULL'. I try using SED but could not create a correct script . In my opinion I need a script which can convert ,/n with ,NULL/n 1,CHANGE_MEMBER,2010-12-28 00:05:00, 2,CHANGE_MEMBER,2012-09-02... (8 Replies)
Discussion started by: Ajaypal
8 Replies

9. Shell Programming and Scripting

Replace comma and blank with comma and number

I, I have a file and i need to replace comma and blank space with comma and 0. cat file.txt a,5 b,1 c, d, e,4 I need the output as cat file.txt a,5 b,1 c,0 d,0 (4 Replies)
Discussion started by: jaituteja
4 Replies

10. Shell Programming and Scripting

Replace spaces with underscores up to first comma but not after the comma

I have a comma delimited file of major codes and descriptions. I want to replace all occurrences of spaces with underscores up to the first comma (only in the first field), but not replace spaces following the comma. For instance I have the following snippet of the file: EK ED,Elementary and... (7 Replies)
Discussion started by: tdouty
7 Replies

LEARN ABOUT OPENSOLARIS

iconv_646

iconv_646(5)                                            Standards, Environments, and Macros                                           iconv_646(5)

NAME

       iconv_646 - code set conversion tables for ISO 646

DESCRIPTION

       The following code set conversions are supported:

       +-----------------------------------------------------------------------+
       |                    Code Set Conversions Supported                     |
       +----------+---------------+--------------+--------+--------------------+
       |  Code    |    Symbol     |Target Code   |Symbol  |   Target Output    |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646   | 646           |ISO 8859-1    |8859    |US ASCII            |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646de | 646de         |ISO 8859-1    |8859    |German              |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646da | 646da         |ISO 8859-1    |8859    |Danish              |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646en | 646en         |ISO 8859-1    |8859    |English ASCII       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646es | 646es         |ISO 8859-1    |8859    |Spanish             |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646fr | 646fr         |ISO 8859-1    |8859    |French              |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646it | 646it         |ISO 8859-1    |8859    |Italian             |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646sv | 646sv         |ISO 8859-1    |8859    |Swedish             |
       +----------+---------------+--------------+--------+--------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   ISO 646 (US ASCII) to ISO 8859-1
       For the conversion of ISO 646 to ISO 8859-1, all characters in ISO 646 can be mapped unchanged to ISO 8859-1

   ISO 646de (GERMAN) to ISO 8859-1
       For the conversion of ISO 646de to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 646de    |  ISO 8859-1    |  ISO 646de     |  ISO 8859-1   |
       |100            | 247            |173             |344            |
       |133            | 304            |174             |366            |
       |134            | 326            |175             |374            |
       |135            | 334            |176             |337            |
       +---------------+----------------+----------------+---------------+

   ISO 646da (DANISH) to ISO 8859-1
       For the conversion of ISO 646da  to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 646da    |  ISO 8859-1    |  ISO 646da     |  ISO 8859-1   |
       |133            | 306            |173             |346            |
       |134            | 330            |174             |370            |
       |135            | 305            |175             |345            |
       +---------------+----------------+----------------+---------------+

   ISO 646en (ENGLISH ASCII) to ISO 8859-1
       For the conversion of ISO 646en to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------+
       |                  Conversions|Performed                    |
       |         ISO 646en           |         ISO 8859-1          |
       |043                          |243                          |
       +-----------------------------+-----------------------------+

   ISO 646es (SPANISH) to ISO 8859-1
       For the conversion of ISO 646es to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 646es    |  ISO 8859-1    |  ISO 646es     |  ISO 8859-1   |
       |100            | 247            |173             |260            |
       |133            | 241            |174             |361            |
       |134            | 321            |175             |347            |
       |135            | 277            |                |               |
       +---------------+----------------+----------------+---------------+

   ISO 646fr (FRENCH) to ISO 8859-1
       For the conversion of ISO 646fr to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 646fr    |  ISO 8859-1    |  ISO 646fr     |  ISO 8859-1   |
       |043            | 243            |173             |351            |
       |100            | 340            |174             |371            |
       |133            | 260            |175             |350            |
       |134            | 347            |176             |250            |
       |135            | 247            |                |               |
       +---------------+----------------+----------------+---------------+

   ISO 646it (ITALIAN) to ISO 8859-1
       For the conversion of ISO 646it to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 646it    |  ISO 8859-1    |  ISO 646it     |  ISO 8859-1   |
       |043            | 243            |140             |371            |
       |100            | 247            |173             |340            |
       |133            | 260            |174             |362            |
       |134            | 347            |175             |350            |
       |135            | 351            |176             |354            |
       +---------------+----------------+----------------+---------------+

   ISO 646sv (SWEDISH) to ISO 8859-1
       For the conversion of ISO 646sv to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 646sv    |  ISO 8859-1    |  ISO 646sv     |  ISO 8859-1   |
       |100            | 311            |140             |351            |
       |133            | 304            |173             |344            |
       |134            | 326            |174             |366            |
       |135            | 305            |175             |345            |
       |136            | 334            |176             |374            |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so             conversion modules

       /usr/lib/iconv/*.t              conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10                                                          28 Apr 1997                                                       iconv_646(5)
All times are GMT -4. The time now is 05:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy