10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a text file where some of the values in columns are missing:
Input:
QhFudW3dKSYL2NTQUA 1 11133999-11134048
uhIp9KxB6USIy16CEY 1 11126760-11126774
11126775-11126805
11128065-11128068
6epeZ6CTNW4Au8uXys 1 24480823-24480872
Tp3nvutucBZ13CjuXc 1 155204870-155204891... (3 Replies)
Discussion started by: evelibertine
3 Replies
2. UNIX for Dummies Questions & Answers
I have a text file which includes empty columns with missing values. I want to fill the empty columns with the character "X". How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
3. UNIX for Dummies Questions & Answers
How do you grep cells that contain a specific string. I tried grep but it greps the whole line and not just the cells. Thanks! (4 Replies)
Discussion started by: evelibertine
4 Replies
4. UNIX for Dummies Questions & Answers
I have a text file that looks like the following:
5.644 39.2% 0.00 0.50 rs1695626 4 -0.003 0.21% 0.03 0.73
rs1763326 3 -0.001 0.03% 0.00 0.89
5.645 39.2% 0.00 0.50 rs770721 2 -0.002 0.07% 0.01 0.84... (7 Replies)
Discussion started by: evelibertine
7 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have a file with fixed number of columns (total 58 columns) delimeted by pipe (|). Due to a bug in the application the export file does not come with fixed number of columns. The missing data columns are being replaced by blank in the output file. In one line I can have 25 columns (33... (1 Reply)
Discussion started by: yale_work
1 Replies
6. UNIX for Dummies Questions & Answers
I have a text file that looks like the following:
rs529715 CFD
rs1550758 CIDEB
Magmas
rs12542019 CPNE1
RBM12
rs10515181 CPNE1
RBM12
rs4411112 CPT1A
Some rows have 1 column, whereas some have 2. The ones that have 2 columns have one column (1st column) that start with rs.
I need to... (6 Replies)
Discussion started by: evelibertine
6 Replies
7. Shell Programming and Scripting
Hi UNIX Gods!
Is it possible to merge two cells in .csv file using unix commands?
Imagine that this is my present csv file opened via excel:
Gate Reports| |
fatal alerts | 200 |
is is possible to make it look like this using unix?
Gate Reports |
fatal... (1 Reply)
Discussion started by: 4dirk1
1 Replies
8. Shell Programming and Scripting
hi,
i have text file that file contains below information.
Name,Roll,Mark,Total
Sivasankar,2120,89,410
Raja,2212,87,425
i need to convert text file to CSV file also the heading(Name,Roll,Mark,Total) font should be BOLD and color should be RED. how can i set fonts in csv (5 Replies)
Discussion started by: rsivasan
5 Replies
9. Shell Programming and Scripting
Hi
I have 2 csv files which looks like the following and i have to compare the 2 CSVs and create a third file such that if the value of the 1st cell in A.CSV and the value of the first cell in the B.CSV are same, it should print "SAME" in the third file or else print NOT SAME. Likewise i need... (19 Replies)
Discussion started by: meva
19 Replies
10. UNIX for Dummies Questions & Answers
Hi All,
I am checking for a empty input file to do some further action , but I am getting exit status 0 in both the cases , for empty and non empty file both.
The value of $? is coming 0 in if part also and else part too.
#!/bin/ksh
if ]; then
echo "data"
# exit 0
echo "$?"
else... (4 Replies)
Discussion started by: mavesum
4 Replies