10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Sorry to bother you guys again. I have a file1 with multiple columns like this:gga_miR_100 gga_miR_300 gga_miR_3500 gga_miR_4600 gga_miR_5600 gga_miR_30 gga_miR_500
kj rwg ghhh jy jyu we vf
5g 5hg h6 56h i8 45t 44r4
4bg 4r546 9lgtr (fer) 4fr f433
3feev f4 bf4 35g
vfr ge
2rr
... (5 Replies)
Discussion started by: yuejian
5 Replies
2. Shell Programming and Scripting
Hello,
Got a CSV file which contains 21 columns
Need to convert the file to Pipe delimiter and Few columns text data contains new line
Example
1,2,3,"ABC" 8" ABC,5,6,7
1,2,3,"ABC"
8" ABC,5,6,7 ( New Line)
1,2,3,""ABC" 8" ABC", 5,6,7
1,2,3,"ABC"
,5,6,7(New line)
Expected... (8 Replies)
Discussion started by: krux_rap
8 Replies
3. Shell Programming and Scripting
Example:
10.160.101.160,0707073711,22.203.203.200
10.160.101.160,0707075132,22.203.210.249
10.160.101.160,0707085436,22.203.210.249
10.160.101.160,0707091712,22.203.221.176
10.160.101.160,0707091811,22.203.221.176
10.160.101.160,0707091845,22.203.221.176... (1 Reply)
Discussion started by: BrownBob
1 Replies
4. Shell Programming and Scripting
Need perl or shell script to sort vertical lines to horizontal line in csv format
My file like below
-------------------------
================================================================================
PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ... (4 Replies)
Discussion started by: sreedhargouda.h
4 Replies
5. Shell Programming and Scripting
Hi ,
I'm a newbie.Never worked on Unix before. I want a shell script to perform the following:
I want to extract strings from each line ,based on the type of line(Nameline,Subline) and output it to another file.Below is a sample format.
2010-12-21 14:00"1"Nameline"Midterm"First Name:Jane ... (4 Replies)
Discussion started by: angie1234
4 Replies
6. Shell Programming and Scripting
Hello Gurus
I have a source file which has the first line as header and the rest are the records
I need to extract the first column from the second line to extract a value
I/P
... (7 Replies)
Discussion started by: Pratik4891
7 Replies
7. Shell Programming and Scripting
I have a csv file with occasional multiple entries in the second column.
111111,104,07-24-2011,3.15,N,
222222,020 140,07-24-2011,10.00,N,I want the result
111111,104,07-24-2011,3.15,N,
222222,020,07-24-2011,10.00,N,
222222,140,07-24-2011,10.00,N,
I know I can get the output of the second... (5 Replies)
Discussion started by: ffdstanley
5 Replies
8. Shell Programming and Scripting
Hi All,
i have a csv file .
In the 7th column i have data that has line feed in it.
Requirement is to remove the line feed from the 7th column whenever it appears
There are 11 columns in the file
C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11
The value in C7 contains line feed ( Alt + Enter ),... (2 Replies)
Discussion started by: r_t_1601
2 Replies
9. Shell Programming and Scripting
Hi All,
My requirement is to remove line (3 Replies)
Discussion started by: r_t_1601
3 Replies
10. UNIX for Dummies Questions & Answers
Hello experts,
I am trying to read a line from a csv file that contains '.doc' and print the second column in all caps.
e.g.
My csv file contains:
Test.doc|This is a Test|test1|tes,t2|test-3
Test2.pdf|This is a Second Test| test1|tes,t2|t-est3
while read line
do
echo "$line" |... (3 Replies)
Discussion started by: orahi001
3 Replies