Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find character and Replace character for given position
Top Forums Shell Programming and Scripting Find character and Replace character for given position Post 302739069 by in2nix4life on Monday 3rd of December 2012 12:27:21 PM
Old 12-03-2012
If this file is in this fixed format, this would work:

Code:
cat file

15628 27243 LM INS CORP QQ1234567977011 SPIDLE CONTRACTING LLC 21MI 10 13 2006 03 04 2010 05 Premium Recovered - First Attorney 00000050000-00000012000 00000000000 00000000000 B00000000399225
15628 27243 LM INS CORP QQ1234567977011 SOUTH CAROLINA HURRICANES 20SC 01 09 2011 09 15 2012 20 Audit Adjustment 00000490000 00000000000 00000000000 00000000000 B090712-0013001

perl -pe 's|\w{7}-\w{7}|('0' x 14).$1|ge' file

15628 27243 LM INS CORP QQ1234567977011 SPIDLE CONTRACTING LLC 21MI 10 13 2006 03 04 2010 05 Premium Recovered - First Attorney 0000000000000000002000 00000000000 00000000000 B00000000399225
15628 27243 LM INS CORP QQ1234567977011 SOUTH CAROLINA HURRICANES 20SC 01 09 2011 09 15 2012 20 Audit Adjustment 00000490000 00000000000 00000000000 00000000000 00000000000000

---------- Post updated at 12:27 PM ---------- Previous update was at 12:19 PM ----------

Revised:

Code:
perl -pe 's|\w{7}-\w{7}$|('0' x 14).$1|ge' file

15628 27243 LM INS CORP QQ1234567977011 SPIDLE CONTRACTING LLC 21MI 10 13 2006 03 04 2010 05 Premium Recovered - First Attorney 00000050000-00000012000 00000000000 00000000000 B00000000399225
15628 27243 LM INS CORP QQ1234567977011 SOUTH CAROLINA HURRICANES 20SC 01 09 2011 09 15 2012 20 Audit Adjustment 00000490000 00000000000 00000000000 00000000000 00000000000000

This User Gave Thanks to in2nix4life For This Post:
Sara183
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

read in a file character by character - replace any unknown ASCII characters with spa

Can someone help me to write a script / command to read in a file, character by character, replace any unknown ASCII characters with space. then write out the file to a new filename/ Thanks! (1 Reply)
Discussion started by: raghav525
1 Replies

2. UNIX for Dummies Questions & Answers

How to replace character on defined position

I need to replace the character on 6th position. If this character is 1 I have to repleace it with A, if it is 2 than I have to replace it with B. If it is not 1 or 2 I should not repleace it. input: abcd defg abcd 1efg mnop weac rstu 2bcd i need: abcd defg abcd Aefg mnop weac rstu... (2 Replies)
Discussion started by: necroman08
2 Replies

3. Shell Programming and Scripting

Replace character in certain position in a string

Hello everyone this is my first post of many to come :) I am writing a script and in this script at one point i need to replace a character in a particular position in a string for example: in the string "mystery" i would need to replace the 3rd position to an "r" so the string becomes... (3 Replies)
Discussion started by: snipaa
3 Replies

4. Shell Programming and Scripting

How to find character position in file?

how to find character positionin file? i.e string = "123X568" i want to find the position of character "X". Thanks (6 Replies)
Discussion started by: LiorAmitai
6 Replies

5. Shell Programming and Scripting

Find position of character in multiple strings in a file

Greetings. I have a file with information like this: AMNDHRKEOEU?AMNDHRKEOEU?AMNDHRKEOEU?AMNDHRKEOEU? AMNDHRKEEU?AMNDHREOEU? AMNDHREU?AHRKEOEU?AMNDHRKEU?AMNDKEOEU? What I need to extract is the position, in every line, of every occurrence of '?' A desired output would be something... (6 Replies)
Discussion started by: Twinklefingers
6 Replies

