Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Search comppare replace (substr/lppad)
Top Forums Shell Programming and Scripting Search comppare replace (substr/lppad) Post 302973122 by Showdown on Saturday 14th of May 2016 03:05:23 PM
Old 05-14-2016
Oracle
Hi Rudic,

Much thanks for your help. It pretty much serve my purpose.
To be true, I couldn't understand the syntax which I am trying now to understand.

The only discrepancy here is after formatting using the code mentioned by you the next column is getting shifted by 4 spaces. Please see below.

Code:
XXXXXXX XXXXX                 MM11111    ZM    0         000000000000000000000OREGON XXXXXXX HXN  001111  01010  -->Original
XXXXXXX YYYYY                 MM11111    ZM 0000     000000000000000000000OREGON XXXXXXX HXN  001111  01010      -->After format


If you can help me with the code modification so that the total record length remains the same and next column value doesn't get shifted by 4 spaces it will be really great of you.

Thanks again.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl: Search for string on line then search and replace text

Hi All, I have a file that I need to be able to find a pattern match on a line, search that line for a text pattern, and replace that text. An example of 4 lines in my file is: 1. MatchText_randomNumberOfText moreData ReplaceMe moreData 2. MatchText_randomNumberOfText moreData moreData... (4 Replies)
Discussion started by: Crypto
4 Replies

2. Shell Programming and Scripting

Search and replace

Hi All, Suppose I have a file "a.doc" It's contents are : mos44.0 ) ..... ...... ..... export TKTS_RELEASE=tkts44.0b7 ...... ....... Now , I need to first search for the pattern "mos44.0 )" and then TKTS_RELEASE will... (8 Replies)
Discussion started by: sanyerra
8 Replies

3. Shell Programming and Scripting

awk - replace number of string length from search and replace for a serialized array

Hello, I really would appreciate some help with a bash script for some string manipulation on an SQL dump: I'd like to be able to rename "sites/WHATEVER/files" to "sites/SOMETHINGELSE/files" within the sql dump. This is quite easy with sed: sed -e... (1 Reply)
Discussion started by: otrotipo
1 Replies

4. Shell Programming and Scripting

perl search and replace - search in first line and replance in 2nd line

Dear All, i want to search particular string and want to replance next line value. following is the test file. search string is tmp,??? ,10:1 "???" may contain any 3 character it should remain the same and next line replace with ,10:50 tmp,123 --- if match tmp,??? then... (3 Replies)
Discussion started by: arvindng
3 Replies

5. Shell Programming and Scripting

AWK Substr - find and replace question...

Hello Experts, I have a input file that I need to replace a value only if the file contains the number 6 in column 1. I would like to use AWK in a shell script (ksh on a AIX platform). I need all rows written out, but only change 2 fields when the first column contains a numer 6. Input... (2 Replies)
Discussion started by: scottb
2 Replies

6. UNIX for Dummies Questions & Answers

Help with search and replace or search only of / in vi

Hi all, I am editing a config file in vi that has a / on it. At the moment, search and replace looks alright as am able to use a # as a temporary separator, i.e. :,$s#/u01/app#/u02/app#g For doing a search, I have to escape the / do. So if I want to search for /u01/app, I am having to do... (2 Replies)
Discussion started by: newbie_01
2 Replies

7. Shell Programming and Scripting

search and replace.

Hi, I have a file which contains data in this form. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;... (2 Replies)
Discussion started by: arijitsaha
2 Replies

8. Shell Programming and Scripting

Search for a substr with nawk

Hi, I have files, with fixed length fields/let's say every field 5 positions/, like this: xxxx 140 xxxxx xxxx 140 xxxxx xxxx 1400 xxxxx xxxx 150 xxxxx I need to get only the records, which have 140 in the second column. I use that command: nawk '{if (substr($0,6,3)=="140") print $0}'... (3 Replies)
Discussion started by: apenkov
3 Replies

9. Shell Programming and Scripting

Nested search in a file and replace the inner search

Hi Team, I am new to unix, please help me in this. I have a file named properties. The content of the file is : ##Mobile props east.url=https://qa.east.corp.com/prop/end west.url=https://qa.west.corp.com/prop/end south.url=https://qa.south.corp.com/prop/end... (2 Replies)
Discussion started by: tolearn
2 Replies

10. Shell Programming and Scripting

awk to comppare two files using rwo fields

I use the two awk scripts for comparing file1 and file2. First awk compare $3 column: awk -v OFS="\t" 'NR==FNR{a=$4;next}{$2=$2 "\t"(a?a:"-")}1' file1 file2Second awk compare $2 column: awk -v OFS="\t" 'NR==FNR{a=$4;next}{$2=$2 "\t"(a?a:"-")}1' file1 file2 The only difference ... (12 Replies)
Discussion started by: cmccabe
12 Replies

