11-20-2018
Thanks for the reply, however this would insert one row and the different columns.
I have it as space delimited columns as the raw file
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, excuse me for my poor english.
My problem is that:
I have a File
i want to add to each line of that file two strings: one at the beginning of the line, one at the ending.
string1="abcd"
string2="efgh"
i want $string1 content $string2 for each line.
Is that possible? (3 Replies)
Discussion started by: Linux-fueled
3 Replies
2. Shell Programming and Scripting
I am very new to scripting and I know this request is simple but I am having no luck with it.
I have a file a.dat with the following data in it.
aa
bb
cc
dd
I need to run a script that will take each line of a.dat and put dsjc/ubin/ in front of each record, so the output looks like
... (2 Replies)
Discussion started by: jclanc8
2 Replies
3. Shell Programming and Scripting
hi I am trying to use SED to replace the line matching a pattern using the command
sed 'pattern c\
new line
' <file1 >file 2
I got two questions
1. how do I insert a blank space at the beginning of new line?
2. how do I use this command to execute multiple command using the -e... (5 Replies)
Discussion started by: piynik
5 Replies
4. Shell Programming and Scripting
Hello people,
I am trying with sed to insert some text at the beginning of each odd line of a file but no luck. Can you please help. Awk is also suitable but I am not very familiar with it.
Thank you in advance for any help. (7 Replies)
Discussion started by: drbiloukos
7 Replies
5. Shell Programming and Scripting
Hi
I've been trying to search but couldn't quite get the answer I was looking for.
I have a a file that's like this
Time, 9/1/12
0:00, 1033
0:10, 1044
...
23:50, 1050
How do I make it so the file will be like this?
9/1/12, 0:00, 1033
9/1/12, 0:10, 1044
...
9/1/12, 23:50, 1050
I... (4 Replies)
Discussion started by: diesel88
4 Replies
6. Shell Programming and Scripting
I am having a problem where the Compute field/column is spilling over to the new line. Here's the piece of code and the o/p:-
Code Sniplet:-
for id in `qstat -u "*" -q "$Queue" -s r |sed -n '3,$ p'|awk -F" " '{print $1}'`
do
NODELIST=`cat /scratch/$id.hostlist.*|awk -F" " '{print $1,$2}'|tr '... (5 Replies)
Discussion started by: grish
5 Replies
7. Shell Programming and Scripting
Dear Team
I need to insert field(which is need to taken from previous line's first field) in first column if its blank. I had tried using sed but not find the way. Detail input and output file as below.
Kindly help for same.
INPUT:
SCGR SC DEV DEV1 NUMDEV DCP ... (7 Replies)
Discussion started by: jaydeep_sadaria
7 Replies
8. Shell Programming and Scripting
i am trying to
insert text at the beginning of every even number line
with awk
i can do it with odd number lines
with this command
awk 'NR%2{$0="some text "$0}1' filehow can i edit this command
thanks (5 Replies)
Discussion started by: bob123
5 Replies
9. UNIX for Beginners Questions & Answers
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
10. UNIX for Beginners Questions & Answers
I need to manipulate one Database file on Solaris 11 in which contains more than 5000 lines of data file path like this:
'/data1/oradata/DBNAME/system01.dbf',
'/data7/oradata/DBNAME/undotbs1_01.dbf',
'/data1/oradata/DBNAME/sysaux01.dbf',
'/data28/oradata/DBNAME/userdata01.dbf',
... (6 Replies)
Discussion started by: duke0001
6 Replies
LEARN ABOUT DEBIAN
alzabo::runtime::inserthandle
Alzabo::Runtime::InsertHandle(3pm) User Contributed Perl Documentation Alzabo::Runtime::InsertHandle(3pm)
NAME
Alzabo::Runtime::InsertHandle - A handle representing an insert
SYNOPSIS
my $handle =
$table->insert_handle
( columns => [ $table->columns( 'name', 'job' ) ] );
my $faye_row =
$handle->insert( values =>
{ name => 'Faye',
job => 'HK Pop Chanteuse' } );
my $guesch_row =
$handle->insert( values =>
{ name => 'Guesch',
job => 'French Chanteuse and Dancer' } );
DESCRIPTION
This object is analogous to a DBI statement handle, and can be used to insert multiple rows into a table more efficiently than repeatedly
calling "Alzabo::Runtime::Table->insert()".
METHODS
Objects of this class provide one public method:
insert
This method is used to insert a new row into a table.
It accepts the following parameters:
* values
This should be a hash reference containing the values to be inserted into the table.
If no value is given for a primary key column and the column is "sequenced" then the primary key will be auto-generated.
If values are not provided for other columns which were given when "Alzabo::Runtime::Table->insert_handle" was called, this method
first checks to see if a value was provided for the column when "Alzabo::Runtime::Table->insert_handle" was called. If none was pro-
vided, then the column's default value is used.
If column values were passed to "Alzabo::Runtime::Table->insert_handle", then these can be overridden by values passed to this method.
It is not possible to override column values that were given as SQL functions when "Alzabo::Runtime::Table->insert_handle" was called.
This method returns a new "Alzabo::Runtime::Row" object.
Throws: "Alzabo::Exception::Logic", "Alzabo::Exception::Params"
perl v5.8.8 2007-12-23 Alzabo::Runtime::InsertHandle(3pm)