10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have Excel file with the below three columns, i need your expertise in converting this to .csv file delimiter "|"
Excel -
Serial Number Serial Name Serial Brand
111 test sample
123 test2 sample1
134 ... (9 Replies)
Discussion started by: kiran_hp
9 Replies
2. UNIX for Advanced & Expert Users
Hi All,
Am needing advise on how to convert xls file to xlsx format on Solaris unix command line or scripting. I tried searching online but it looks like I need to either use Perl packages of Excel or Python packages or some other 3rd party tool. Problem is to install any of these will require... (2 Replies)
Discussion started by: arvindshukla81
2 Replies
3. Shell Programming and Scripting
Dear folks
I have 300 files which one of them are looking like:
1.SNP
0
0
1
0
I am looking for desire output:
1.SNP 0 0 1 0
I used this below command to run all of the 300 file at the same time
for file in *.SNP; do awk '{printf( "%s ", $1 );} END {printf("\n");}' $file >... (1 Reply)
Discussion started by: sajmar
1 Replies
4. Shell Programming and Scripting
I have a set of values separated by a tab
ch:12 1 3 4
ch:13 3 3 4
ch:25 1 8
ch:23 2 8 1
There is a missing value in the third column and i would like replace it with
NA such that the final output would look like
ch:12 1 3 ... (7 Replies)
Discussion started by: johnkim0806
7 Replies
5. Shell Programming and Scripting
Hi All,
Random question, how would you convert a data file from a list like so:
12345
12346
12347
12348
12349
12350
... <snip 100+ lines> ...
to comma separated X columns across:
12345,12346,12347
12348,12349,12350
Why would you want to do this? The background to this is a... (2 Replies)
Discussion started by: craigp84
2 Replies
6. Shell Programming and Scripting
dear friends I want to convert four column data to one column data. For example:
from
1, 2, 3, 4
5, 6, 7, 8to
1
2
3
4
5
6
7
8what is the general command for that type of convertion.
thanks (5 Replies)
Discussion started by: rpf
5 Replies
7. Shell Programming and Scripting
Hi - I have seen some similar posts but I am a bit stumped here
below is the first line of a 'od -c filename' command. I want to change the \0 to \n
0000000 l s \0 c d - \0 c d . . \0 l s
I have tried a sed construct in a script.........
sed... (2 Replies)
Discussion started by: ajcannon
2 Replies
8. SCO
I use Sco_Sv 3.2v5.0.5 with parellel conection using dump terminals and i want to convert them to desktop pc.
Anybody knows what hardware and other thing that would be involved? (3 Replies)
Discussion started by: seeyou
3 Replies
9. Shell Programming and Scripting
Hi ...
I am trying to calculate the time needed for a command to execute..
but the resulting value is getting as string..
so i am not able to use "expr " command..
please help me to convert the value to integer so that i can proceed with my script..
Regards
esham (1 Reply)
Discussion started by: esham
1 Replies
10. UNIX for Dummies Questions & Answers
When I create filesystems in AIX i often get confused(using smit)
When you specify size in aix, it is asked like this
SIZE of file system (in 512-byte blocks)
I never seem to grasp this, what is the equation to get say
500mb? Or is there a program anyone knows of that does this, like a... (1 Reply)
Discussion started by: csaunders
1 Replies