Hi,
I am saving this data in excel sheet, and when I delete a column from excel and then uploading it to unix box, the paste is not working properly.
Code that im using:
Instead of coming side by side, it is coming in the same line. Can someone pls help me with this.
Thanks
Ajay
---------- Post updated at 11:12 PM ---------- Previous update was at 11:04 PM ----------
Sorry the format was not good in my previous post:
Before output:
Jobnames 20110218 20110218
pdw_rig30d_cmd 275 275
pdw_abc_cmd 136 136
Later I deleted the duplicate 20110218 column and uploaded it to unix box and ran the script again, it is giving me the following output:
Jobnames 20110218
20110217
pdw_rig30d_cmd 275
260
pdw_abc_cmd 136
130
Hi
Having a file as follows
file1.txt
Date (dd/mm)Time Server IP Error Code
===========================================================================
10/04/2008 10:10 ServerA xxx.xxx.xxx.xxx 6
10/04/2008 10:10 ServerB ... (3 Replies)
I have to files
File1
1 23
2 34
3 7
4 56
5 61
6 22
7 65
File2
2 21
4 32
7 22
Now i need to compare column1 of both the files and generate a third file which should contain all the values of 1st column of 1st file and in the second column i need to get the coressponding row... (2 Replies)
Hi All, can you help me with this:
grep XXX dir/*.txt|wc -l > newfile.txt - this put the results in the newfile.txt, but I want to add another column in the newfile.txt, string 'YYYYY', separated somehow, which corresponds on the grep results?
For example grep will grep XXX dir/*.txt|wc -l >... (5 Replies)
I like to do the following, please help! Thanks a lot
for f in seq(f1 f2 f3 g1 h1 t2)
do
cut -d "+" -f2 $f > $f.nums
paste ? # each loop will attach additional column to the created file $f.nums, how to do this???
done (1 Reply)
Hi i have a file with follw data
"20090427","0","","16371311","-100200","","","","16371311","JUL","09"
In the 10th column i need to convert the month name into month number in this case JUL will be 7 and append the 10th and 11th column which shows me the output as 709. Can you suggest a shell... (11 Replies)
Hi
In a tab delimited file how can I add a column that have values concatenated from all columns.
For example
input.txt
test1 test2 test3
zz2 mm uu
pp3 yy kk
ss2 tt ll
zz3 mm uu
pp23 yy kk
ss3 tt ll
11e 22 44
33c 22 99
output.txt
test1 test2 test3 reslt (6 Replies)
I'm overwriting .unl in first run and after that in seq. runs appending by following method. Any other method or command can do it easier?
ARY_VALUE=1
while
do
if ; then
type.sql > out.unl
else
type.sql >>out.unl
fi
ARY_VALUE--;
done (3 Replies)
Hi, I have a large data file, want to separate it into 100 part and export one specific field as a file; then I want to append each part's column into one file. How to realize that?
1 2 3 1
2 3 4 2
2 3 4 3
3 3 4 4
3 4 5 5
3 4 5 6
I want the last column of the data file, e.g divide it... (5 Replies)
Experts,
I am writing a script and able to write only small piece of code and not able to collect logic to complete this task.
In input file have to look for name like like this (BGL_HSR_901_1AG_A_CR9KTR10) before sh iss neors. Record this (BGL_HSR_901_1AG_A_CR9KTR10) in csv file
Now have to... (0 Replies)