$ cat myfile
Introduction:Intro_123.html
Product definition:Prod_def.html
System Setup:SSetup-64bit.html
Setting up user accounts:Set_user_acc.html
Code:
$ nawk -F: '{print "The filename is:",$1,"and the title of the page is:",$2}' myfile
The filename is: Introduction and the title of the page is: Intro_123.html
The filename is: Product definition and the title of the page is: Prod_def.html
The filename is: System Setup and the title of the page is: SSetup-64bit.html
The filename is: Setting up user accounts and the title of the page is: Set_user_acc.html
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Hi everybody (first time posting here)
I have a file1 that looks like >
1,101,0.1,0.1
1,26,0.1,0.1
1,3,0.1,0.1
1,97,0.5,0.5
1,98,8.1,0.218919
1,99,6.2,0.248
2,101,0.1,0.1
2,24,3.1,0.147619
2,25,23.5,0.559524
2,26,34,0.723404with 762 lines..
I have another 'similar' file2 >
... (10 Replies)
Hello,
I'm trying to get the TOP and BASE numbers printed out
File looks like this:
2300 CAR # 2300 is the TOP
2310 CAR
2335 CAR
2455 CAR # 2455 is the BASE
1000 MOTOR # 2455 will become this TOP
2000 MOTOR
3000 MOTOR
4000 MOTOR # 4000 is the BASE
2345 BIKE # 4000... (8 Replies)
Hi experts,
I need to print the first field first then last two fields should come next and then i need to print rest of the fields.
Input :
a1,abc,jsd,fhf,fkk,b1,b2
a2,acb,dfg,ghj,b3,c4
a3,djf,wdjg,fkg,dff,ggk,d4,d5
Expected output:
a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
I'm trying to compare 2 files for differences in a selct number of fields. When differnces are found it will write the whole record of the second file including appending '|C' out to a delta file. Each record will have 20 fields, but only want to do comparison of 1st 15 fields. The 1st field of... (7 Replies)
Hi
I have a file as below
<field1> <field2> <field3> ... <field_num1> <field_num2>
Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields.
I tried this and it doesn't sort on the difference field .. Appreciate your help.
cat... (9 Replies)
A record contains 50 fields separated by "~". I need to assign each of these fields to different variables. Following is the shell script approach I tried.
RECORD="FIELD1~FIELD2~FIELD3~FIELD4~FIELD5~...........~FIELD50"
VAR1=$(echo ${RECORD} | cut -d"~" -f 1)
VAR2=$(echo ${RECORD} | cut... (5 Replies)
The below code works great, kindly provided by @Don Cragun, the lines in bold print the current output. Since some of the fields printed can be blank some of the fields are shifted. I can not seem too add . to the blank fields like in the desired output. Basically, if there is nothing in the field... (10 Replies)
Hi,
Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account.
$ head -500 x.txt y.txt
==> x.txt <==
TEST01 APP_USER_PROFILE
USER03 APP_USER_PROFILE
TEST02 APP_USER_EXP_PROFILE
TEST04 APP_USER_PROFILE
USER01 ... (3 Replies)
Discussion started by: newbie_01
3 Replies
LEARN ABOUT DEBIAN
wiki::toolkit::setup::sqlite
Wiki::Toolkit::Setup::SQLite(3pm) User Contributed Perl Documentation Wiki::Toolkit::Setup::SQLite(3pm)NAME
Wiki::Toolkit::Setup::SQLite - Set up tables for a Wiki::Toolkit store in a SQLite database.
SYNOPSIS
use Wiki::Toolkit::Setup::SQLite;
Wiki::Toolkit::Setup::SQLite::setup( $dbfile );
DESCRIPTION
Set up a SQLite database for use as a Wiki::Toolkit store.
FUNCTIONS
setup
use Wiki::Toolkit::Setup::SQLite;
Wiki::Toolkit::Setup::SQLite::setup( $filename );
or
Wiki::Toolkit::Setup::SQLite::setup( $dbh );
Takes one argument - either the name of the file that the SQLite database is stored in or an active database handle.
NOTE: If a table that the module wants to create already exists, "setup" will leave it alone. This means that you can safely run this
on an existing Wiki::Toolkit database to bring the schema up to date with the current Wiki::Toolkit version. If you wish to completely
start again with a fresh database, run "cleardb" first.
An optional second argument may be passed specifying the schema version to use; this is ONLY intended to be used during unit testing
and should not normally be specified.
cleardb
use Wiki::Toolkit::Setup::SQLite;
# Clear out all Wiki::Toolkit tables from the database.
Wiki::Toolkit::Setup::SQLite::cleardb( $filename );
or
Wiki::Toolkit::Setup::SQLite::cleardb( $dbh );
Takes one argument - either the name of the file that the SQLite database is stored in or an active database handle.
Clears out all Wiki::Toolkit store tables from the database. NOTE that this will lose all your data; you probably only want to use this
for testing purposes or if you really screwed up somewhere. Note also that it doesn't touch any Wiki::Toolkit search backend tables; if
you have any of those in the same or a different database see Wiki::Toolkit::Setup::DBIxFTS or Wiki::Toolkit::Setup::SII, depending on
which search backend you're using.
ALTERNATIVE CALLING SYNTAX
As requested by Podmaster. Instead of passing arguments to the methods as
($filename)
you can pass them as
( { dbname => $filename } )
or indeed
( { dbh => $dbh } )
Note that's a hashref, not a hash.
AUTHOR
Kake Pugh (kake@earth.li).
COPYRIGHT
Copyright (C) 2002-2004 Kake Pugh. All Rights Reserved.
Copyright (C) 2006-2009 the Wiki::Toolkit team. All Rights Reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Wiki::Toolkit, Wiki::Toolkit::Setup::DBIxFTS, Wiki::Toolkit::Setup::SII
perl v5.14.2 2011-09-25 Wiki::Toolkit::Setup::SQLite(3pm)