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 302780599 by ajayram_arya on Thursday 14th of March 2013 06:27:56 PM
Old 03-14-2013
Try this

Code:
bash-3.00$ cat sample.txt|awk '{print $1"\t"$2'}|tr "\t" ","
-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

Last edited by Scrutinizer; 03-15-2013 at 01:08 AM.. Reason: code tags
 

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_koi8-r

iconv_koi8-r(5)                                         Standards, Environments, and Macros                                        iconv_koi8-r(5)

NAME

       iconv_koi8-r - code set conversion tables for KOI8-R

DESCRIPTION

       The following code set conversions are supported:

       +-------------------------------------------------------------------------+
       |                     Code Set Conversions Supported                      |
       +--------------+--------+--------------+--------+-------------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |      Target Output      |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic     |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |PC Cyrillic   |alt     | Alternative PC Cyrillic |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |MS 1251       |win5    | Windows Cyrillic        |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |Mac Cyrillic  |mac     | Macintosh Cyrillic      |
       +--------------+--------+--------------+--------+-------------------------+

CONVERSIONS

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

   KOI8-R to ISO 8859-5
       For the conversion of KOI8-R to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |  ISO 8859-5    |    KOI8-R      |  ISO 8859-5   |
       |24             | 4              |320             |337            |
       |241            | 362            |321             |357            |
       |242            | 363            |322             |340            |
       |243            | 361            |323             |341            |
       |244            | 364            |324             |342            |
       |245            | 365            |325             |343            |
       |246            | 366            |327             |322            |
       |247            | 367            |330             |354            |
       |250            | 370            |331             |353            |
       |251            | 371            |332             |327            |
       |252            | 372            |333             |350            |
       |253            | 373            |334             |355            |
       |254            | 374            |335             |351            |
       |256            | 376            |336             |347            |
       |257            | 377            |337             |352            |
       |260            | 360            |340             |316            |
       |261            | 242            |341             |260            |
       |262            | 243            |342             |261            |
       |263            | 241            |343             |306            |
       |264            | 244            |344             |264            |
       |265            | 245            |345             |265            |
       |266            | 246            |346             |304            |
       |267            | 247            |347             |263            |
       |270            | 250            |350             |305            |
       |271            | 251            |351             |270            |
       |272            | 252            |352             |271            |
       |273            | 253            |353             |272            |
       |274            | 254            |354             |273            |
       |275            | 255            |355             |274            |
       |276            | 256            |356             |275            |
       |277            | 257            |357             |276            |
       |300            | 356            |360             |277            |
       |301            | 320            |361             |317            |
       |302            | 321            |362             |300            |
       |303            | 346            |363             |301            |
       |304            | 324            |364             |302            |
       |305            | 325            |365             |303            |
       |306            | 344            |366             |266            |
       |307            | 323            |367             |262            |
       |310            | 345            |370             |314            |
       |311            | 330            |371             |313            |
       |312            | 331            |372             |267            |
       |313            | 332            |373             |310            |
       |314            | 333            |374             |315            |
       |315            | 334            |375             |311            |
       |316            | 335            |376             |307            |
       |317            | 336            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to PC Cyrillic
       For the conversion of KOI8-R to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |  PC Cyrillic   |    KOI8-R      | PC Cyrillic   |
       |24             | 4              |333             |350            |
       |200-242        | 40             |334             |355            |
       |243            | 361            |335             |351            |
       |244-254        | 40             |336             |347            |
       |255            | 260            |337             |352            |
       |256-262        | 40             |340             |236            |
       |263            | 360            |341             |200            |
       |264-274        | 40             |342             |201            |
       |275            | 260            |343             |226            |
       |276-277        | 40             |344             |204            |
       |300            | 356            |345             |205            |
       |301            | 240            |346             |224            |
       |302            | 241            |347             |203            |
       |303            | 346            |350             |225            |
       |304            | 244            |351             |210            |
       |305            | 245            |352             |211            |
       |306            | 344            |353             |212            |
       |307            | 243            |354             |213            |
       |310            | 345            |355             |214            |
       |311            | 250            |356             |215            |
       |312            | 251            |357             |216            |
       |313            | 252            |360             |217            |
       |314            | 253            |361             |237            |
       |315            | 254            |362             |220            |
       |316            | 255            |363             |221            |
       |317            | 256            |364             |222            |
       |320            | 257            |365             |223            |
       |321            | 357            |366             |206            |
       |322            | 340            |367             |202            |
       |323            | 341            |370             |234            |
       |324            | 342            |371             |233            |
       |325            | 343            |372             |207            |
       |326            | 246            |373             |230            |
       |327            | 242            |374             |235            |
       |330            | 354            |375             |231            |
       |331            | 353            |376             |227            |
       |332            | 247            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to MS 1251
       For the conversion of KOI8-R to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |    MS 1251     |    KOI8-R      |   MS 1251     |
       |24             | 4              |317             |356            |
       |200-237        | 40             |320             |357            |
       |241            | 220            |321             |377            |
       |242            | 203            |322             |360            |
       |243            | 270            |323             |361            |
       |244            | 272            |324             |362            |
       |245            | 276            |325             |363            |
       |246            | 263            |326             |346            |
       |247            | 277            |327             |342            |
       |250            | 274            |330             |374            |
       |251            | 232            |331             |373            |
       |252            | 234            |332             |347            |
       |253            | 236            |333             |370            |
       |254            | 235            |334             |375            |
       |255            | 210            |335             |371            |
       |256            | 242            |336             |367            |
       |257            | 237            |337             |372            |
       |260            | 271            |340             |336            |
       |261            | 200            |341             |300            |
       |262            | 201            |342             |301            |
       |263            | 250            |343             |326            |
       |264            | 252            |344             |304            |
       |265            | 275            |345             |305            |
       |266            | 262            |346             |324            |
       |267            | 257            |347             |303            |
       |270            | 243            |350             |325            |
       |271            | 212            |351             |310            |
       |272            | 214            |352             |311            |
       |273            | 216            |353             |312            |
       |274            | 215            |354             |313            |
       |275            | 210            |355             |314            |
       |276            | 241            |356             |315            |
       |277            | 217            |357             |316            |
       |300            | 376            |360             |317            |
       |301            | 340            |361             |337            |
       |302            | 341            |362             |320            |
       |303            | 366            |363             |321            |
       |304            | 344            |364             |322            |
       |305            | 345            |365             |323            |
       |306            | 364            |366             |306            |
       |307            | 343            |367             |302            |
       |310            | 365            |370             |334            |
       |311            | 350            |371             |333            |
       |312            | 351            |372             |307            |
       |313            | 352            |373             |330            |
       |314            | 353            |374             |335            |
       |315            | 354            |375             |331            |
       |316            | 355            |376             |327            |
       |376            | 227            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to Mac Cyrillic
       For the conversion of KOI8-R to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     | Mac Cyrillic   |    KOI8-R      | Mac Cyrillic  |
       |24             | 4              |317             |356            |
       |200-237        | 40             |320             |357            |
       |240            | 312            |321             |337            |
       |241            | 254            |322             |360            |
       |242            | 257            |323             |361            |
       |243            | 336            |324             |362            |
       |244            | 271            |325             |363            |
       |245            | 317            |326             |346            |
       |246            | 264            |327             |342            |
       |247            | 273            |330             |374            |
       |250            | 300            |331             |373            |
       |251            | 275            |332             |347            |
       |252            | 277            |333             |370            |
       |253            | 40             |334             |375            |
       |254            | 316            |335             |371            |
       |255            | 40             |336             |367            |
       |256            | 331            |337             |372            |
       |257            | 333            |340             |236            |
       |260            | 334            |341             |200            |
       |261            | 253            |342             |201            |
       |262            | 256            |343             |226            |
       |263            | 335            |344             |204            |
       |264            | 270            |345             |205            |
       |265            | 301            |346             |224            |
       |266            | 247            |347             |203            |
       |267            | 272            |350             |225            |
       |270            | 267            |351             |210            |
       |271            | 274            |352             |211            |
       |272            | 276            |353             |212            |
       |273            | 40             |354             |213            |
       |274            | 315            |355             |214            |
       |275            | 40             |356             |215            |
       |276            | 330            |357             |216            |
       |277            | 332            |360             |217            |
       |300            | 376            |361             |237            |
       |301            | 340            |362             |220            |
       |302            | 341            |363             |221            |
       |303            | 366            |364             |222            |
       |304            | 344            |365             |223            |
       |305            | 345            |366             |206            |
       |306            | 364            |367             |202            |
       |307            | 343            |370             |234            |
       |310            | 365            |371             |233            |
       |311            | 350            |372             |207            |
       |312            | 351            |373             |230            |
       |313            | 352            |374             |235            |
       |314            | 353            |375             |231            |
       |315            | 354            |376             |227            |
       |316            | 355            |                |               |
       +---------------+----------------+----------------+---------------+

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                                                          18 Apr 1997                                                    iconv_koi8-r(5)
All times are GMT -4. The time now is 02:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy