Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: File manipulation place 0 before the number using sed
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

LEARN ABOUT DEBIAN

marc::lint::codedata

MARC::Lint::CodeData(3pm)				User Contributed Perl Documentation				 MARC::Lint::CodeData(3pm)

NAME

       MARC::Lint::CodeData -- Contains codes from the MARC code lists for Geographic Areas, Languages, and Countries.

DESCRIPTION

       Code data is used for validating fields 008, 040, 041, and 043.

       Also, sources for subfield 2 in 600-651 and 655.

       Stores codes in hashes, %MARC::Lint::CodeData::[name].

       Note: According to the official MARC documentation, Sears is not a valid 655

       term. The code data below treats it as valid, in anticipation of a change in

       the official documentation.

SYNOPSIS

       use MARC::Lint::CodeData;

       #Should provide access to the following:

       #%MARC::Lint::CodeData::GeogAreaCodes;

       #%MARC::Lint::CodeData::ObsoleteGeogAreaCodes;

       #%MARC::Lint::CodeData::LanguageCodes;

       #%MARC::Lint::CodeData::ObsoleteLanguageCodes;

       #%MARC::Lint::CodeData::CountryCodes;

       #%MARC::Lint::CodeData::ObsoleteCountryCodes;

       #%MARC::Lint::CodeData::Sources600_651;

       #%MARC::Lint::CodeData::ObsoleteSources600_651;

       #%MARC::Lint::CodeData::Sources655;

       #%MARC::Lint::CodeData::ObsoleteSources655;

       #or, import specific code list data

       use MARC::Lint::CodeData qw(%GeogAreaCodes);

       my $gac = "n-us---";

       my $validgac = 1 if ($GeogAreaCodes{$gac});

       print "Geographic Area Code $gac is valid
" if $validgac;

EXPORT

       None by default.

       @EXPORT_OK: %GeogAreaCodes, %ObsoleteGeogAreaCodes, %LanguageCodes, %ObsoleteLanguageCodes, %CountryCodes, %ObsoleteCountryCodes,
       %Sources600_651, %ObsoleteSources600_651, %Sources655, %ObsoleteSources655.

