Removing commas within semicolon in a flat file Post: 302325844

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

removing commas from text file

Dear all I have a file which looks like this xxxxxxxxxxxxxx,xxx,xxxxxxxxxx xxxxxxxxxxxxxx,xxx,xxxxxxxxxx etc basically 14 characters then a comma, three characters, then a comma then 10 characters. We are uploading this file to our mainframe and they want the commas removed, so it...

2. 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....

3. UNIX for Dummies Questions & Answers

Removing trailer from a flat file!!!

Hi, I get some flat files with trailer which gives the totol records count and i want to remove the trailer from the file. i used the following command it works fine with a single file. cat file_name | grep -v 'Total records:' > file1 mv file file_name But i dont know how to remove the...

4. UNIX for Dummies Questions & Answers

removing semicolon using sed in aix--urgent

hi I have an expression aaabbb; xxx xxxi i need to get the ouput as xxx xxxi i am using sed -e 's/$*;$//g' but it is not working..?? can some one suggest.. This is urgent

5. 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

6. 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...

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

8. 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...

9. Shell Programming and Scripting

Replace semicolon within double quotes in a file with semicolon delimiter

Hello Team, Could you please help me with the below question? I have a file with the following properties 1) File Delimiter is ; 2) Text columns are within double quotes 3) Numeric columns will not have double quotes 4) File has total 6 columns Please see a sample record from file ...

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...

LEARN ABOUT REDHAT

smbstatus

SMBSTATUS(1)															      SMBSTATUS(1)

NAME

       smbstatus - report on current Samba connections

SYNOPSIS

       smbstatus [ -P ]  [ -b ]  [ -d ]  [ -L ]  [ -p ]  [ -S ]  [ -s <configuration file> ]  [ -u <username> ]

DESCRIPTION

       This tool is part of the  Samba suite.

       smbstatus is a very simple program to list the current Samba connections.

OPTIONS

       -P     If samba has been compiled with the profiling option, print only the contents of the profiling shared memory area.

       -b     gives brief output.

       -d     gives verbose output.

       -L     causes smbstatus to only list locks.

       -p     print a list of  smbd(8) processes and exit.  Useful for scripting.

       -S     causes smbstatus to only list shares.

       -s <configuration file>
	      The default configuration file name is determined at compile time. The file specified contains the configuration details required by
	      the server. See smb.conf(5)
	       for more information.

       -u <username>
	      selects information relevant to username only.

VERSION

       This man page is correct for version 2.2 of the Samba suite.

SEE ALSO

       smbd(8) and smb.conf(5)

AUTHOR

       The original Samba software and related utilities were created by Andrew Tridgell. Samba is now developed by the  Samba	Team  as  an  Open
       Source project similar to the way the Linux kernel is developed.

       The  original  Samba  man  pages were written by Karl Auer.  The man page sources were converted to YODL format (another excellent piece of
       Open Source software, available at ftp://ftp.icce.rug.nl/pub/unix/ <URL:ftp://ftp.icce.rug.nl/pub/unix/>) and updated  for  the	Samba  2.0
       release by Jeremy Allison. The conversion to DocBook for Samba 2.2 was done by Gerald Carter

								 19 November 2002						      SMBSTATUS(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

removing commas from text file

Discussion started by: hcclnoodles

2. HP-UX

Padding zeros after removing commas in file

Discussion started by: pranag21

3. UNIX for Dummies Questions & Answers

Removing trailer from a flat file!!!

Discussion started by: kumarsaravana_s

4. UNIX for Dummies Questions & Answers

removing semicolon using sed in aix--urgent

Discussion started by: aixjadoo