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_mac_cyr

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

NAME

       iconv_mac_cyr - code set conversion tables for Macintosh Cyrillic

DESCRIPTION

       The following code set conversions are supported:

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

CONVERSIONS

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

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

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

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

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

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

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | Mac Cyrillic  |  PC Cyrillic   | Mac Cyrillic   | PC Cyrillic   |
       |24             | 4              |355             |255            |
       |240-334        | 40             |356             |256            |
       |335            | 360            |357             |257            |
       |336            | 361            |360             |340            |
       |337            | 357            |361             |341            |
       |340            | 240            |362             |342            |
       |341            | 241            |363             |343            |
       |342            | 242            |364             |344            |
       |343            | 243            |365             |345            |
       |344            | 244            |366             |346            |
       |345            | 245            |367             |347            |
       |346            | 246            |370             |350            |
       |347            | 247            |371             |351            |
       |350            | 250            |372             |352            |
       |351            | 251            |373             |353            |
       |352            | 252            |374             |354            |
       |353            | 253            |375             |355            |
       |354            | 254            |376             |356            |
       |303            | 366            |                |               |
       +---------------+----------------+----------------+---------------+

   Mac Cyrillic to MS 1251
       For the conversion of Mac Cyrillic to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | Mac Cyrillic  |    MS 1251     | Mac Cyrillic   |   MS 1251     |
       |24             | 4              |255             |40             |
       |200            | 300            |256             |201            |
       |201            | 301            |257             |203            |
       |202            | 302            |260-263         |40             |
       |203            | 303            |264             |263            |
       |204            | 304            |266             |264            |
       |205            | 305            |267             |243            |
       |206            | 306            |270             |252            |
       |207            | 307            |271             |272            |
       |210            | 310            |272             |257            |
       |211            | 311            |273             |277            |
       |212            | 312            |274             |212            |
       |213            | 313            |275             |232            |
       |214            | 314            |276             |214            |
       |215            | 315            |277             |234            |
       |216            | 316            |300             |274            |
       |217            | 317            |301             |275            |
       |220            | 320            |302             |254            |
       |221            | 321            |303-306         |40             |
       |222            | 322            |307             |253            |
       |223            | 323            |310             |273            |
       |224            | 324            |311             |205            |
       |225            | 325            |312             |240            |
       |226            | 326            |313             |200            |
       |227            | 327            |314             |220            |
       |230            | 330            |315             |215            |
       |231            | 331            |316             |235            |
       |232            | 332            |317             |276            |
       |233            | 333            |320             |226            |
       |234            | 334            |321             |227            |
       |235            | 335            |322             |223            |
       |236            | 336            |323             |224            |
       |237            | 337            |324             |221            |
       |240            | 206            |325             |222            |
       |241            | 260            |326             |40             |
       |242            | 245            |327             |204            |
       |243            | 40             |330             |241            |
       |244            | 247            |331             |242            |
       |245            | 267            |332             |217            |
       |246            | 266            |333             |237            |
       |247            | 262            |334             |271            |
       |250            | 256            |335             |250            |
       |252            | 231            |336             |270            |
       |253            | 200            |337             |377            |
       |254            | 220            |362             |324            |
       +---------------+----------------+----------------+---------------+

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