Sponsored Content
Top Forums UNIX for Beginners Questions & Answers File manipulation place 0 before the number using sed Post 303039594 by akopocpoypoy on Thursday 10th of October 2019 03:15:08 AM
Old 10-10-2019
File manipulation place 0 before the number using sed

I'm new with sed, and i am really confused with slashes, backslashes, parentheses, I've tried reading some beginner's guide, but still trouble fixing this problem, do you have any tips where or what to read to learn more about sed? can you also help me with my problem?

Note: I was tasked to use sed on this.

Sample file:

Code:
upctm,pmdw_bip,pmdw_bip_mnt_35-FOLDistAutoRpt,Oct 7 2019 4:45 AM,Oct 7 2019 4:45 AM,1,1,Oct 6 2019 12:00 AM,Ended OK,3ppnc
upctm,pmdw_ddm,pmdw_ddm_dum_01-StartProjDCSDemand,Oct 17 2019 4:02 AM,Oct 17 2019 4:02 AM,3,1,Oct 16 2019 12:00 AM,Ended OK,3pqgq

I need to add 0 if the number in day is 1 only (ex. Oct 7 2019 to Oct 07 2019).

I've tried to sed, but the Oct 17 was changed to Oct 017
Code:
sed 's/Oct /Oct 0/g' sample_file.txt

Output:
upctm,pmdw_bip,pmdw_bip_mnt_35-FOLDistAutoRpt,Oct 07 2019 4:45 AM,Oct 07 2019 4:45 AM,1,1,Oct 06 2019 12:00 AM,Ended OK,3ppnc
upctm,pmdw_ddm,pmdw_ddm_dum_01-StartProjDCSDemand,Oct 017 2019 4:02 AM,Oct 017 2019 4:02 AM,3,1,Oct 016 2019 12:00 AM,Ended OK,3pqgq

Thank you in advance

Last edited by RavinderSingh13; 10-10-2019 at 05:27 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

file name Manipulation using sed

Hi, I have a file name, for which I want to strip out the first bit and leave the rest... So I want to take the file name .lockfile-filename.10001 ,strip it and have only filename.10001 ... Thanking you all inadvance, Zak (6 Replies)
Discussion started by: Zak
6 Replies

2. Shell Programming and Scripting

Place number with awk

Hello, if I've a list of number 23 34 56 78 how I can place a sequence of ordinated number in a boundary column so 1 23 2 34 3 56 4 78 Thanks in advance! (3 Replies)
Discussion started by: cv313x
3 Replies

3. Shell Programming and Scripting

Read a number from file and place it back

Hi All, I want to read one number from the file. Only one number will be there in the file. then i have to increment the number in my script and put it back in the same file. Is it possible? Can anybody help me? Thanks, Vinay (6 Replies)
Discussion started by: vinayakatj56
6 Replies

4. Shell Programming and Scripting

File manipulation with AWK and SED

Hello How do i check that correct input files are used while using AWk and SED for file manipulation? e.g awk '/bin/ {print $0 }' shell.txt sed 's/hp/samsung/' printers.txt how do i ensure that the correct input files I am working with are used? (5 Replies)
Discussion started by: Pauline mugisha
5 Replies

5. Shell Programming and Scripting

SED/AWK file read & manipulation

I have large number of data files, close to 300 files, lets say all files are same kind and have extension .dat , each file have mulitple lines in it. There is a unique line in each file containing string 'SERVER'. Right after this line there is another line which contain a string 'DIGIT=0',... (4 Replies)
Discussion started by: sal_tx
4 Replies

6. Shell Programming and Scripting

setter and getter functions for file manipulation with sed

Hi, I would really appreciate some help, I couldn't nail my problem: I would like to create some setter and getter functions to make my life easier. my sample file contains: keyword - some tabs - value - semicolon number 12.1; float .3; double 12; real 12.2324; stuff .234; decimal... (5 Replies)
Discussion started by: Toorop
5 Replies

7. Shell Programming and Scripting

Help with number field manipulation

I have a comma separated file containing numbers, I would like to read the file and divide each number by 1024 and create an output file. Input file : 50312.00,3434.05, ,3433.34,124344.00,434343.00, , , Output file: 49.13,3.35,3.35,0,12.05,424.16,0,0 Please click this link: How to... (2 Replies)
Discussion started by: inditopgun
2 Replies

8. Shell Programming and Scripting

Use GREP to count number of records and place it in a variable

I am trying to count the number of records from different files using grep, and then place the result in a separate variable for each file, so at the end of my shell script, I can sum all the variables and check if the number of records are equal to what I was expecting. It is weird butwc -ldoes... (2 Replies)
Discussion started by: dhruuv369
2 Replies

9. Shell Programming and Scripting

sed flat file manipulation

Hello, I have a large flat file where i need to change data in columns 131-133 based on what is in columns 172-173. I am not sure if I need to read the file line by line and make the change or if I can do this in a single statement. thank you (3 Replies)
Discussion started by: gblmin
3 Replies

