10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have records in unix file like below. In this file, we have empty fields from 4th Column to 22nd Column. I have some 200000 records in a file. I want to extract records only which have empty fields from 4th field to 22nd filed. This file is comma separated file. what is the unix... (2 Replies)
Discussion started by: rakeshp
2. Shell Programming and Scripting
I have a file with colon separated values like below. How can i get those lines whose third field is 0 (zero). In the below example, lines starting with stapler and tempo has its third field as 0
$ cat list.txt
kepler:uic:5:jam... (8 Replies)
Discussion started by: John K
3. Shell Programming and Scripting
In my file (which is "," delimited and text qualifier is "), I have to extract a particualr field.
expected is the 2nd field:
I tried the basic cut -d "," -f 2 file 1, this gave me
aa alone instead aa,b.
A small hint ot help on this will be very... (5 Replies)
Discussion started by: machomaddy
4. Shell Programming and Scripting
I have a csv file that I need to extract some data from depending on another field after reading info from another text file.
The text file would say have 592560 in it.
The csv file may have some data like so
Field 1 Field2 Field3 Field4 Field5 Field6
20009756 1 ... (9 Replies)
Discussion started by: GroveTuckey
5. Shell Programming and Scripting
I have a file(InputFile.csv) with the following columns(the columns are pipe-delimited):
Now for this file, I have to get those records which fulfil the following condition:
If "ColB" is NOT NULL and "ColD" has values one of the following... (9 Replies)
Discussion started by: mehimadri
6. UNIX for Dummies Questions & Answers
Within a UNIX shell script I need to extract a value from an XML field. The field will contain different values but will always be 6 digits in length. E.g.:
I've tried various ways but no luck. Any ideas how I might get the provider id (in this case... (2 Replies)
Discussion started by: pnclayt11
7. Shell Programming and Scripting
:confused: I have a tab delimited file that I need to extract data from and into a file with specific field specs. Each field has to be a certain amount of characters. So, the name field (from delimited file) might have only 15 characters but needs to be 25 (in new file) so I need to insert spaces... (5 Replies)
Discussion started by: criddel
8. Shell Programming and Scripting
path = /first/second/third/fourth. i want to extract /first/second/third from path.my program something like this ....
noc=`echo $path|tr '/' '\n'|wc -w`
var='echo $noc|cut -d'/' -f 1-$noc --> is giving error.
why $noc is not working here.any other... (3 Replies)
Discussion started by: kcp_pavan
9. UNIX for Dummies Questions & Answers
below are the contents of file 'tmp.out':
How do I extract the 2nd and 3rd columns of file 'tmp.out' only when the first column equals '1'.
Note that this file will be huge; atleast 5million+ rows, so I want to avoid looping... (4 Replies)
Discussion started by: ChicagoBlues
10. UNIX for Dummies Questions & Answers
Hello, was looking for some help on extracting a field from the passwd file.
So far I have made a copy of the passwd file and changed my rights so I can edit it. Every user's password is coded as an :x:, and my goal was to change that x to a blank, and then try to extract any user with that field... (2 Replies)
Discussion started by: xBuRnTx