One more point, there might be some blank field also in between e.ge balank fieled after odabc filed. Total number of columns are fixed though. There are 10 columns in total. "ABC","ABC@xyz.com","Mr ABC","odabc",,"C
It is not working for this. Can you please advise.
---------- Post updated at 10:04 AM ---------- Previous update was at 09:50 AM ----------
Quote:
Originally Posted by RudiC
Try also
Hi RudiC,
Your code also runs perfect. But aplogies for torouble. My original file differs a bit. Please see my comment in reply to Ravinder's solution.
Last edited by shekhar_4_u; 05-17-2018 at 01:32 AM..
Hi Can any one tell me how to replace the 10th column in a file(comma delimted) with a new file with a single column. Can any one Help me out of the please as soon as possible as i am in a terribley hurry!!!!!!
Many THanks, (2 Replies)
Is there way to use sed to change only one occurence in a colon separated line?
I would like to change a file from
*:*:rex:rex
*:*:simon:rex
to
*:*:rex:mabry
*:*:simon:rex (2 Replies)
If the 4th column has - sign then the names in 3rd column has to change to some user defined names (as shown in output).
Thanx
input1
1 a aaaaa +
2 b bbbbb +
3 c ccccc +
4 d ddddd +
5 e eeeee +
6 f xxxxx +
8 h hhhhh +... (8 Replies)
Hi All,
I need to replace the last 19 bytes of the following string
My_Org_Testing_20090102_231124.txt (Text_Date_Time.txt).
I would like to derive the current time using "date +%Y%m%d_%H%M%S.txt" and replace the last 19 bytes of the above string
I would appreciate if someone could... (3 Replies)
Hi guys i have a variable called hostname which contains hostname of my machine.
How would i add the hostname to output of other command .
For eg.
if a output of command is .
command : xm list
How would i add hostname column to it.
My output should look like
... (1 Reply)
Hello!
Please could anyone help me in writing a code to modify the value in column
two of a file with more than two tab-separated column (but the lines
may have a different number of columns, i.e. more or less columns),
according to the following conditions.
When the value of column two is... (5 Replies)
Hi Gurus,
I have file content sample:
,5113955056,,TAgent-Suspend
,5119418233,,TAgent-Suspend
,5102119078,,TAgent-Suspend
filenames 120229H5_suspend, 120229H6_unsuspend
I receive those files one of directory /home/temp/
I need following:
1. Backup first /home/temp/ file to... (5 Replies)
Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately.
Here's some example output:
Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop
bond0 9 83830... (3 Replies)
Hi Guys,
Input.txt
L194 A -118.2
L194 B -115.1
L194 C -118.7
L196 A 0
L196 C 0
L197 A -111.2
L197 B -118.9
L197 C -119.9
L199 A -120.4
L199 B -119.9 ... (2 Replies)
how to replace the 10th colum? Each line begins similarly, but they all ends variously.
Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15,Col16,Col17
2015/03/14 15:00:04,2015/03/14 15:00:04,0,Server05,Omega-God,Beta_G,101011247,1,1,24,7,0,,339083645,1,1,... (9 Replies)