LEARN ABOUT CENTOS

datetime::locale::fa

DateTime::Locale::fa(3) 				User Contributed Perl Documentation				   DateTime::Locale::fa(3)

NAME

       DateTime::Locale::fa

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'fa' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Persian.

DATA

       This locale inherits from the DateTime::Locale::root locale.

       It contains the following data.

   Days
       Wide (format)

	 XXXXXX
	 XXXXXXX
	 XXXXXXXX
	 XXXXXXX
	 XXXX
	 XXXX
	 XXXXXX

       Abbreviated (format)

	 XXXXXX
	 XXXXXXX
	 XXXXXXXX
	 XXXXXXX
	 XXXX
	 XXXX
	 XXXXXX

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXXXXX
	 XXXXXXX
	 XXXXXXXX
	 XXXXXXX
	 XXXX
	 XXXX
	 XXXXXX

       Abbreviated (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Months
       Wide (format)

	 XXXXXXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXX
	 XXXX
	 XXXXXX
	 XXX
	 XXXXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX

       Abbreviated (format)

	 XXXXXXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXX
	 XXXX
	 XXXXXX
	 XXX
	 XXXXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXXXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XX
	 XXXX
	 XXXXX
	 XXX
	 XXXXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX

       Abbreviated (stand-alone)

	 XXXXXXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXX
	 XXXX
	 XXXXXX
	 XXX
	 XXXXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Quarters
       Wide (format)

	 XXXXXXXX XXX
	 XXXXXXXX XXX
	 XXXXXXXX XXX
	 XXXXXXXX XXXXX

       Abbreviated (format)

	 XXXX
	 XXXX
	 XXXX
	 XXXX

       Narrow (format)

	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXXXXXXX XXX
	 XXXXXXXX XXX
	 XXXXXXXX XXX
	 XXXXXXXX XXXXX

       Abbreviated (stand-alone)

	 XXXX
	 XXXX
	 XXXX
	 XXXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X

   Eras
       Wide

	 XXX XX XXXXX
	 XXXXXX

       Abbreviated

	 X.X.
	 X.

       Narrow

	 X
	 X

   Date Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008
	  1995-12-22T09:05:02 = XXXX 22 XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX -10

       Long

	  2008-02-05T18:30:30 = 5 XXXXXX 2008
	  1995-12-22T09:05:02 = 22 XXXXXX 1995
	 -0010-09-15T04:44:23 = 15 XXXXXXX -10

       Medium

	  2008-02-05T18:30:30 = 2008/2/5
	  1995-12-22T09:05:02 = 1995/12/22
	 -0010-09-15T04:44:23 = -010/9/15

       Short

	  2008-02-05T18:30:30 = 08/2/5
	  1995-12-22T09:05:02 = 95/12/22
	 -0010-09-15T04:44:23 = -10/9/15

       Default

	  2008-02-05T18:30:30 = 5 XXXXXX 2008
	  1995-12-22T09:05:02 = 22 XXXXXX 1995
	 -0010-09-15T04:44:23 = 15 XXXXXXX -10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 (UTC)
	  1995-12-22T09:05:02 = 9:05:02 (UTC)
	 -0010-09-15T04:44:23 = 4:44:23 (UTC)

       Long

	  2008-02-05T18:30:30 = 18:30:30 (UTC)
	  1995-12-22T09:05:02 = 9:05:02 (UTC)
	 -0010-09-15T04:44:23 = 4:44:23 (UTC)

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008X XXXX 18:30:30 (UTC)
	  1995-12-22T09:05:02 = XXXX 22 XXXXXX 1995X XXXX 9:05:02 (UTC)
	 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX -10X XXXX 4:44:23 (UTC)

       Long

	  2008-02-05T18:30:30 = 5 XXXXXX 2008X XXXX 18:30:30 (UTC)
	  1995-12-22T09:05:02 = 22 XXXXXX 1995X XXXX 9:05:02 (UTC)
	 -0010-09-15T04:44:23 = 15 XXXXXXX -10X XXXX 4:44:23 (UTC)

       Medium

	  2008-02-05T18:30:30 = 2008/2/5X XXXX 18:30:30
	  1995-12-22T09:05:02 = 1995/12/22X XXXX 9:05:02
	 -0010-09-15T04:44:23 = -010/9/15X XXXX 4:44:23

       Short

	  2008-02-05T18:30:30 = 08/2/5X XXXX 18:30
	  1995-12-22T09:05:02 = 95/12/22X XXXX 9:05
	 -0010-09-15T04:44:23 = -10/9/15X XXXX 4:44

       Default

	  2008-02-05T18:30:30 = 5 XXXXXX 2008X XXXX 18:30:30
	  1995-12-22T09:05:02 = 22 XXXXXX 1995X XXXX 9:05:02
	 -0010-09-15T04:44:23 = 15 XXXXXXX -10X XXXX 4:44:23

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (EEE d)

	  2008-02-05T18:30:30 = XXXXXXX 5
	  1995-12-22T09:05:02 = XXXX 22
	 -0010-09-15T04:44:23 = XXXX 15

       GGGGyyyyMMMMd (d MMMM y GGGG)

	  2008-02-05T18:30:30 = 5 XXXXXX 2008 XXXXXX
	  1995-12-22T09:05:02 = 22 XXXXXX 1995 XXXXXX
	 -0010-09-15T04:44:23 = 15 XXXXXXX -10 XXX XX XXXXX

       HHmmZ (HH:mm (Z))

	  2008-02-05T18:30:30 = 18:30 (+0000)
	  1995-12-22T09:05:02 = 09:05 (+0000)
	 -0010-09-15T04:44:23 = 04:44 (+0000)

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 XXX XX XXX
	  1995-12-22T09:05:02 = 9:05 XXX XX XXX
	 -0010-09-15T04:44:23 = 4:44 XXX XX XXX

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 XXX XX XXX
	  1995-12-22T09:05:02 = 9:05:02 XXX XX XXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX XX XXX

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M/d)

	  2008-02-05T18:30:30 = 2/5
	  1995-12-22T09:05:02 = 12/22
	 -0010-09-15T04:44:23 = 9/15

       MEd (E M/d)

	  2008-02-05T18:30:30 = XXXXXXX 2/5
	  1995-12-22T09:05:02 = XXXX 12/22
	 -0010-09-15T04:44:23 = XXXX 9/15

       MMM (LLL)

	  2008-02-05T18:30:30 = XXXXXX
	  1995-12-22T09:05:02 = XXXXXX
	 -0010-09-15T04:44:23 = XXXXXXX

       MMMd (d LLL)

	  2008-02-05T18:30:30 = 5 XXXXXX
	  1995-12-22T09:05:02 = 22 XXXXXX
	 -0010-09-15T04:44:23 = 15 XXXXXXX

       MMMEd (E d LLL)

	  2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX
	  1995-12-22T09:05:02 = XXXX 22 XXXXXX
	 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX

       MMMMd (d LLLL)

	  2008-02-05T18:30:30 = 5 XXXXX
	  1995-12-22T09:05:02 = 22 XXXXXX
	 -0010-09-15T04:44:23 = 15 XXXXXXX

       MMMMEd (E d LLLL)

	  2008-02-05T18:30:30 = XXXXXXX 5 XXXXX
	  1995-12-22T09:05:02 = XXXX 22 XXXXXX
	 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX

       mmss (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (yyyy/M)

	  2008-02-05T18:30:30 = 2008/2
	  1995-12-22T09:05:02 = 1995/12
	 -0010-09-15T04:44:23 = -010/9

       yMEd (E yyyy/M/d)

	  2008-02-05T18:30:30 = XXXXXXX 2008/2/5
	  1995-12-22T09:05:02 = XXXX 1995/12/22
	 -0010-09-15T04:44:23 = XXXX -010/9/15

       yMMM (MMM y)

	  2008-02-05T18:30:30 = XXXXXX 2008
	  1995-12-22T09:05:02 = XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXXX -10

       yMMMEd (E d MMM y)

	  2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008
	  1995-12-22T09:05:02 = XXXX 22 XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX -10

       yMMMM (MMMM y)

	  2008-02-05T18:30:30 = XXXXXX 2008
	  1995-12-22T09:05:02 = XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXXX -10

       yQ (yyyy Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -010 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 XXXX
	  1995-12-22T09:05:02 = 1995 XXXX
	 -0010-09-15T04:44:23 = -10 XXXX

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyM (yyyy/M)

	  2008-02-05T18:30:30 = 2008/2
	  1995-12-22T09:05:02 = 1995/12
	 -0010-09-15T04:44:23 = -010/9

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = XXXXXX 2008
	  1995-12-22T09:05:02 = XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXXX -10

       yyyyMMMMEEEEd (EEEE d MMMM y)

	  2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008
	  1995-12-22T09:05:02 = XXXX 22 XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX -10

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       XXXXXX

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.16.3							    2014-06-10						   DateTime::Locale::fa(3)
All times are GMT -4. The time now is 04:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy