04-03-2014
You welcome...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Gurus,
I have a requirement like this and have to create a UX shell scripts. Thanks in advance.
File-in:
------
Header2007-12-012007-11-21
100|xyz|was
101|wsa|qws
......
.......
Output should be:
-------------------
2007-12-01|100|xyz|was
2007-12-01|101|wsa|qws
......
.......... (7 Replies)
Discussion started by: vsubbu1000
7 Replies
2. Shell Programming and Scripting
$ cat log.txt
Name Age Sex Lcation nfld alias xsd
CC 25 M XYZ asx KK Y
BB 21 F XAS awe SS N
SD 21 M AQW rty SD A
How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column?
so that the final output will become:
Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies
3. Ubuntu
Hi;
I've been searching posts to find a solution to what I'm trying to do, but I've have NOT found anything yet.
I have a file (file1) with 300K columns and 1411 rows, the columns don't have a column no. header (No header at all) and I'm trying to fetch the information from specific columns.... (3 Replies)
Discussion started by: sogi
3 Replies
4. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies
6. Shell Programming and Scripting
Hi
I have in put file A.txt
ABCDE1 JFHFJFJF3 1 1 SC1 12/10
ABCDE2 JFHFJFJF5 1 1 SC1 12/10
ABCDE3 JFHFJFJF5 1 1 SC1 12/10
ABCDE4 JFHFJFJF6 1 1 SC1 12/10
I want output in .csv with header:
Name SUb_N x y No Board
ABCDE1 JFHFJFJF3 1 1 SC1 12/10
ABCDE2 JFHFJFJF5 1 1 SC1... (7 Replies)
Discussion started by: pareshkp
7 Replies
7. UNIX for Dummies Questions & Answers
Hi! Is there a way to append column and row header to a file in awk script.
For example if I have
Jane F 39 manager
Carlos M 40 system administrator
Sam F 20 programmer
and I want it to be
# name gend age occup
1 Jane F 39 manager
2 Carlos M ... (4 Replies)
Discussion started by: FUTURE_EINSTEIN
4 Replies
8. Shell Programming and Scripting
Hi,
I have an input like this
1 2 3 4
2 3 4 5
4 5 6 7
I would like to count the no. of columns and print a header with a prefix "Col".
I would also like to count the no. of rows and print as first column with each line number with a prefix "Row"
So, my output would be
... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
9. Shell Programming and Scripting
Hi All,
Could anyoone please let me know how do I get sqlplus column header once in csv file
Scripts are below:
cat concreq.sh
#!/bin/bash
. $HOME/.profile
while ; do
sqlplus apps/pwd <<-EOF
set lines 100 pages 100
col "USER_CONCURRENT_QUEUE_NAME" format a40;
--set termout off... (5 Replies)
Discussion started by: a1_win
5 Replies
10. Shell Programming and Scripting
Hello all,
I have a csv with with different testcase values in column 5.
year,min,max,Instrument,Testcase
2016,201,1003,GEOTROPH-02116,TATA7980
2016,53,1011,GEOTROPH-01963,TATA7980
2016,3,1024,GEOTROPH-02067,TATA7980
2016,203,1027,GEOTROPH-02011,TATA7980... (16 Replies)
Discussion started by: senhia83
16 Replies
LEARN ABOUT DEBIAN
jifty::dbi::column
Jifty::DBI::Column(3pm) User Contributed Perl Documentation Jifty::DBI::Column(3pm)
NAME
Jifty::DBI::Column - Encapsulates a single column in a Jifty::DBI::Record table
DESCRIPTION
This class encapsulates a single column in a Jifty::DBI::Record table description. It replaces the _accessible method in
Jifty::DBI::Record.
It has the following accessors: "name type default validator boolean refers_to readable writable length".
new
is_numeric
Returns true if the column is of some numeric type, otherwise returns false.
is_string
Returns true if this column is a text field
is_boolean
Returns true if this column is a boolean
serialize_metadata
Returns a hash describing this column object with enough detail to fully describe it in the database. Intentionally skips "record_class",
all column attributes starting with "_", and all column attributes which are undefined. The "known" attributes in the "attributes" hash
are flattened and returned as well. The list of known attributes are:
container
label hints render_as
display_length
valid_values
available_values
autocompleted
documentation
no_placeholder
Setting this to a true value causes "load_by_cols" in Jifty::DBI::record to not use a placeholder when loading the column. This can
allow the database to come up with better query plans in some cases.
serialize_metadata2
Returns a hash describing this column object with enough detail to fully describe it in the database. Intentionally skips "record_class",
all column attributes starting with "_", and all column attributes which are undefined.
validator
Gets/sets the validator coderef for the column.
read
DEPRECATED. Use "$column->readable" instead.
write
DEPRECATED. Use "$column->writable" instead.
length
DEPRECATED. Use "$column->max_length" instead.
until
DEPRECATED. Use "$column->till" instead.
active
Returns the a true value if the column method exists for the current application version. The current application version is determined by
checking the "schema_version" in Jifty::DBI::Record of the column's "record_class". This method returns a false value if the column is not
yet been added or has been dropped.
This method returns a false value under these circumstances:
o Both the "since" trait and "schema_version" method are defined and "schema_version" is less than the version set on "since".
o Both the "till" trait and "schema_version" method are defined and "schema_version" is greater than or equal to the version set on
"till".
Otherwise, this method returns true.
perl v5.14.2 2012-01-25 Jifty::DBI::Column(3pm)