Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Removing commas within semicolon in a flat file
Top Forums Shell Programming and Scripting Removing commas within semicolon in a flat file Post 302328490 by bwhitehd on Wednesday 24th of June 2009 11:51:47 AM
Old 06-24-2009
The poster hasn't replied whether any of the replies have solved the problem, but something that was pointed out previously is that the double quotes are not suppose to be removed. Only the commas that exist between the double quotes. Also, some real sample data was provided and it was seen that there were other things that had to be accounted for. (i.e. dashes, periods, spaces, etc.)
 

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... (6 Replies)
Discussion started by: hcclnoodles
6 Replies

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.... (1 Reply)
Discussion started by: pranag21
1 Replies

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... (12 Replies)
Discussion started by: kumarsaravana_s
12 Replies

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 (9 Replies)
Discussion started by: aixjadoo
9 Replies

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 (1 Reply)
Discussion started by: ali560045
1 Replies

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... (10 Replies)
Discussion started by: r_t_1601
10 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. 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

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 ... (3 Replies)
Discussion started by: sam99
3 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

mincextract

MINCEXTRACT(1)							 MINC User's Guide						    MINCEXTRACT(1)

NAME

       mincextract - dump a hyperslab of MINC file data

SYNOPSIS

       mincextract [options] mincfile

DESCRIPTION

       mincextract dumps a chunk of MINC file data to standard output in the format of your choice.

OPTIONS

       -ascii Write out data as ascii strings (default)

       -byte  Write out data as 8-bit integers

       -short Write out data as 16-bit integers

       -int   Write out data as 32-bit integers

       -long  Superseded by -int

       -float Write out data as single precision floating-point values

       -double
	      Write out data as double precision floating-point values

       -filetype
	      Write out data in the type of the file

       -signed
	      Write out signed data (applies only to integer types)

       -unsigned
	      Write out unsigned data (applies only to integer types)

       -range low high
	      Specify the range of output values

       -normalize
	      Normalize integer pixel values to file max and min (Default)

       -nonormalize
	      Turn off pixel normalization

       -image_range low high
	      Specify the range of real image values for normalization

       -image_minimum min
	      Specify the minimum real image value for normalization

       -image_maximum max
	      Specify the maximum real image value for normalization

       -start indexvector
	      Specifies  corner  of  hyperslab (C conventions for indices).  Indices are either separated by spaces (enclosed by quotes) or commas
	      (no quotes required).

       -count indexvector
	      Specifies edge lengths of hyperslab to read.  Indices are either separated by spaces (enclosed  by  quotes)  or  commas  (no  quotes
	      required).

       -positive_direction
	      Flip images to always have positive direction.

       -negative_direction
	      Flip images to always have negative direction.

       -any_direction
	      Do not flip images (Default).

       +xdirection
	      Flip images to give positive xspace:step value (left-to-right).

       -xdirection
	      Flip images to give negative xspace:step value (right-to-left).

       -xanydirection
	      Don't flip images along x-axis (default).

       +ydirection
	      Flip images to give positive yspace:step value (post-to-ant).

       -ydirection
	      Flip images to give negative yspace:step value (ant-to-post).

       -yanydirection
	      Don't flip images along y-axis (default).

       +zdirection
	      Flip images to give positive zspace:step value (inf-to-sup).

       -zdirection
	      Flip images to give negative zspace:step value (sup-to-inf).

       -zanydirection
	      Don't flip images along z-axis (default).

       -help  Print summary of command-line options and exit.

       -version
	      Print the program's version number and exit.

AUTHOR

       Peter Neelin

COPYRIGHTS

       Copyright (C) 1993 by Peter Neelin

SEE ALSO

       minctoraw(1)

							   $Date: 2004-05-20 21:52:08 $ 					    MINCEXTRACT(1)
All times are GMT -4. The time now is 08:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy