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 PHP

mb_strripos

MB_STRRIPOS(3)								 1							    MB_STRRIPOS(3)

mb_strripos - Finds position of last occurrence of a string within another, case insensitive

SYNOPSIS

       int mb_strripos (string	$haystack, string  $needle, [int  $offset], [string  $encoding = mb_internal_encoding()])

DESCRIPTION

       mb_strripos(3) performs multi-byte safe strripos(3) operation based on number of characters. $needle position is counted from the beginning
       of $haystack. First character's position is 0. Second character position is 1. Unlike mb_strrpos(3), mb_strripos(3) is case-insensitive.

PARAMETERS

	      o $haystack
		- The string from which to get the position of the last occurrence of $needle

	      o $needle
		- The string to find in $haystack

	      o $offset
		- The position in $haystack to start searching

	      o $encoding
		- Character encoding name to use. If it is omitted, internal character encoding is used.

RETURN VALUES

	Return the numeric position of the last occurrence of $needle in the $haystack string, or FALSE if $needle is not found.

SEE ALSO

       strripos(3), strrpos(3), mb_strrpos(3).

PHP Documentation Group 													    MB_STRRIPOS(3)
All times are GMT -4. The time now is 02:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy