I have simple text files in which the number of lines vary from one file to another. They look like the following:
I want to grab the first number of the last line of each file (let's say A= 39 in the above example), which is always a multiplication of 3, and insert a new line in the 28th line of another text file with the following format:
0, (A/3) +1, 0, 3,6,9,12,15,...,A
Where A can be a number between 3 and 54, so the number of fields in the line would be variable. Positions of zeros(0) in the line remain fixed. In case of A=39 the line lools like:
Let's call the file where I want to grab the number from file1 which may look like
So here the number I have to pull out is 15. Then I have to make changes to another file, named file2, i.e. insert a line on the 28th line with following format:
0, 6, 0, 3, 6, 9, 12, 15
Here A=15. Another example can be:
Then line #28 in file2 will be:
0,12, 0, 3, 6, 9, 12, 15, 18, 21, 24, 27, 30, 33
Prior to line insertion, file2 is a 50-line text file which will turn into a 51-line file after editing.
Please let me know if it is not yet clear.
Cheers
---------- Post updated at 11:10 AM ---------- Previous update was at 10:38 AM ----------
I just tried the code on Solaris but it gives syntax error:
Hi Team,
I have an issue to split the file which is having special chracter(German Char) using awk command.
I have a different length records in a file. I am separating the files based on the length using awk command.
The command is working fine if the record is not having any... (7 Replies)
I have several questions about using awk. I'm hoping someone could lend me a hand. (I'm also hoping that my questions make sense.)
I have a file that contains pipe separated data. Each line has similar data but the number of fields and the field position on each line is variable. ... (3 Replies)
Hello All,
I have following file contents
cat file
#line=aaaaaa
#line=bbbbbb
#line=cccccc
#line=dddddd
line=eeeeee
#comment=11111
#comment=22222
#comment=33333
#comment=44444
comment=55555
Testing script
Good Luck!
I would like to comment line line=eeeeee and insert a new line... (19 Replies)
Hi,
I have a issue, I need to loop through a comma delimited file and check for the length which exceeds specified length , if Yes truncate the string.
But my problem is , I do not have to check for all the fields and the field lenght is not same for all the fields.
For ex:
Say my line... (9 Replies)
I am trying to get text from a webpage, in terminal form. So far I am:
1. getting the html for the page printed using curl (curl -s webpage.com), which is then
2. piped to awk, printing line number 29 (awk NR==29), then
3. this is where I am sort of lost. I know where in the printed line I... (7 Replies)
In my script I am using sed to insert a line.
Suppose I have a variable called ck_size=5 and a temporary file called tmp
I want to add a certain line in the tmp file .Please see the below command
sed -i '2a\maitee is $ck_size' /dun/homes/lrsprod/tmp
I want in 2 line of tmp file... (7 Replies)
Hi,
Can anyone help with a effective solution ?
I need to change a variable length text field (between 1 - 18 characters) to a fixed length text of 18 characters with the unused portion, at the end, filled with spaces.
The text field is actually field 10 of a .csv file however I could cut... (7 Replies)
Very, very new to unix scripting and have a unique situation. I have a file of records that contain 3 records types:
(H)eader Records
(D)etail Records
(T)railer Records
The Detail records are 82 bytes in length which is perfect. The Header and Trailer records sometimes are 82 bytes in... (3 Replies)
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
Is there a command that sets a variable length?
I have a input of a variable length field but my output for that field needs to be set to 32 char.
Is there such a command?
I am on a sun box running ksh
Thanks (2 Replies)