10. Shell Programming and Scripting

Zero padding a Number before and after a decimal place

Hi I was hoping someone could help me with a sed script I am trying to write? I am on a Mac running ElCapitan I have some text that I have converted from a pdf that I want to format into an xml file. In the file I have managed to delete all the text I do not need. The text I have left is... (8 Replies)
Discussion started by: Paul Walker
8 Replies
LSMBOX(1)						      General Commands Manual							 LSMBOX(1)

NAME
lsmbox - list number of total, old unread, and new messages for the specified mailbox(es) SYNOPSIS
lsmbox [OPTION]... [MAILBOX]... DESCRIPTION
lsmbox lists the number of messages in a mailbox. Both total, unread but old, and new messages can be listed, for one or several mailbox files. Non-existing or empty mailboxes will be silently ignored. If the program has been compiled with curses support, you can execute a predefined command on a mailbox by choosing that mailbox using the cursor keys and pressing enter. If the program has been compiled with ncurses, the command can also be executed by clicking on the mailbox with the mouse-pointer. By default, lsmbox will look in $MAIL (if defined) or /var/spool/mail/USERNAME for the inbox, and in $HOME/Mail/ for other mailboxes. This can be overridden by changing the default paths in $HOME/.lsmboxrc. See lsmboxrc(5) for further details. If $HOME is not defined on your system, the program will look in the current directory for mailboxes. If no mailbox is given as an argument, the program will default to listing information about the mailboxes listed in $HOME/.lsmboxrc. If no default mailboxes have been specified in that file, or if that file does not exist, the program will abort with an error. A filename of ! denotes your inbox. A leading ("=") or ("+") in a filename will be expanded into the path to your mail-directory. If the name of a mailbox given at the command-line contains a path-separator ("/"), it is assumed that the default mailbox path shall be ignored for that entry, unless it has a leading ("=") or ("+"). OPTIONS
-c, --continuous Update statistics continuously rather than just listing them once. Exit with `q' (waits for the next mailcheck to finish) or `<ctrl> + c' (aborts immediately). Note: this option is only available if the program has been compiled with curses support -i, --check-interval Interval in seconds between each update of the statistics. This option overrides the environment variable $MAILCHECK. Using a low interval will give you faster notification of newly arrived e-mail, but will put increased load on your system. Note: this option is only available if the program has been compiled with curses support -n, --new-only Only display mailboxes with new messages (and old unread, if the mark_old option has been unset) -o, --no-old Do not display the number of old messages each mailbox contains -p, --padding Width to use for the mailbox column; leave empty to use the smallest possible -s, --no-summary Do not display a summary of the statistics for all mailboxes -S, --short-names Only display the name of the mailbox rather than the full path -t, --no-total Do not display total number of messages each mailbox contains --help Display help for the command --version Display version and author information ENVIRONMENT
MAILCHECK Interval in seconds between each update of the statistics. EXAMPLES
To get information about your inbox: lsmbox ! To get information about the mailboxes debian-devel, linux-kernel, and spam: lsmbox debian-devel linux-kernel spam To get information about the mailbox test which resides in your home directory: lsmbox ~/test To use lsmbox to keep track of updates in all mailboxes listed in $HOME/.lsmboxrc: lsmbox -c FILES
$HOME/.lsmboxrc Personal preferences for lsmbox. SEE ALSO
lsmboxrc(5), mbox(5) HISTORY
Apr 16 2006: Updated for v2.1.0 of lsmbox. Apr 16 2004: Updated for v2.0.0 of lsmbox. Mar 13 2004: Updated for v1.9.0 of lsmbox. Mar 15 2003: Updated for v1.7.0 of lsmbox. Jan 16 2003: Minor fixes. Jan 06 2003: Minor fixes. Dec 09 2002: Minor fixes. Nov 06 2002: Updated for v1.5.0 of lsmbox. Oct 30 2002: Updated for v1.4.2 of lsmbox. Oct 30 2002: Fixed a typo. Oct 30 2002: Updated for v1.4.0 of lsmbox. Oct 29 2002: Updated for v1.3.1 of lsmbox. Oct 29 2002: Updated for v1.3.0 of lsmbox. Oct 28 2002: Fixed a typo. Oct 26 2002: Updated for v1.1.0 of lsmbox. Oct 26 2002: Updated for v1.0.1 of lsmbox. Oct 21 2002: Initial release. AUTHOR
lsmbox and its manual-pages are written by David Weinehall <tao@acc.umu.se> REPORTING BUGS
Report bugs to <tao@acc.umu.se>. COPYRIGHT
Copyright (C) 2002-2006 David Weinehall This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU- LAR PURPOSE. David Weinehall Apr 16, 2006 LSMBOX(1)
All times are GMT -4. The time now is 05:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy