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_8859-1

iconv_8859-1(5) 					Standards, Environments, and Macros					   iconv_8859-1(5)

NAME

       iconv_8859-1 - code set conversion tables for ISO 8859-1 (Latin 1)

DESCRIPTION

       The following code set conversions are supported:

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

CONVERSIONS

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

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

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

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

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

       Converted to Underscore '_' (137)
       ---------------------------------
       100 133 134 135 173 174 175 176
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242 243 244 245 246
       250 251 252 253 254 255 256 257
       260 261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303	   305 306 307
       310 311 312 313 314 315 316 317
       320 321 322 323 324 325	   327
       330 331 332 333	   335 336 337
       340 341 342 343	   345 346 347
       350 351 352 353 354 355 356 357
       360 361 362 363 364 365	   367
       370 371 372 373	   375 376 377

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

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

       Converted to Underscore '_' (137)
       ---------------------------------
       133 134 135 173 174 175
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242 243 244 245 246 247
       250 251 252 253 254 255 256 257
       260 261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303 304	   307
       310 311 312 313 314 315 316 317
       320 321 322 323 324 325 326 327
	   331 332 333 334 335 336 337
       340 341 342 343 344	   347
       350 351 352 353 354 355 356 357
       360 361 362 363 364 365 366 367
       371 372 373 374	       376 377

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

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

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

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

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

       Converted to Underscore '_' (137)
       ---------------------------------
       043
       100 133 134 135 173 174 175 176
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242     244 245 246
	   251 252 253 254 255 256 257
	   261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303 304 305 306 307
       310 311 312 313 314 315 316 317
       320 321 322 323 324 325 326 327
       330 331 332 333 334 335 336 337
	   341 342 343 344 345 346
	       352 353 354 355 356 357
       360 361 362 363 364 365 366 367
       370     372 373 374 375 376 377

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

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

       Converted to Underscore '_' (137)
       ---------------------------------
       043
       100 133 134 135 173 174 175 176
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242     244 245 246
       250 251 252 253 254 255 256 257
	   261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303 304 305 306 307
       310 311 312 313 314 315 316 317
       320 321 322 323 324 325 326 327
       330 331 332 333 334 335 336 337
	   341 342 343 344 345 346
	       352 353 354 355 356 357
       360 361 362 363 364 365 366 367
       370     372 373 374 375 376 377

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

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

       Converted to Underscore '_' (137)
       ---------------------------------
       100 133 134 135 173 174 175
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240     242 243 244 245 246
       250 251 252 253 254 255 256 257
	   261 262 263 264 265 266 267
       270 271 272 273 274 275 276
       300 301 302 303 304 305 306 307
       310 311 312 313 314 315 316 317
       320     322 323 324 325 326 327
       330 331 332 333 334 335 336 337
       340 341 342 343 344 345 346
       350 351 352 353 354 355 356 357
       360     362 363 364 365 366 367
       370 371 372 373 374 375 376 377

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

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

       Converted to Underscore '_' (137)
       ---------------------------------
       100 133 134 135 136 140
       173 174 175 176
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242 243 244 245 246 247
       250 251 252 253 254 255 256 257
       260 261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303	       306 307
       310     312 313 314 315 316 317
       320 321 322 323 324 325	   327
       330 331 332 333	   335 336 337
       340 341 342 343	       346 347
       350     352 353 354 355 356 357
       360 361 362 363 364 365	   367
       370 371 372 373	   375 376 377

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