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 records which have ID as 123.
Code:
awk '
function repl(s,f,t,v)
{
return substr(s,1,f-1) sprintf("%-*s", t-f+1, v) substr(s,t+1)
}
{
a=repl($0,800,800,"X")
print a
}
' infile
Thanks
Moderator's Comments:
Use code tags, thanks.
Last edited by zaxxon; 02-23-2017 at 03:31 AM..
Reason: code tags and indention
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... (6 Replies)
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 (1 Reply)
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. (5 Replies)
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 Replies)
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 (9 Replies)
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... (9 Replies)
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 insensitiveSYNOPSIS
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)
02-23-2017
