Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with cut or awk command
Top Forums Shell Programming and Scripting Help with cut or awk command Post 302908687 by ATWC on Wednesday 9th of July 2014 02:41:45 PM
Old 07-09-2014
Code:
a1,a2,"a,3,we",a4,a5,a6,a7,"a,8","","",a9,a10,a11,"","",a12
b1,"b,2",b3,b4,b5,b6,"b,7",b8,"","",b9,"",b11,"","",b11
c1,"c,2","c,3",c4,c5,c6,c7,c8,"","","c,9",c10,c11,"","",c12

i want the to cut the 8th field from the file.
so i have used the below command to replace all the , with x1C and then remove the 8 the filed and replace x1C back with comma.
Code:
sed  's/"\([a-zA-Z0-9][^,]*\),\([^,]*\)"/"\1\x1C\2"/g'  file  | awk -F, '{$8 = ""}1' OFS=, | sed 's/,,/,/g ; s/\x1C/,/g'

if i do the above command and if i have more than 1 comma inside a double quotes its not accepting
Code:
a1,a2,"a,3,we",a4,a5,a7,"a,8","","",a9,a10,a11,"","",a12
b1,"b,2",b3,b4,b5,b6,"b,7","","",b9,"",b11,"","",b11
c1,"c,2","c,3",c4,c5,c6,c7,"","","c,9",c10,c11,"","",c12

which is wrong.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cut Command error cut: Bad range

