Sponsored Content
Top Forums Shell Programming and Scripting Removing commas within semicolon in a flat file Post 302325761 by isatis31 on Tuesday 16th of June 2009 05:37:19 AM
Old 06-16-2009
What do you want to remove, double quotes ? Your OUTPUT is not really clear on this point.
 

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

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. 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
floor(3)						     Library Functions Manual							  floor(3)

NAME
floor, ceil, modf, nint, rint, trunc - Round floating-point numbers to floating-point integers, return the nearest integral value, and truncate a floating-point number LIBRARY
Math Library (libm.a) SYNOPSIS
#include <math.h> double floor (double x); float floorf (float x); long double floorl (long double x); double ceil (double x); float ceilf (float x); long double ceill (long double x); double modf (double x, double *n); float modff (float x, float *n); long double modfl (long double x, long double *n); double nint (double x); float nintf (float x); long double nintl (long double x); double rint (double x); float rintf (float x); long double rintl (long double x); double trunc (double x); float truncf (float x); long double truncl (long double x); STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: floor(): XPG4 ceil(): XPG4 modf(): XPG4 rint(): XPG4-UNIX Refer to the standards(5) reference page for more information about industry standards and associated tags. DESCRIPTION
The floor(), floorf(), and floorl() functions return the largest floating-point integer value less than or equal to x. The ceil(), ceilf(), and ceill() functions return the smallest floating-point integer value greater than or equal to x. The modf(), modff(), and modfl() functions split a floating-point number x into a fractional part f and an integer part i such that |f| < 1.0 and (f + i) = x. Both f and i have the same sign as x. The modf(), modff(), and modfl() functions return f and store i into the loca- tion pointed to by n. The nint(), nintf(), and nintl() functions return the nearest integral value to x, except halfway cases are rounded to the integral value larger in magnitude. This corresponds to the FORTRAN generic intrinsic function nint(). The rint(), rintf(), and rintl() functions round x to an integral value according to the current IEEE rounding direction specified by the user. The trunc(), truncf(), and truncl() functions truncate x to an integral value. delim off floor(3)
All times are GMT -4. The time now is 06:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy