|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Ho to remove leading zeros from a csv file which is sent from a UNIX script
Post 302989494 by karthik adiga on Friday 13th of January 2017 09:19:54 AM
01-13-2017
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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 DEBIAN
keynav
KEYNAV(1) General Commands Manual KEYNAV(1) NAME
keynav - a keyboard-driven mouse cursor mover SYNOPSIS
keynav DESCRIPTION
Keynav makes your keyboard a fast mouse cursor mover. You can move the cursor to any point on the screen with a few key strokes. It also simulates mouse click. You can do everything mouse can do with a keyboard. HOW TO USE
Run keynav, and activate it by pressing Ctrl+; (semicolon). You should see a thin frame on the screen with a cross in it. Default configuration: * h : select the left half of the region * j : select the bottom half of the region * k : select the top half of the region * l : select the right half of the region * Shift+h : move the region left * Shift+j : move the region down * Shift+k : move the region up * Shift+l : move the region right * Semicolon: move the cursor to the center of the selected region * Spacebar : move the cursor and left-click * Escape : cancel the move CONFIGURATION
You can configure your own key setting. There is an example in /usr/share/doc/keynav/keynavrc. Copy it to $HOME/.keynavrc and edit it as you like. CONFFILE COMMANDS
* start : activate keynav * end : deactivate keynav * cut-left : select the left half of the region * cut-right : select the right half of the region * cut-up : select the top half of the region * cut-down : select the bottom half of the region * move-left : move the region left * move-right : move the region right * move-up : move the region up * move-down : move the region down * warp : move the cursor to the center of the selected region * click 1 : left-click * click 2 : middle-click * click 3 : right-click * doubleclick 1: left-click twice quickly * doubleclick 2: middle-click twice quickly * doubleclick 3: right-click twice quickly * drag <button> [keyseq]: toggle dragging mode for the given button Example: "drag 1 alt" to do a alt+click-drag * grid <rows>x<columns> : change the grid layout of the selection Example: "grid 2x3" to cut screen to 6 cells * cell-select <row>x<column>: select a specific cell in the grid * cell-select <cell> : select a specific cell in the grid AUTHOR
keynav was written by Jordan Sissel <jls@semicomplete.com>. This manual page was written by Wen-Yen Chuang <caleb@calno.com>, for the Debian project (but may be used by others). KEYNAV(1)