Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to concat columns?
Top Forums Shell Programming and Scripting How to concat columns? Post 302808139 by karthikeayan on Thursday 16th of May 2013 02:36:11 AM
Old 05-16-2013
Doubt
Quote:
Originally Posted by Vikram_Tanwar12
Hi Karthikeayan,

Code:
awk -F"[ /]+"       - This is for field seperator means removing this slash sign
$2!~/^3/            - This means $2 means second column should not be starting with value 3
{print $4"["$2"]"}' - This means print 4rth column which is BPEL name together with second column which is not having 3 or 3.* value.


hi Vikram,

thanks for the quick reply. I have one question..
if $2 has the value more than 3, like 4.0... then how can we ignore that line?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Concat date

How do I concat a date to a filename eg; filename: jjjrtup to become jjjrtup29052002 mv jjjrtup jjjrtup ? date what should ? be (2 Replies)
Discussion started by: drukkie
2 Replies

2. Shell Programming and Scripting

Concat

HI all, How to concat two strings in Shell scrpits suppose x=a y=b i want to display it as ab How to do it ? Thanks.. (1 Reply)
Discussion started by: dhananjaysk
1 Replies

3. Shell Programming and Scripting

concat string

hey, I want to concat whole bunch of strings together but somehow they don't turn out the way I want them to a="HELLO " b="WORLD " c=$a$b I was expecting c to be "HELLO WORLD " but it... (1 Reply)
Discussion started by: mpang_
1 Replies

4. Shell Programming and Scripting

concat fields

hi I have a file, I need to concatenate depening on the no of columns i need to concatenate. for example i need to concatenate field1,filed34,field2( no of columns is not always 3, it can be any number of fields) concat.ksh field1 field34 field2 how to achieve this, is there any argv ,argc... (10 Replies)
Discussion started by: markjason
10 Replies

5. Shell Programming and Scripting

Awk Concat

Hi All this may be somewhere in internet , but couldnt find the it. i have file as abc01 2010-07-01 12:45:24 2010-07-01 12:54:35 abc02 2010-07-01 12:59:24 2010-07-01 01:05:13 abc03 . . . the output using awk should look like this abc01|2010-07-01 12:45:24|2010-07-01 12:54:35... (3 Replies)
Discussion started by: posner
3 Replies

6. Shell Programming and Scripting

concat 3 files

Hello Unix gurus, how to concat 3 files content side by side . i have 3 files more report1.txt select *from tab1 A JOIN tab1 B ON more report2.txt A.PK1=B.PK1 where more report3.txt A.AAA <> B.AAA or A.BBB <> B.BBB or A.CCC<> B.CCCC or .. .. .. A.ZZZ <> B.ZZZ; if i concatinate... (3 Replies)
Discussion started by: kanakaraju
3 Replies

7. Shell Programming and Scripting

Concat

Hi All, My Input file contains: Input.txt Name|Marks ABC|10 GHI|10 JKL|20 MNO|20 PQR|30 Output.txt MARKS|NAME 10|ABC,GHI 20|JKL,MNO 30|PQR Thanks in advance (4 Replies)
Discussion started by: kmsekhar
4 Replies

8. Shell Programming and Scripting

Concat required

Hi Folks The below is code is giving me value 30. cal | sed '/^$/d' | tail -1 | awk '{printf $NF-1}' Actually the text is like below. echo "you should reply on 30-Jan-2013 evening EST. Here how should i con-cat above logic in that text? (1 Reply)
Discussion started by: coolboy98699
1 Replies

9. Shell Programming and Scripting

Concat name

Hi, I need help to combine the first 7 character of firstname if it is longer than 7and combine with the first character of lastname. ex: username lastname => usernaml user lastname => userl Thanks in advance. (10 Replies)
Discussion started by: xitrum
10 Replies

10. UNIX for Advanced & Expert Users

Concat data

All, I have 2 files A and B with some data. Now i want to concat data from both the files in to 3rd file.Please help me with a single command line. A--123456789 B--jlsjdfkajsjas output file C should be 123456789,jlsjdfkajsjas (2 Replies)
Discussion started by: kiranparsha
2 Replies

LEARN ABOUT PHP

db2_field_type

DB2_FIELD_TYPE(3)							 1							 DB2_FIELD_TYPE(3)

db2_field_type - Returns the data type of the indicated column in a result set

SYNOPSIS

       string db2_field_type (resource	$stmt, mixed  $column)

DESCRIPTION

	Returns the data type of the indicated column in a result set.

PARAMETERS

	      o $stmt
		- Specifies a statement resource containing a result set.

	      o $column
		-  Specifies  the  column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
		string containing the name of the column.

RETURN VALUES

	Returns a string containing the defined data type of the specified column. If the specified column does  not  exist  in  the  result  set,
       db2_field_type(3) returns FALSE.

SEE ALSO

       db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_width(3).

PHP Documentation Group 													 DB2_FIELD_TYPE(3)
All times are GMT -4. The time now is 05:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy