Col 4 should be determined by the keywords biological_process , cellular_component , molecular_function , without that it is not possible to isolate col3 because it can have variable number of words.
---------- Post updated at 01:46 PM ---------- Previous update was at 01:28 PM ----------
Output
---------- Post updated at 01:48 PM ---------- Previous update was at 01:46 PM ----------
Quote:
Originally Posted by RavinderSingh13
Hello,
Following may help you in same.
Output wil be as follows.
EDIT:
please let us know the expected Output with proper info it will help us more to understand the same please.
Thanks,
R. Singh
I have modified the input and output if that helps understand better, thanks
Can someone help me on this?
I'm creating an Insert stmt script but Oracle does not accept blanks values. How can I insert the word null between two commas? I'm guessing awk or sed.
Is there a good post or site with easy to understand info on awk and sed? I'm really new to unix scripts :D
... (5 Replies)
Hi,
i need replace the slash (/) with a newline (\n) and a tab (\t).
With 'find -type f' in a folder i got this output:
./1999/01/file1
./1999/01/file2
./1999/02/file1
./2000/04/file1
./2000/04/file2
./2000/04/file3
./2000/04/file4
./2000/06/file1
./2000/06/file2
./2000/06/file3... (8 Replies)
Hi
Can somebody help me with solution for this PLEASE?
I have a flat file and need to insert delimiters at fixed positions in all the lines so that I can easily convert into EXCEL with columns defined as per their width.
For Example
Here is the file
{
kkjhdhal
sdfewss
sdtereetyw... (7 Replies)
Hi,
I'm looking for a command that replaces spaces/tabs with pipe symbol and store the result to the same file instead of routing it to another file.
infile
outfile
Thanks. (11 Replies)
I have a data file that I would like to add delimiters to.
Example:
Turn This:
20110624000744000693000704000764
Into This:
20110624,000744,000693,000704,000764
I found this link but the only issue is I do not know how many colums I will have. The first field would needs to be 8... (9 Replies)
Hi,
I am writing a Perl Script for the below :
I have a data file that consists of the header information which is 231 Lines and the footer information as 4 lines. The total number of line including the header and footer 1.2 Million with Pipe Delimited file.
For example:
Header Information:... (4 Replies)
Hi,
I am using below script to get the below given output. But i am wondering how to pick the names from below output.
Script:
echo "dis ql(*) cluster(CT.CL.RIBRSBT3)"| runmqsc CT.QM.701t8|egrep QUEUE|sed -e 's/QUEUE(/ /'|sed -e 's/)/ /'
Output:
... (10 Replies)
I have file like below
1|4|OR|OLAP|INT|INT||CONSTANT|2012/08/07|9999/12/31|0|0|0|0|PRL|-358.1684563||||||||||36522|55791|LNR|
2|4|OR|OLAP|CLR|CLR||CONSTANT|2012/09/07|9999/12/31|0|0|0|0|PRL|-358.1684563||||||||||36522|57891|REGS|... (2 Replies)
Hi All,
I have a file which has data like
a,b
c,d
e,f
g,h
And I need to insert a new column at the begining with sequence no( 1 to n)
1,a,b
2,c,d
3,e,f
4,g,h
Please let me know how to acheive this in unix (3 Replies)
Would like to insert value between two empty delimiter and at the very last too if empty.
$ cat customerleft.tbl
300|Customer#000000300|I0fJfo60DRqQ|7|17-165-193-5964|8084.92|\N|p fluffily among the slyly express grouches. furiously express instruct||||||||||||||||||||||||\N... (3 Replies)