This awk works if you have a space in front of some of the line or not cvb vs cvb
@durden_tylor, you have removed this space in f02 perl gives an extra blank row due to this space
The OP did not specify an operating system, so I'll mention that because of \n in the replacement text, that sed script will fail on most non-Linux systems.
Regards,
Alister
---------- Post updated at 01:17 PM ---------- Previous update was at 01:09 PM ----------
Quote:
Originally Posted by Jotne
This awk works if you have a space in front of some of the line or not
If we assume that the sample data and sample output in the OP are exactly correct, then your solution is incorrect. The sample output has a leading space which your solution discards. Additionally, your solution adds a concluding blank line which does not appear in the sample output.
The OP should clarify exactly what they want because there is a discrepancy between the problem description and the sample input/output. The post's text appears to state (due to the grammar, it's impossible to be certain) that input fields are delimited by a single space (supported by the sample data). If that's correct, then, in the absence of special consideration (which isn't mentioned in the post) a leading space represents an empty first field which should become a blank line. However, this would cause an ambiguity in the output format, since a blank line could represent an empty field or a record separator.
If we assume that the leading space on every line of the input and output is an artifact of copy/pasting, a simple, portable solution which treats the input as newline delimited records of single-space delimited fields and converts it to blank-line delimited records (with the exception that the final record is not followed by a blank line) of newline delimited fields:
Regards,
Alister
I do see now that the OPs output request also has space in front
This gives space in front of all line.
But we do not know for sure of is this he wants
I have a table with this structure:
cola colb colc
1 19 lemon
20 31 lemon
32 100 lemon
159 205 cherries
210 500 cherries
and need to parse it into this format:
cola colb colc
1 100 lemon
159 500 cherries
So I need the first row of cola and the last row of colb if colc has the... (3 Replies)
Hi Unix Forum,
I have a relatively easy question i suppose for which, however, until now i could not find a solution.
I am working with a program that will give me an output file similar to the following:
A
1
2
3
4
B
1
2
3
4
C
1 (9 Replies)
Hi Friends,
I have a single column data like below.
1
2
3
4
5
I need the output like below.
0
1
2
3
4
where each row (including first row) subtracting from first row and the result should print below like the way shown in output file.
Thanks
Sid (11 Replies)
I have a file containing rows with the following format.
Field1|Field2|Field3|data1:data data2:data data3:"dataA:data dataB:data" data4:data:data (and so on)
I need to format the above row into multiple rows that look like this:
Field1|Field2|Field3|data1|data
... (2 Replies)
Hi Forum.
I searched the forum for a solution but could not find an exact one to my problem.
I have some records in the file where I would like to convert the last date field to another format while preserving the rest of the other fields.
For example:
Found:... (6 Replies)
Hello,
I have an input file like the following:
11_3_4
2_1_35
3_15__
_16989
Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Hi there,
I've an input file1 as follows:
1001
1002
1003
1004
1005
I would like to have an output file2 as follows:
Numbers are 1001/ 1002/ 1003/ 1004/ 1005/
Any help is appreciated. (2 Replies)
Hi,
I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value .
For Eg .
if the input file has a row :
abc xyz lmn 89 lm nk o p
I would like the script to create something like... (9 Replies)