Append specific lines to a previous line based on sequential search criteria
I'll try explain this as best I can. Let me know if it is not clear.
I have large text files that contain data as such:
Every line in the file that starts with a 9 digit number (followed by a date / time and so on) is a unique message. In the example the first 3 lines are really 1 message (with 2 newlines in it).
This first 9 digit number increments sequentially.
What I want to do is get each message in it's entirety onto 1 line. So I *want* the file to look like:
Note that I'd like there to be a space between the additional lines in a single message.
My first idea was to remove ALL newlines from the file and replace them with spaces, and then work through that data inserting a newline after each of the sequence numbers.
I believe this will solve the problem but unfortunately I don't have the chops to pull it off. I'm sure there are also other, potentially better, ways of solving the problem.
One potential issue, I suppose, would be if one of the "extra" lines in a single message was miraculously the next 9 digit number in the sequence itself. I believe the chances of this would be pretty slim, probably to the extent of making this a moot concern for me at this point... but nonetheless it's something to consider.
Ideally I would like to do this with either perl or bash.
Hi All,
I need to select only those records having a non zero record in the first column of a comma delimited file.
Suppose my input file is having data like:
"0","01/08/2005 07:11:15",1,1,"Created",,"01/08/2005"
"0","01/08/2005 07:12:40",1,1,"Created",,"01/08/2005"... (2 Replies)
Hello,
Can anybody help me to correct my sed syntax to find the string and print previous two lines and current line and next one line.
i am using string as "testing"
netstat -v | sed -n -e '/test/{x;2!p;g;$!N;p;D;}' -e h
i am able to get the previous line current line next line but... (1 Reply)
Hi all!
A bit of background: I am trying to create a script that formats SQL statements. I have gotten so far as to add new lines based on certain match criteria like commas, keywords etc. In the process, I end up adding newlines where I don't want.
For example: substr(colName, 1, 10)... (3 Replies)
I have a huge file (about 2 millions records) contains data separated by “,” (comma). As part of the requirement, I can't change the format. The objective is to remove some of the records with the following condition. If the 23rd field on each line start with 302 , I need to remove that from the... (4 Replies)
Hello,
Need help with following scenario.
A file contains following text:
{beginning of file}
New: This is a new record and it is not
on same line. Since I have lost touch with script
take this challenge and bring all this in one line.
New: Hello losttouch. You seem to be struggling... (4 Replies)
Hi All,
I have following input file. I wish to retain those lines which match multiple search criteria. The search criteria is stored in a variable seperated from each other by comma(,).
SEARCH_CRITERIA = "REJECT, DUPLICATE"
Input File:
ERROR,MYFILE_20130214_11387,9,37.75... (3 Replies)
Hi All,
This is very urgent, I've a data file with 1.7 millions rows in the file and the delimiter is cedilla and I need to format the data in such a way that if the NF in the next row is less than 1, it will append that value to previous line.
Any help will be appricated.
Thanks,... (17 Replies)
Hi Guru's,
I am new to unix scripting. I have a huge file with user details in it(file2) and I have another file with a list of users(file1). Script has to search a user from file1 and get all the associated lines from file2.
Example:
fiel1:
cn=abc
cn=DEF
cn=xyx
File 2:
dn:... (10 Replies)
Hello,
I am trying to return a time multiple times from a file that has varying output just before the time instance, i.e.
cat jumped
cat jumped
cat jumped
time = 1.1
cat jumped
cat jumped
time = 1.2
cat jumped
cat jumped
time = 1.3
In this case i would like to output a time.txt... (6 Replies)
In the file below I am trying to extract a specific instance of path, if the adjacent plugin": "/rundb/api/v1/plugin/49/. Thank you :).
file
"path": "/results/analysis/output/Home/Auto_user_S5-00580-4-Medexome_65_028/plugin_out/FileExporter_out.52", "plugin": "/rundb/api/v1/plugin/49/",... (8 Replies)
Discussion started by: cmccabe
8 Replies
LEARN ABOUT V7
vp
VP(4) Kernel Interfaces Manual VP(4)NAME
vp - Versatec printer-plotter
DESCRIPTION
Vp0 is the interface to a Versatec D1200A printer-plotter with a Versatec C-PDP11(DMA) controller. Ordinarily bytes written on it are
interpreted as ASCII characters and printed. As a printer, it writes 64 lines of 132 characters each on 11 by 8.5 inch paper. Only some
of the ASCII control characters are interpreted.
NL performs the usual new-line function, i.e. spaces up the paper and resets to the left margin. It is ignored however following a CR
which ends a non-empty line.
CR is ignored if the current line is empty but is otherwise like NL.
FF resets to the left margin and then to the top of the next page.
EOT resets to the left margin, advances 8 inches, and then performs a FF.
The ioctl(2) system call may be used to change the mode of the device. Only the first word of the 3-word argument structure is used. The
bits mean:
0400 Enter simultaneous print/plot mode.
0200 Enter plot mode.
0100 Enter print mode (default on open).
040 Send remote terminate.
020 Send remote form-feed.
010 Send remote EOT.
04 Send remote clear.
02 Send remote reset.
On open a reset, clear, and form-feed are performed automatically. Notice that the mode bits are not encoded, so that it is required that
exactly one be set.
In plot mode each byte is interpreted as 8 bits of which the high-order is plotted to the left; a `1' leaves a visible dot. A full line of
dots is produced by 264 bytes; lines are terminated only by count or by a remote terminate function. There are 200 dots per inch both ver-
tically and horizontally.
When simultaneous print-plot mode is entered exactly one line of characters, terminated by NL, CR, or the remote terminate function, should
be written. Then the device enters plot mode and at least 20 lines of plotting bytes should be sent. As the line of characters (which is
20 dots high) is printed, the plotting bytes overlay the characters. Notice that it is impossible to print characters on baselines that
differ by fewer than 20 dot-lines.
In print mode lines may be terminated either with an appropriate ASCII character or by using the remote terminate function.
FILES
/dev/vp0
SEE ALSO opr(1)VP(4)