Hi Can anyone what I am doing wrong while using cut command. for f in *.log do logfilename=$f Log "Log file Name: $logfilename" logfile1=`basename $logfilename .log` flength=${#logfile1} Log "file length $flength" from_length=$(($flength - 15)) Log "from... (2 Replies)
Discussion started by: dgmm
2 Replies

2. UNIX for Dummies Questions & Answers

Regarding cut or awk command

Hi, I need a help with cut/awk command. I need to get certain values from a string provided. For example: i have a config file with below mentioned details oracle="user=name"/"pass/word"@databasename. I have used a command var1=`grep -w oracle sample.cfg | cut -d"=" -f2 | cut -d"/" -f1`. ... (10 Replies)
Discussion started by: kumars2102
10 Replies

3. Shell Programming and Scripting

a cut-command or special format pattern in awk

Hi i read data with awk, 01.07.2012 00:10 227.72 247.50 1.227 1.727 17.273 01.07.2012 00:20 237.12 221.19 2.108 2.548 17.367 01.07.2012 00:30 230.38 230.34 3.216 3.755 17.412 01.07.2012 00:40 243.18 242.91 4.662 5.172 17.328 01.07.2012 00:50 245.58 245.41 5.179 5.721 17.128... (3 Replies)
Discussion started by: IMPe
3 Replies

4. Shell Programming and Scripting

AWK command to cut the desired header columns

Hi Friends, I have a file1 i want to retrieve only the fields which have DEP,CITY,TRANS as headers in other file. Output: I want to give the input as DEP,CITY,TRANS column names to get the output. i used cut command .. but if i have 300 fileds it is more difficult to... (4 Replies)
Discussion started by: i150371485
4 Replies

5. Shell Programming and Scripting

awk and cut command

Hi, I have to display the value 16 present in "lcpu=16" which is the output of a command # vmstat System configuration: lcpu=16 mem=4096MB I used as # hdtype=`vmstat | grep "lcpu" | awk -F "=" '{print $2}'` # echo $hdtype 16 mem But I need to display only 16.. Am doing... (3 Replies)
Discussion started by: Priya Amaresh
3 Replies

6. UNIX for Dummies Questions & Answers

Cut pid from ps using cut command

hay i am trying to get JUST the PID from the ps command. my command line is: ps -ef | grep "mintty" | cut -d' ' -f2 but i get an empty line. i assume that the delimiter is not just one space character, but can't figure out what should i do in order to do that. i know i can use awk or cut... (8 Replies)
Discussion started by: ran ber
8 Replies

7. Shell Programming and Scripting

Storing command output in a variable and using cut/awk

Hi, My aim is to get the md5 hash of a file and store it in a variable. var1="md5sum file1" $var1 The above outputs fine but also contains the filename, so somthing like this 243ASsf25 file1 i just need to get the first part and put it into a variable. var1="md5sum file1"... (5 Replies)
Discussion started by: JustALol
5 Replies

8. UNIX for Beginners Questions & Answers

Cut command: can't make it cut fields

I'm a complete beginner in UNIX (and not a computer science student either), just undergoing a tutoring course. Trying to replicate the instructions on my own I directed output of the ls listing command (lists all files of my home directory ) to My_dir.tsv file (see the screenshot) to make use of... (9 Replies)
Discussion started by: scrutinizerix
9 Replies

9. Shell Programming and Scripting

Problem in extracting data using cut/awk command

Hi Everyone, I have a very simple problem and i am stuck in that from last 8 days. I tried many attempts, googled my query but all in vain. I have a text file named "test.txt" In that suppose i have contents like: Java: 1 Object oriented programming language 2 Concepts of Abstraction... (5 Replies)
Discussion started by: Abhijeet Anand
5 Replies

10. Shell Programming and Scripting

Use cut output as variable piped awk command

Hi, I would like use the output of my cut command as a variable in my following awk command. Here's what I've written. cut -f1 info.txt | awk -v i=xargs -F'' '{if($6 == $i) print $20}' summary.txt Where obviously the 'xargs' doesn't do what I want. How can I pass my cut result to my awk... (3 Replies)
Discussion started by: heyooo
3 Replies

LEARN ABOUT DEBIAN

dlagv2.f

dlagv2.f(3)							      LAPACK							       dlagv2.f(3)

NAME

       dlagv2.f -

SYNOPSIS

   Functions/Subroutines
       subroutine dlagv2 (A, LDA, B, LDB, ALPHAR, ALPHAI, BETA, CSL, SNL, CSR, SNR)
	   DLAGV2

Function/Subroutine Documentation
   subroutine dlagv2 (double precision, dimension( lda, * )A, integerLDA, double precision, dimension( ldb, * )B, integerLDB, double precision,
       dimension( 2 )ALPHAR, double precision, dimension( 2 )ALPHAI, double precision, dimension( 2 )BETA, double precisionCSL, double
       precisionSNL, double precisionCSR, double precisionSNR)
       DLAGV2

       Purpose:

	    DLAGV2 computes the Generalized Schur factorization of a real 2-by-2
	    matrix pencil (A,B) where B is upper triangular. This routine
	    computes orthogonal (rotation) matrices given by CSL, SNL and CSR,
	    SNR such that

	    1) if the pencil (A,B) has two real eigenvalues (include 0/0 or 1/0
	       types), then

	       [ a11 a12 ] := [  CSL  SNL ] [ a11 a12 ] [  CSR -SNR ]
	       [  0  a22 ]    [ -SNL  CSL ] [ a21 a22 ] [  SNR	CSR ]

	       [ b11 b12 ] := [  CSL  SNL ] [ b11 b12 ] [  CSR -SNR ]
	       [  0  b22 ]    [ -SNL  CSL ] [  0  b22 ] [  SNR	CSR ],

	    2) if the pencil (A,B) has a pair of complex conjugate eigenvalues,
	       then

	       [ a11 a12 ] := [  CSL  SNL ] [ a11 a12 ] [  CSR -SNR ]
	       [ a21 a22 ]    [ -SNL  CSL ] [ a21 a22 ] [  SNR	CSR ]

	       [ b11  0  ] := [  CSL  SNL ] [ b11 b12 ] [  CSR -SNR ]
	       [  0  b22 ]    [ -SNL  CSL ] [  0  b22 ] [  SNR	CSR ]

	       where b11 >= b22 > 0.

       Parameters:
	   A

		     A is DOUBLE PRECISION array, dimension (LDA, 2)
		     On entry, the 2 x 2 matrix A.
		     On exit, A is overwritten by the ``A-part'' of the
		     generalized Schur form.

	   LDA

		     LDA is INTEGER
		     THe leading dimension of the array A.  LDA >= 2.

	   B

		     B is DOUBLE PRECISION array, dimension (LDB, 2)
		     On entry, the upper triangular 2 x 2 matrix B.
		     On exit, B is overwritten by the ``B-part'' of the
		     generalized Schur form.

	   LDB

		     LDB is INTEGER
		     THe leading dimension of the array B.  LDB >= 2.

	   ALPHAR

		     ALPHAR is DOUBLE PRECISION array, dimension (2)

	   ALPHAI

		     ALPHAI is DOUBLE PRECISION array, dimension (2)

	   BETA

		     BETA is DOUBLE PRECISION array, dimension (2)
		     (ALPHAR(k)+i*ALPHAI(k))/BETA(k) are the eigenvalues of the
		     pencil (A,B), k=1,2, i = sqrt(-1).  Note that BETA(k) may
		     be zero.

	   CSL

		     CSL is DOUBLE PRECISION
		     The cosine of the left rotation matrix.

	   SNL

		     SNL is DOUBLE PRECISION
		     The sine of the left rotation matrix.

	   CSR

		     CSR is DOUBLE PRECISION
		     The cosine of the right rotation matrix.

	   SNR

		     SNR is DOUBLE PRECISION
		     The sine of the right rotation matrix.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   November 2011

       Contributors:
	   Mark Fahey, Department of Mathematics, Univ. of Kentucky, USA

       Definition at line 157 of file dlagv2.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.1							  Sun May 26 2013						       dlagv2.f(3)
All times are GMT -4. The time now is 09:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy