How to add the line to previous line in | delimited text?
Hi All,
I am new to Unix and I have one challenge and below are the details.
I have pipe delimited text file in that data has span into multiple lines instead of single line.
Sample data.
Data should be like below for entire file.
Code:
41|216|398555|77|provided complete NP outcome data constituted
But data in few lines like below.
Code:
72|192|402632|580|Completed OHTS Phase 2
, through
March
I need to keep the data in single line like above and remove the spaces. I have fixed length number in 3rd column of the data file.
Could you please help me on this to fix this issue.
Thanks,
Narasimha
Moderator's Comments:
Moved => Shell Programming and Scripting
Last edited by Scrutinizer; 07-07-2016 at 05:58 AM..
Reason: code tags
Hi,
Please let me know how to find text and print text and its previous line. Please don't get irritated few days back I asked text and next line. I am using HP-UX 11.11
Thanks for your help. (6 Replies)
Hi folks,
I've list of LDAP records in this format:
cat cmmac.export.tmp2
dn: deviceId=0a92746a54tbmd34b05758900131136a506,ou=devices,ou=customer,ou=nl,o=upc
cmmac: 00:13:11:36:a5:06
dn: deviceId=0a92746a62pbms4662299650015961cfa23,ou=devices,ou=customer,ou=nl,o=upc
cmmac:... (4 Replies)
I am trying to delete lines in archived Apache httpd logs
Each line has the pattern:
<ip-address> - - <date-time> <document-request-URL> <http-response> <size-of-req'd-doc> <referring-document-URL>
This pattern is shown in the example of 6 lines from the log in the code box below. These 6... (1 Reply)
Hi ,
i have a file with data as below.This is same file. But actual file contains to many rows.
i want to search for a string "Field 039 00" and delete that line and previous 3 lines in that file.. Can some body suggested me how can i do using either sed or awk command ?
Field 004... (7 Replies)
Hi,
Is there a one-liner that I can use to change a line of text into a comma delimited string?
For example, convert
user1
user2
user3
user4to
user1,user2,user3,user4Currently using while read x, although got the extra comma at the end that I have to remove manually.
Please... (5 Replies)
Hi,
I am trying to compare 2 lists. However, one of these lists has to be taken from a.pdf file. When I copy the test into a .txt document there are formatting errors which I need to correct. The document is long (~10,000 lines) so I need to script the re-formatting.
Currently my file looks... (9 Replies)
Hello,
I have below format log file,
Comparing csv_converted_files/2201/9747.1012H67126.5077292103609547345.csv and csv_converted_files/22019/97447.1012H67126.5077292103609547345.csv
Comparing csv_converted_files/2559/9447.1012H67126.5077292103609547345.csv and... (6 Replies)
Hi,
i have a file with multiple entries. After some tests with sed i managed to get the file output as follows:
lsn=X-LINK-IN0,apc=661:0,state=avail,avail/links=1/1,
00,2110597,2094790,0,81,529,75649011,56435363,
lsn=TM1ITP1-AM1ITP1-LS,apc=500:0,state=avail,avail/links=1/1,... (5 Replies)
Hi,
I've got this output:
# cat test2.txt
TM1ITP1-TMNLSTP1 SLC00=0,SLC01=0,SLC02=0,SLC03=0
if I just use cat test2.txt | tr "," "\n" I'll end up very near to what I'm trying to achieve:
TM1ITP1-TMNLSTP1 SLC00=0
SLC01=0
SLC02=0
SLC03=0
But how can i eventually add the term... (1 Reply)
Discussion started by: nms
1 Replies
LEARN ABOUT OSF1
trans
trans(1) General Commands Manual trans(1)NAME
trans - translation tool for use with source message catalogs
SYNOPSIS
trans [-c] [-o name] file.msg
OPTIONS
Display comment lines beginning with a dollar sign ($) for translation, in addition to messages. Call the output file name. The default is
output file name is trans.msg.
DESCRIPTION
The trans command assists in the translation of source message catalogs. The command reads input from file.msg and writes its output to
either a file named trans.msg or a file you name on the command line. The command displays file.msg in a multiple window screen that lets
you simultaneously see the original message, the translated text you enter, and any messages from the trans command. This multiple window
screen is easier to use for translating messages than a single window screen.
The top window in the multiple window screen displays the text in the message source file file.msg. The editor displays the current message
in reverse video.
In the center window, trans displays a prompt that asks you to enter a translated message. You use a control key editor to move the cursor
and delete text in the center window. The control key sequences are defined as follows:
------------------------------------------
Key Sequence Meaning
------------------------------------------
CTRL/k Display control key help
CTRL/h Back space
CTRL/l Forward space
CTRL/w Back word
CTRL/f Forward word
CTRL/e Move to end of input
CTRL/b Move to beginning of input
CTRL/n Next line
CTRL/p Previous line
CTRL/u Delete input
CTRL/i Insert mode (default)
CTRL/r Replace mode
DEL Delete previous character
------------------------------------------
If you need to span more than one line with the translated text, type a backslash () and press the RETURN key to enable line continuation.
After you finish entering the translated text, press the RETURN key to signal that you have finished translating that message.
The bottom window displays any messages generated by trans. If an error occurs, trans prompts you to re-enter the entire line, including
the message label or number.
RESTRICTIONS
Your terminal must be 80 columns by 24 lines for trans to display its three-window screen.
You cannot interrupt a trans session and restart it at the point you stopped. You must complete the all the changes to a file before exit-
ing a file.
SEE ALSO extract(1), gencat(1), strextract(1), strmerge(1)
Writing Software for the International Market
trans(1)
07-07-2016