6. Emergency UNIX and Linux Support

Replace nth position character of all the lines in file

I want to replace 150th character of all the lines in a file using sed or awk... searched the forums but didn't find exact answer (9 Replies)
Discussion started by: greenworld123
9 Replies

7. UNIX for Dummies Questions & Answers

[Solved] Find position of character with awk

Hi Guys! Could anyone help me with?.. I have a line which says BCVGF%6$#900 .....How can we know which position is for % or say $ by command or script?There is any way to get a prompt by any script? Thanks a lot (6 Replies)
Discussion started by: Indra2011
6 Replies

8. Shell Programming and Scripting

To find nth position of character in string

Hi guyz i want to know nth position of character in string. For ex. var="UK,TK,HK,IND,AUS" now if we see 1st occurance of , is at 3 position, 2nd at 6,..4th at 13 position. 1st position we can find through INDEX, but what about 2nd,3rd and 4th or may be upto nth position. ? In oracle we had... (2 Replies)
Discussion started by: Jonty Immortal
2 Replies

9. Post Here to Contact Site Administrators and Moderators

Search for a pattern and replace a space at specific position with a Character in File

In file, we have millions of records each of 1000 in length. And at specific position say 800 there is a space, we need to replace it with Character X if the ID in that row starts with 123. So far i have used the below which is replacing space at that position to X but its not checking for... (3 Replies)
Discussion started by: Jagmeet Singh
3 Replies

10. Shell Programming and Scripting

Count specific character of a file in each line and delete this character in a specific position

I will appreciate if you help me here in this script in Solaris Enviroment. Scenario: i have 2 files : 1) /tmp/TRANSACTIONS_DAILY_20180730.txt: 201807300000000004 201807300000000005 201807300000000006 201807300000000007 201807300000000008 2)... (10 Replies)
Discussion started by: teokon90
10 Replies

LEARN ABOUT DEBIAN

idmap_ad

IDMAP_AD(8)						    System Administration tools 					       IDMAP_AD(8)

NAME

       idmap_ad - Samba's idmap_ad Backend for Winbind

DESCRIPTION

       The idmap_ad plugin provides a way for Winbind to read id mappings from an AD server that uses RFC2307/SFU schema extensions. This module
       implements only the "idmap" API, and is READONLY. Mappings must be provided in advance by the administrator by adding the
       posixAccount/posixGroup classes and relative attribute/value pairs to the user and group objects in the AD.

IDMAP OPTIONS

       range = low - high
	   Defines the available matching UID and GID range for which the backend is authoritative. Note that the range acts as a filter. If
	   specified any UID or GID stored in AD that fall outside the range is ignored and the corresponding map is discarded. It is intended as
	   a way to avoid accidental UID/GID overlaps between local and remotely defined IDs.

       schema_mode = <rfc2307 | sfu >
	   Defines the schema that idmap_ad should use when querying Active Directory regarding user and group information. This can be either the
	   RFC2307 schema support included in Windows 2003 R2 or the Service for Unix (SFU) schema.

EXAMPLES

       The following example shows how to retrieve idmappings from our principal and trusted AD domains. If trusted domains are present id
       conflicts must be resolved beforehand, there is no guarantee on the order conflicting mappings would be resolved at this point. This
       example also shows how to leave a small non conflicting range for local id allocation that may be used in internal backends like BUILTIN.

		[global]
		idmap backend = tdb
		idmap uid = 1000000-1999999
		idmap gid = 1000000-1999999

		idmap config CORP : backend  = ad
		idmap config CORP : range = 1000-999999

AUTHOR

       The original Samba software and related utilities were created by Andrew Tridgell. Samba is now developed by the Samba Team as an Open
       Source project similar to the way the Linux kernel is developed.

Samba 3.5							    06/18/2010							       IDMAP_AD(8)
All times are GMT -4. The time now is 01:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy