I have a raw data file:
70,1,1,-53.25
70,1,1,,,,-57.50
70,1,1,,,,,,,,,,-48.00
I want to have a output file with the formatting below:
70,1,1,-53.25,,,,-57.50,,,,,-48.00
I mean if these rows have the first similar three variables which will be group into one row. And I try to write a... (1 Reply)
Dear Experts,
I have a file containing text like below
123
456
789
012
345
I want to save each line in array.
and print each array index as per my requirement.
For Example array will print 456
array will print 012
Thanks for your Help. (14 Replies)
Hi all,
i have a data array as follows.
array=ertfgj2345
array=456ttygkd
.
.
.
array=errdjt3235
so number or elements in the array can varies depending on how big the data input is.
now i have a variable, and it is $1 (there are $2, $3 and so on, i am only interested in $1).
... (9 Replies)
Hi I am trying to get data from an array and input it into awk. Please see below:
###
#!/bin/bash
#declare array
declare -a ARRAY
exec 10</path/to/arrayfile
let count=0
while read LINE <&10; do
ARRAY=$LINE
((count++))
done
#close file
exec 10>&-
ENDLOOP=0 (10 Replies)
Hello experts,
I'm stuck with this script for three days now. Here's what i need.
I need to split a large delimited (,) file into 2 files based on the value present in the last field.
Samp: Something.csv
bca,adc,asdf,123,12C
bca,adc,asdf,123,13C
def,adc,asdf,123,12A
I need this split... (6 Replies)
I'm trying to get the output from awk into a bash array. Here is my script.
#!/bin/bash
while :
do
app=$( osascript -e "tell application \"System Events\" to return name of every process whose frontmost is true" )
echo "$app"
if ava ]]
then
ps -ax | grep -v awk | pids=( $(awk... (5 Replies)
Hello All,
Can you please help me with the below.
#!/bin/bash
ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5 EXTRACT_DT:30-SEP-12 VER_NUM:1"
ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5... (14 Replies)
Hello. I'm trying to figure out which one of these is not true about an awk array.
-You do not need to formally declare an array; it is created automatically on first assignment
-Array elements can only be addressed using an index
... (1 Reply)
Discussion started by: Eric7giants
1 Replies
LEARN ABOUT PHP
pg_field_size
PG_FIELD_SIZE(3)PG_FIELD_SIZE(3)pg_field_size - Returns the internal storage size of the named fieldSYNOPSIS
int pg_field_size (resource $result, int $field_number)
DESCRIPTION pg_field_size(3) returns the internal storage size (in bytes) of the field number in the given PostgreSQL $result.
Note
This function used to be called pg_fieldsize(3).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $field_number
- Field number, starting from 0.
RETURN VALUES
The internal field storage size (in bytes). -1 indicates a variable length field. FALSE is returned on error.
EXAMPLES
Example #1
Getting information about fields
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
$i = pg_num_fields($res);
for ($j = 0; $j < $i; $j++) {
echo "column $j
";
$fieldname = pg_field_name($res, $j);
echo "fieldname: $fieldname
";
echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters
";
echo "storage length: " . pg_field_size($res, $j) . " bytes
";
echo "field type: " . pg_field_type($res, $j) . "
";
}
?>
The above example will output:
column 0
fieldname: author
printed length: 6 characters
storage length: -1 bytes
field type: varchar
column 1
fieldname: year
printed length: 4 characters
storage length: 2 bytes
field type: int2
column 2
fieldname: title
printed length: 24 characters
storage length: -1 bytes
field type: varchar
SEE ALSO pg_field_prtlen(3), pg_field_type(3).
PHP Documentation Group PG_FIELD_SIZE(3)