I am not good at file and stream editing. I need to replace a few digits in two files. The lines in files looks like this:
Line in the first file,
Line in second file,
I will write a function to connect to database and select Last Julian Business Day and Julian Date digits to get two output digits as:
Then I need to use the first number 2019304 to replace 2019273 in these two files and replace 1909.273 with 1910.304 in two files too.
After replacement, the line in two files should looks like this:
Line in the first file,
Line in second file,
Function output digits can be in one select statement or separate select statement. Output digits will be used in sed or awk command to replace old digits.
I am learning sed or awk to manipulate and edit files. Please help me to figure out how to use either sed or awk to replace these digits in the files. If you can include the logic or simple explanation on your command, it will be greatly appreciated.
I also tested using sed to replace the digits in the one line as:
---replacement is entered at this circumstance.
I got output as:
Now the problem is I couldn't replace 1909.273 with the same command logic. I need to figure out how sed can search to the pattern as digit.digit. What is the delimiter I should use here? Please provide your advice. Thanks.
Thanks for advice. I have tested with your input and command like this:
Then output is what I need.
At this time, replacement digits is manually entered. In real situation, I will use parameter for replacement digits.
Thanks a lot for your help. I would welcome other experts to comment on my command to see whether there are better ways to do this work.
I used this SQL query to fetch business_day and Date_digits into shell variables jdate1 and jdate2. Then use sed to replace them. It worked well.
If using my SQL query, how it work with your awk code?. My query like this:
This output is : 2019304
This output is: 1910.304,
Then I used:
The two files has been replaced with correct Julian date digits in variables. I redirect output to a new file because Solaris do not support sed -i to direct change in place. Then I can overwrite the file with mv back to original name for another Application to use. I want to learn from you how to use your code awk to do the work. Thanks.
Hello Everyone,
I have many files like so:
file1.txt
file2.txt
file3.txt
Within each file I have many lines of random text separated by commas like so:
abcAAA,123,defAA,456777,ghiA,789
jklB,101,mnoBBB,11211,pqrB,13111
stuCC,415,vwxCCCC,161,yzaC,718
I am trying to use SED or AWK to... (4 Replies)
Hi All ,
I am having an input file as stated below
5728 U_TOP_LOGIC/U_CM0P/core/u_cortexm0plus/u_top/u_sys/u_core/r03_q_reg_20_/Q 011
611 U_TOP_LOGIC/U_CM0P/core/u_cortexm0plus/u_top/u_sys/u_core/r04_q_reg_20_/Q 011
3486... (4 Replies)
My code below will print only the email address from all lines. I want to convert it with sed or awk.. also what if i just want to find only filenames.
cat LIS_EMAIL | perl -wne'while(/+@+\w+/g){print "$&\n"}'
Hoping to extract the filename such us .exe, .bin. From file that has scrambled... (8 Replies)
Hi,
Need a help to replace a word if a pattern is found between the delimiters preferably using SED or AWK.
below is the sample file that iam dealing with, need to match pattern 'application' if found replace the whole word between the delimiters and also print the lines that don't match.... (1 Reply)
Hi,
How I can replace last 8 ZEROS with 22991231?
19523479811841494432A2013052700000000
19523479811730333980A2013052700000000
19523479811417044397A2013052700000000
19523479811205895810C2013010120130131
A9523479811205895810A2013020120130228
19523479811205895810I2013030120130331... (9 Replies)
Hi
I have a problem when i use awk or sed to replace characters in file.
For example when I want to replace line like this :
00000O120100512 1.70 1.59 0.00 +7.280
I want to get a new line :
0000000O120100512 1.70 1.59 13.56 +7.280
In ksh :
awk... (1 Reply)
Hello i need some help with the usage of sed.
Situation : 2 textfiles, file.in , file.out
In the first textfile which is called file.in are the words for the substitution.
Every word is in a new-line like :
Firstsub
Secondsub
Thridsub
...
In the second textflie wich is called file.out is... (5 Replies)
So I am working on command line and I have a file that is spaced by tabs like:
one countMe
two countMEtoo
three COUNTMEthree
What I want to do is read in that file, and replace the second column contents with the length of the string in that column.
one 7
two 10... (14 Replies)
There is a service that runs that we call multi-streaming that calls a shell script multiple times simultaneously. In this shell script is the following line:
tr '\r' '\n' < $POLLFILE.OUT | sed '/0000000000000016000A/d' > $POLLFILE
When I run this manually it produces the desired results, but... (6 Replies)