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

Tags

Contact Us Post Here to Contact Site Administrators and Moderators Search for a pattern and replace a space at specific position with a Character in File

Prev Next

02-23-2017

Registered User

939, 225

Join Date: Mar 2011

Last Activity: 8 May 2020, 3:48 AM EDT

Location: Éire

Posts: 939

Thanks Given: 27

Thanked 225 Times in 219 Posts

Code:

$ cat test.file
123andsomeothervalues with a space at position 22
Not 123 but with the  space
123 but no spacein the appropriate column

$ perl -npi.bak -e 's/^(123.{18}) /$1X/' test.file

$ cat test.file
123andsomeothervaluesXwith a space at position 22
Not 123 but with the  space
123 but no spacein the appropriate column

If the space is in position 800, then there a 799 characters before it not 800 so the quantifier should be 796 ie:

Code:

perl -npi.bak -e ' s/(123.{796}) /${1}X/' infile

Perhaps my ability to count was compromised by a dangerous caffeine deficiency, currently remedying this cU.

This User Gave Thanks to Skrynesaver For This Post:

Skrynesaver

View Public Profile for Skrynesaver

Find all posts by Skrynesaver

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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)...

2. Shell Programming and Scripting

Search for a string at a particular position and replace with blank based on position

Hi, I have a file with multiple lines(fixed width dat file). I want to search for '02' in the positions 45-46 and if available, in that lines, I need to replace value in position 359 with blank. As I am new to unix, I am not able to figure out how to do this. Can you please help me to achieve...

3. Shell Programming and Scripting

Find character and Replace character for given position

Hi, i want find the character '-' in a file from position 284-298, if it occurs i need to replace it with 'O ' for the position in the file. How to do that using SED command. thanks in advance, Sara

4. 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

5. Shell Programming and Scripting

position specific replace in file

How to replace the position specific values in the file.. i searched a lot the forums but i couldn't able to do... i have file like below 576666666666666666666666666 7878 897987 121 0asdas Y12 5900fbb 777 09JJJ 78798347892374 234234234364 234232898 89HJHIHIGIUG989902743748327khjkhkjlh...

6. Shell Programming and Scripting

Using sed to replace specific character and specific position

I am trying to use sed to replace specific characters at a specific position in the file with a different value... can this be done? Example: File: A0199999123 A0199999124 A0199999125 Need to replace 99999 in positions 3-7 with 88888. Any help is appreciated.

7. Shell Programming and Scripting

Insert character in a specific position of a file

Hi, I need to add Pipe (|) at 5th and 18th position of all records a file. How can I do this? I tried to add it at 5th position using the below code. It didnt work. Please help!!! awk '{substr($0,5,1) ~ /|/}{print}' $input_file > $temp_file

8. Shell Programming and Scripting

Print lines with specific character at nth position in a file

I need to print lines with character S at nth position in a file...can someone pl help me with appropriate awk command for this

9. Shell Programming and Scripting

Print lines with specific character at nth position in a file

I need to print lines with character S at nth position in a file...can someone pl help me with appropriate awk command for this

10. Shell Programming and Scripting

read space filled file and replace text at specific position

Hi I have a spaced filled file having records like below: What I want is to read line having RT3 at position 17-19 then go to position 2651 check the 18 characters (might be space filled till 18 characters). This position should have a...

LEARN ABOUT PHP

mb_stripos

MB_STRIPOS(3)								 1							     MB_STRIPOS(3)

mb_stripos - Finds position of first occurrence of a string within another, case insensitive

SYNOPSIS

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

DESCRIPTION

       mb_stripos(3)  returns  the numeric position of the first occurrence of $needle in the $haystack string. Unlike mb_strpos(3), mb_stripos(3)
       is case-insensitive. If $needle is not found, it returns FALSE.

PARAMETERS

	      o $haystack
		- The string from which to get the position of the first 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 first occurrence of $needle in the $haystack string, or FALSE if $needle is not found.

SEE ALSO

       stripos(3), strpos(3), mb_strpos(3).

PHP Documentation Group 													     MB_STRIPOS(3)

Post Here to Contact Site Administrators and Moderators