Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Ho to remove leading zeros from a csv file which is sent from a UNIX script
Top Forums Shell Programming and Scripting Ho to remove leading zeros from a csv file which is sent from a UNIX script Post 302989489 by karthik adiga on Friday 13th of January 2017 08:51:26 AM
Old 01-13-2017
Ho to remove leading zeros from a csv file which is sent from a UNIX script
Hi All,

I am using a informatica job to create a csv file and a unix script the mail the generated file.Everything is working fine but I am not seeing leading zeros in the csv file sent in the mail.These zeros were present when the .csv file was generated by informatica procees.

Is there any command which I can use in shelll script which will dfisplay that?Please help

Code:
fdate=`tail -1 abc.csv | cut -c1-8`
SUBJECT="execp : ${ENV} for ${fdate}"
destname=file_$fdate
sed 's/#BUSINESS/BUSINESS/1' abc.csv > abc2.csv
mv abc2.csv abc.csv
line_count=`wc -l abc.csv|awk '{print $1}'`
echo $line_count
if [ $line_count -gt 1 ]
then
(echo "Hi,Team";uuencode abc.csv $destname.csv) | /usr/bin/mailx -s  "${SUBJECT}"  ${TO} ${CC}

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

truncating leading zeros of a column in a file

Hi I have a file in which I have 5 columns which are delimited by “|” as shown ABC|12|YAK|METRIC|000000019.5 XYZ|10|ABX|META|000000002.5 Now my requirement is to take the last column trim the leading zero's for that column values and write back to the same file in the same... (7 Replies)
Discussion started by: nvuradi
7 Replies

2. UNIX for Dummies Questions & Answers

Triml leading zeros in unix

Hi All, How does one trim leading zero's in unix Thanks KP. (7 Replies)
Discussion started by: kingofprussia
7 Replies

3. Shell Programming and Scripting

excel drops leading zeros while attaching through unix

HEllo All, when the data file is being attached and mailed as file1.csv, the column data( e.g: 88E00, 99E00, 77F12, 66H18). The data 88E00 and 99E00 is being converted to 88E+01, 99E+01. All other data is fine. I need the file attached as .csv from unix only. Is there a way we can manage... (2 Replies)
Discussion started by: OSD
2 Replies

4. Shell Programming and Scripting

Replacing stripped off leading zeros in shell script

I have a script which is taking a 10 character variable (BOC) input by the user. If it begins with a zero, the script unwittingly strips that off, & passes a 9 characters variable. echo -n "Enter core-follow date/time for BOC: " setenv BOC $< The next bit of code picks up the 9... (4 Replies)
Discussion started by: wtaicken
4 Replies

5. Shell Programming and Scripting

awk to remove leading zeros for a hex number

Is it possible by using awk to remove leading zeros for a hex number? ex: 0000000011179E0A -> 11179E0A Thank you! (4 Replies)
Discussion started by: carloszhang
4 Replies

6. UNIX for Dummies Questions & Answers

Add leading zeros to columns in a file

Hello Gurus, Quick question. I have a file with the following records: A~000000000000518000~SLP ~99991231~20090701~88.50~USD~CS~ A~000000000000518000~SLP ~99991231~20090701~102.00~USD~CS~ A~000000000000772000~SLP ~99991231~20100701~118.08~USD~CS~ I wold like to do the following: 1. Add... (1 Reply)
Discussion started by: chumsky
1 Replies

7. Shell Programming and Scripting

Help deleting leading zeros in a file

I have a list of numbers extracted and need to delete the leading zeros from them, but when i do so, the command I am using also deletes numbers that end in Zero as well. eg 10, 20, 30, etc this is part of a larger script and the only way I can think of is to try and detect the 10,20 30 etc in... (19 Replies)
Discussion started by: kcpoole
19 Replies

8. Shell Programming and Scripting

Adding Leading Zeros for date in a file

Hello, I have a pipe separated file with two major lines. One is header and another is detail line. Header starts with H and Detail start with D. Sample Content: H|123456|Joes Watson|UK|4/5/2016|12/5/2016|3456|HC|NW|||||| D|123456|Joes... (13 Replies)
Discussion started by: Mannu2525
13 Replies

9. Shell Programming and Scripting

Remove leading zeros separated by pipe

I have a below file and I wanted to remove the leading zeros in each field separated by pipe File: 01/09/2017|2017/09/06|2017/02/06|02/06/2017|02/06/2017 06:50:06 AM|2017/02/06|02/06/2017|02/07/2017 05:45:06 AM| 02/08/2017|2017/08/06|2017/09/06|02/05/2017|02/07/2017 05:40:06... (4 Replies)
Discussion started by: Joselouis
4 Replies

10. Shell Programming and Scripting

Remove the leading and trailing date from a CSV file

I'm a newbie to shell scripting. Can anyone help with the below requirement ? The leading and trailing date of a files to be removed. 2017-07-12_gmr_tag_log_20170711.csv 2017-07-12_gmr_call_log_20170711.csv 2017-07-12_gmr_outgoing_log_20170711.csv I'm looking for output like... (7 Replies)
Discussion started by: shivamayam
7 Replies

LEARN ABOUT SUNOS

evolution-addressbook-export

evolution-addressbook-export(1) 				   User Commands				   evolution-addressbook-export(1)

NAME

       evolution-addressbook-export - export local address book from Ximian Evolution, Sun Microsystems Edition

SYNOPSIS

       evolution-addressbook-export  [--async] [--format=[vcard|csv]] [--help] [--list-addressbook-folders] [--output=output-file] [--size=number]
       [--usage] [--version]

DESCRIPTION

       Export the local address book to a file.

OPTIONS

       The following options are supported:

       --async		       Export in asynchronous mode. You can also use -a to specify this option.

       --format=[vcard|csv]    Specify the export format:  virtual card (vcard) or comma-separated value (csv).

       --help		       Display help text. You can also use -? to specify this option.

       --list-addressbook-foldeList the local address-book folders. You can also use -l to specify this option.

       --output=output-file    Specify the name of the output file to store the exported information. If no output file is specified, the exported
			       information is sent to standard output.

       --size=number	       Specify the number of cards in one output file in asychronous mode. The default value is 100.

       --usage		       Display brief usage text.

       --version	       Display version information.

EXAMPLES

       Example 1: Exporting Local Address Book in Asynchronous Mode and Vcard Format to contacts.vcf

       example% evolution-addressbook-export -a --format=vcard --output=contacts.vcf

EXIT STATUS

       The following exit values are returned:

       0	Application exited successfully

       1	Application exited with failure

FILES

       The following files are used by this application:

       /usr/bin/evolution-addressbook-export

	   Executable to export Evolution local address book

       $HOME/evolution

	   Per-user configuration files and local storage for Evolution

       $HOME/evolution/mail/account/folders

	   Temporary files for Evolution mail

       $HOME/evolution/sunone/account/folders

	   Temporary files for Evolution Sun ONE account

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Architecture		     |SPARC			   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWevo			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Standard			   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT safe with Exceptions	   |
       +-----------------------------+-----------------------------+

SEE ALSO

       Ximian Evolution Sun Microsystems Edition User Guide

       evolution(1), evolution-address-import(1)

NOTES

       Written by Steven Zhang, Sun Microsystems Inc., 2004.

SunOS 5.10							    15 Apr 2004 				   evolution-addressbook-export(1)
All times are GMT -4. The time now is 09:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy