02-13-2019
Please make sure your files don't contain DOS line termnators (^M = \r = 0x0D = <CR>).
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all!
I have two files containing one field each.
The fields consist of numbers separated in records e.g.
file1.dat
1657
2345
5678
5676
7978
7856
5686
5676
8990
.
.
. (2 Replies)
Discussion started by: bjorb
2 Replies
2. Shell Programming and Scripting
I was wondering if there was a way to modify a tab delimited text file, up to 185,000 lines long by adding a repeated field to a block of 20 data , then repeat the process until the file is processed.
The current file looks like: ... (3 Replies)
Discussion started by: saint65
3 Replies
3. Shell Programming and Scripting
Hi,
I have a huge text file. It looks like
abcde bangalo country 12345 lastfield
i want to get first 3 characters from field1 and first 3 characters from field 2 and insert the result as a new field. example the result should be:
abcde bangalo abcban country 12345 lastfield
Please... (4 Replies)
Discussion started by: ajithshankar@ho
4 Replies
4. Shell Programming and Scripting
I have a large flat file with variable length fields that are pipe delimited. The file has no new line or CR/LF characters to indicate a new record. I need to parse the file and after some number of fields, I need to insert a CR/LF to start the next record.
Input file ... (2 Replies)
Discussion started by: clintrpeterson
2 Replies
5. Shell Programming and Scripting
Hi,
I want to add two fields with values '1000' and 'XYZ-1234' at the end of every line in a comma delimited file.
Should I use any command in a loop to add the fields or using any single command Shall I acheive it?
Kindly help me in code.
Thanks,
Poova. (6 Replies)
Discussion started by: poova
6 Replies
6. Shell Programming and Scripting
Hi everyone,
after entering the following command:
/usr/sfw/bin/snmpwalk -v2c -c "sMart5snmPaCC3ss" ABI0-QCLAMI-CE2 1.3.6.1.4.1.9.9.43.1.1.6.1.7
I get this output:
SNMPv2-SMI::enterprises.9.9.43.1.1.6.1.7.24 = INTEGER: 194
SNMPv2-SMI::enterprises.9.9.43.1.1.6.1.7.25 = INTEGER: 194... (4 Replies)
Discussion started by: omoyne
4 Replies
7. Shell Programming and Scripting
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)
Discussion started by: murpholinox
10 Replies
8. Shell Programming and Scripting
In the attached file I am trying to use awk to extract multiple values and create the tab-delimited desired output.
In the output R_Index is a the sequential # and Pre_Enrichment is defaulted to ..
I can extract from the values to the side of the keywords, but most are above and I can not... (2 Replies)
Discussion started by: cmccabe
2 Replies
9. UNIX for Beginners Questions & Answers
So, I have three problems that cover this subject.
First one asks me to find the number of fields in the file that contain the substring "he". I found the number of fields, but the problem I have is that they are displaying by each record. I want to add all of the records' fields together.
With... (2 Replies)
Discussion started by: mc10
2 Replies
LEARN ABOUT DEBIAN
tangram::type::scalar
Tangram::Type::Scalar(3pm) User Contributed Perl Documentation Tangram::Type::Scalar(3pm)
NAME
Tangram::Type::Scalar - map scalar fields
SYNOPSIS
use Tangram;
Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
string => [ qw( name firstName gender ) ],
int => [ qw( age ) ],
real => [ qw( height weight ) ],
$schema = Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
string =>
{
name => { sql => 'VARCHAR(100)' },
1stname => {
col => 'firstName',
sql => 'VARCHAR(100) NULL' },
gender => undef()
},
DESCRIPTION
Classes Tangram::Type::String, ::Int and ::Real and ::Ref are responsible for mapping the various subtypes of scalars. The first three map-
pings are documented here since they differ very little. See Tangram::Type::Ref::FromMany for information on mapping references.
Tangram::Type::String uses DBI's quote() method to quote strings if that method is available, thus making it possible to store binary
objects or multiline text in databases that support it (thanks to Marian Kelc <marian.kelc@ruhr-uni-bochum.de> for suggesting this improve-
ment).
The three predefined typetags "string", "int" and "real" are for the corresponding Perl scalar subtypes.
Each scalar field is stored in a single column of the table associated to the class.
The persistent fields may be specified either as a hash or as an array of field names.
In the hash form, each entry consists in a field name and an associated option hash. The option hash may contain the following fields:
* col
* sql
* automatic
"col" sets the name of the column used to store the field's value. This field is optional, it defaults to the persistent field name. Over-
ride if the field name is not an acceptable SQL column name.
"sql" sets the SQL type of the column. Used by Schema::deploy() when initializing a database. Defaults to 'VARCHAR(255) NULL' for strings,
'INT NULL' for ints and 'REAL NULL' for reals.
"automatic", if set to true, tells Tangram not to save the field to storage. This is useful for auto-increment or timestamp columns.
The persistent fields may also be specified as an array of strings, in which case the defaults are used.
perl v5.8.8 2006-03-29 Tangram::Type::Scalar(3pm)