12-05-2011
Ok, this one works fine.
Thanks!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have a large number of files which are written as csv (comma-separated values).
Does anyone know of simple sed/awk command do achieve this?
Thanks!
---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------
Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies
3. Shell Programming and Scripting
Hi,
I am having the file with server names & its corresponding process, i need your help how to convert into comma separated output between server & app
#cat apps.txt
Server1
oracle
was
Server2
http
webadmin
Server3
tsm
db2
My requirement is like below.
Server1,oracle/was... (5 Replies)
Discussion started by: ksgnathan
5 Replies
4. UNIX for Dummies Questions & Answers
Hi
I have a file which is tab-delimited. Now, I'd like to print the lines which have "chr6" string in both first and second columns. Could anybody help? (3 Replies)
Discussion started by: a_bahreini
3 Replies
5. Shell Programming and Scripting
Hi,
I want to change a file file1.txt:
1234
3456
2345
6789
3456
2333
4444
As, file2.txt in Linux:
'1234','3456','2345','6789','3456','2333','4444'
Could someone please help me. (Single liner sed, awk will be welcome!) (7 Replies)
Discussion started by: wiweq05
7 Replies
6. Shell Programming and Scripting
Hi Everyone,
On my Linux box I have a text file having block of few lines and this block lines separated by one blank line. I would like to format and print these lines in such a way that this entire block of lines will come as single comma separated line & again next block of lines in next... (7 Replies)
Discussion started by: gr8_usk
7 Replies
7. UNIX for Dummies Questions & Answers
I am trying to remove columns 81-97 from a line that can be as long as 114 characters. Because a number of lines might not have under 80 characters, using the cut command following by paste could be a problem. While sed might work, is there some other utility that could do this more easily?
... (9 Replies)
Discussion started by: wbport
9 Replies
8. Shell Programming and Scripting
My OS : RHEL 6.7
I have a text file with comma separated values like below
$ cat testString.txt
'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', . . . .
I want these values to appear like below
'JOHN' ,
'KEITH' ,
'NEWMAN' ,
'URSULA' ,
'ARIANNA' ,
'CHENG',
.... (4 Replies)
Discussion started by: kraljic
4 Replies
9. Shell Programming and Scripting
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 Replies
10. UNIX for Beginners Questions & Answers
can anyone help me!!!! How to I parse the CSV file
file name : abc.csv (csv file) The above file containing data like
abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies
LEARN ABOUT DEBIAN
cssort
CSSORT(1p) User Contributed Perl Documentation CSSORT(1p)
NAME
cssort -- Czech sort
FORMAT
cssort [ "-c"list | "-f"list ["-d"regexp]] [files ...]
SYNOPSIS
cssort -c10-15,50-,25-45 < file
cssort -f3,5-6 < file
cssort -f3,5-6 -s: < file
DESCRIPTION
Cssort is a utility that sorts input lines according to rules used in the Czech language. You can run it without any options, then it just
uses whole lines for sorting. With the options, it's possible to specify parts of the lines to be used for comparison.
list
A comma-separated list of integer field numbers or field ranges. The are indexed from 1 and if a range is open (eg. "5-"), it means all
remaining fields from the starting number.
-c Stands for columns and the list that follows specifies byte ranges on the line. You will probably use this option to sort data with
fixed width fields.
-f Fields that will be used for sort.
-d Delimiter that separates fields in the -f option. It is a Perl regular expression, the default is "[ ]+", which means any number of
spaces or tabs in a row.
The program assumes ISO-8859-2 encoding. Some way to specify another input encoding will come in the next versions. If you need to sort
files with different encodings, you might want to check the cstocs conversion utility.
SEE ALSO
Cz::Sort(3), cstocs(1).
AUTHOR
Jan Pazdziora, adelton@fi.muni.cz.
perl v5.10.1 2010-01-16 CSSORT(1p)