TO DO

       Update codes as needed (see <http://www.loc.gov/marc/>).

       Add other codes for MARC Code Lists for Relators, Sources, Description Conventions.

       Determine what to do about 600-655 codes with indicators (cash, lcsh, lcshac,

       mesh, nal, and rvm). Currently, these are duplicated in valid and obsolete

       hashes. Validation routines should probably treat these differently due to large

       numbers of records using these codes, created before the indicators were

       allowed.

       Determine whether three blank spaces should be in the LanguageCodes (for 008 validation) or not.

       If it is here, then 041 would be allowed to have three blank spaces as a valid code

       (though other checks would report the error--spaces at the beginning and ending of a subfield

       and multiple spaces in a field where such a thing is not allowed).

   SEE ALSO
       MARC::Lint

       MARC::Lintadditions (for check_040, check_041, check_043 using these codes)

       MARC::Errorchecks (for 008 validation using these codes)

       <http://www.loc.gov/marc/> for the official code lists.

       The following (should be included in the distribution package for this package):

       countrycodelistclean.pl

       gaccleanupscript.pl

       languagecodelistclean.pl

       The scripts above take the MARC code list ASCII version as input.

       They output tab-separated codes for updating the data below.

VERSION HISTORY

       Version 1.28: Updated May 2, 2009.

	-Added new sources codes from Technical Notice of Oct. 10, 2008.

	-Added new sources codes from Technical Notice of Dec. 16, 2008.

	-Added new language codes from Technical Notice of Jan. 6, 2009 (mol moved to ObsoleteLanguageCodes).

	-Added new sources codes from Technical Notice of Jan. 23, 2009.

	-Added new sources codes from Technical Notice of Feb. 19, 2009.

	-Added new sources codes from Technical Notice of Apr. 22, 2009.

       Version 1.27: Updated Aug. 14, 2008.

	-Added new sources codes from Technical Notice of July 25, 2008.

       Version 1.26: Updated July 6, 2008.

	-Added new language codes from Technical Notice of July 1, 2008.

	-Moved obsolete language codes 'scc' and 'scr' to the obsolete language hash.

       Version 1.25: Updated Apr. 28, 2008.

	-Added new sources codes from Technical Notice of Apr. 25, 2008.

       Version 1.24: Updated Mar. 30, 2008.

	-Added new sources codes from Technical Notice of Mar. 28, 2008.

       Version 1.23: Updated Mar. 26, 2008.

	-Added new country and GAC codes from Technical Notice of Mar. 25, 2008.

       Version 1.22: Updated Jan. 21, 2008.

	-Added new sources codes from Technical Notice of Jan. 18, 2008.

       Version 1.21: Updated Nov. 30, 2007.

	-Added new sources codes from Technical Notice of Nov. 30, 2007.

       Version 1.20: Updated Nov. 19, 2007.

	-Added new language codes from Technical Notice of Nov. 16, 2007.

       Version 1.19: Updated Oct. 22, 2007.

	-Added new language codes from Technical Notice of Oct. 22, 2007.

       Version 1.18: Updated Aug. 14, 2007.

	-Added new source codes from Technical Notice of Aug. 13, 2007.

       Version 1.17: Updated July 16, 2007.

	-Added new source codes from Technical Notice of July 13, 2007.

       Version 1.16: Updated Apr. 18, 2007.

	-Added new source codes from Technical Notice of Apr. 5, 2007.

       Version 1.15: Updated Feb. 28, 2007.

	-Added new country and geographic codes from Technical Notice of Feb. 28, 2007.

	-Added 'yu ' to list of obsolete codes.

       Version 1.14: Updated Jan. 8, 2007.

	-Added new source codes from Technical Notice of Jan. 5, 2007.

       Version 1.13: Updated Nov. 19, 2006.

	-Added new source codes from Technical Notice of Nov. 14, 2006.

       Version 1.12: Updated Oct. 20, 2006.

	-Added new source code from Technical Notice of Oct. 19, 2006.

       Version 1.11: Updated Oct. 18, 2006.

	-Added new source codes from Technical Notice of Oct. 17, 2006.

       Version 1.10: Updated Aug. 30, 2006.

	-Added new source codes from Technical Notice of Aug. 29, 2006.

       Version 1.09: Updated June 26, 2006.

	-Added new source codes from Technical Notice of June 23, 2006.

       Version 1.08: Updated May 30, 2006.

	-Added new source codes from Technical Notice of May 26, 2006.

       Version 1.07: Updated Mar. 13, 2006.

	-Added new source codes from Technical Notice of Mar. 10, 2006.

       Version 1.06: Updated Feb. 23, 2006.

	-Added new language codes from Technical Notice of Feb 23, 2006.

	-Alphabetized language codes.

       Version 1.05: Updated Jan. 11, 2006.

	-Added new sources codes from Technical Notice of Jan. 10, 2006.

       Version 1.04: Updated Oct. 13, 2005.

	-Added new sources codes from Technical Notice of Oct. 12, 2005.

       Version 1.03: Updated Aug. 31, 2005.

	-Added new language codes for Ainu and Southern Altai (August 30, 2005 technical notice)

       Version 1.02: Updated June 21-July 12, 2005. Released (to CPAN) with new version of MARC::Errorchecks.

	-Added GAC and Country code changes for Australia (July 12, 2005 update)

	-Added 6xx subfield 2 source code data for June 17, 2005 update.

	-Updated valid Language codes to June 2, 2005 changes.

       Version 1.01: Updated Jan. 5-Feb. 10, 2005. Released (to CPAN) Feb. 13, 2005 (with new version of MARC::Errorchecks).

	-Added code list data for 600-651 subfield 2 and for 655 subfield 2 sources.

	-Updated codes based on changes made Jan. 19 (languages), Feb. 2 (sources), Feb. 9 (sources).

       Version 1.00 (original version): First release, Dec. 5, 2004. Uploaded to SourceForge CVS, Jan. 3, 2005.

	-Included in MARC::Errorchecks distribution on CPAN.

	-Used by MARC::Lintadditions.

LICENSE

       This code may be distributed under the same terms as Perl itself.

       Please note that this module is not a product of or supported by the

       employers of the various contributors to the code.

AUTHOR

       Bryan Baldus

       eijabb@cpan.org

       Copyright (c) 2004-2008.

perl v5.10.0							    2009-09-01						 MARC::Lint::CodeData(3pm)
All times are GMT -4. The time now is 10:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy