Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: removing commas from text file
Top Forums UNIX for Dummies Questions & Answers removing commas from text file Post 35063 by WIntellect on Wednesday 26th of March 2003 03:43:21 PM
Old 03-26-2003
Quote:
Originally posted by Perderabo
sed 's/,//g' some_file > TMP_00
For a bit of fun (mine) the "perl" version is VERY similar to the sed version:
Code:
perl -pe 's/,//g;' < some_file > TMP_00

 

10 More Discussions You Might Find Interesting

1. HP-UX

Padding zeros after removing commas in file

Hi Gurus, There is a ASCII file in which a comma is used as a seperator for the amount field when the amount exceed seven digits: e.g. 0001300,000. Now, this comma needs to be removed from this field, after padding leading zeros (to maintain the ASCII positions) e.g. 00001300000.... (1 Reply)
Discussion started by: pranag21
1 Replies

2. Programming

Removing empty spaces and adding commas

I have a file which contains numbers as follows: 1234 9876 6789 5677 3452 9087 4562 1367 2678 7891 I need to remove the empty spaces and add commas between the numbers like: 1234,9876,6789,5677,3452, 9087,4562,1367,2678,7891 Can anyone tell me the command to do... (4 Replies)
Discussion started by: jazz
4 Replies

3. Shell Programming and Scripting

Need help in removing commas

i have the below line as output from a script. I want to delete the string "," and get the output without comma, cat D* | grep "bytes free" | awk '{print $3}' | ????? output: 40,966,189,056 Desired O/P: 40966189056 (1 Reply)
Discussion started by: ali560045
1 Replies

4. Shell Programming and Scripting

parsing log files, removing spaces and replace with commas

Hello all i am working on a database to import log files from my systems, but i cannot seem to find the answer. I searched here for a good bit and couldnt peice together what i was looking for. I know you could do this with awk, i just dont know how. Any help would be greatly appreciated.... (6 Replies)
Discussion started by: caddyjoe77
6 Replies

5. Shell Programming and Scripting

Removing commas within semicolon in a flat file

Hi , Im relatively new to unix and have to process a comma serparated flat file . I recieve some of the fields in double quotes and i want to remove it .. INPUT ==== filed1,field2,field3,"fie,ld4" OUTPUT ===== field1,field2,field3,"field4" can anyone tell me how to achieve... (10 Replies)
Discussion started by: r_t_1601
10 Replies

6. Shell Programming and Scripting

Removing commas within semicolon in a flat file

i am recieving a flat file ( comma seperated ) with comma in between double quotes in any of the source fields . i need to remove the comma in double quotes and process the file thereafter fields in file ========= col1,col2,col3,col4 input can be any of the followng... (31 Replies)
Discussion started by: r_t_1601
31 Replies

7. Shell Programming and Scripting

Help with removing additional commas in string

Hi Experts, I have below strings hello,hi,,,,,,start date age,code,,,,,61,season I am trying to format this string to hello,hi,start date age,code,61,season Can anyone please help me in achieving this? Kind Regards, RB (3 Replies)
Discussion started by: ramakanth_burra
3 Replies

8. UNIX for Dummies Questions & Answers

awk for removing special characters and extra commas

Hi, I have a .csv file which as empty lines with comma and some special characters in 3rd column as below. Source data 1,2,3,4,%#,6 ,,,,,, 1,2,3,4,5,6 Target Data 1,2,3,4,5,6I need to remove blank lines and special charcters I am trying to get this using the below awk awk -F","... (2 Replies)
Discussion started by: shruthidwh
2 Replies

9. Shell Programming and Scripting

Removing just the trailing commas :-(

Hi all, I haven't needed to do any shell based editing for nearly 20 years, and no amount of searching around has found me a solution to this very simple problem :-( I have a csv file. Some lines have three commas at the end. This means the invoice hasn't been paid. I'd like to use sed / grep... (4 Replies)
Discussion started by: chardyzulu
4 Replies

10. UNIX for Beginners Questions & Answers

Removing commas from CSV file

Hi I'm creating a sh script to generate a csv file. The CSV contains the values from a sql table. The content looks this: a,b,c,c2,c3,,,,,,,,,,,d,e I have some code that can separate the fields using the comma as delimiter, but some values actually contain commas, such as... (2 Replies)
Discussion started by: preema
2 Replies

LEARN ABOUT DEBIAN

bespin

BESPIN(1)																 BESPIN(1)

NAME

       bespin - the Bespin style configurator

SYNOPSIS

       bespin presets | demo [style] | show <some_preset> | try <some_config.bespin> | sshot <some_file.png> [preset] [width] | load <some_preset>
       | import <some_config.bespin> | update <some_config.bespin> | export <some_preset> <some_config.bespin> | listStyles

DESCRIPTION

       This manual page briefly documents the bespin command.

       bespin is a program to configure the Bespin Qt4 widget style or manage the presets w/o GUI.

FUNCTION LETTERS

       [config]
	      Configure the Bespin Style

       presets
	      List the available Presets

       demo [style]
	      Launch a demo, you can pass other stylenames

       show <some_preset>
	      Open demo dialog with a preset

       try <some_config.bespin>
	      Try out an exported setting

       sshot <some_file.png> [preset] [width]
	      Save a screenshot

       load <some_preset>
	      Load a preset to current settings

       import <some_config.bespin>
	      Import an exported setting

       update <some_config.bespin>
	      Like import, but overrides existing

       export <some_preset> <some_config.bespin>
	      Export an imported setting

       listStyles
	      List all Qt UI styles installed on this System

AUTHOR

       bespin was written by Thomas Lubking

       This manual page was written by Guillaume  Martres  <smarter@ubuntu.com>  from  the  output  of	bespin	-h  by	Thomas	Lubking  <baghira-
       style@gmx.net> for the Debian project (but may be used by others).

								 january 25, 2008							 BESPIN(1)
All times are GMT -4. The time now is 03:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy