12-21-2011
Maybe you should contact your vendor : adding a space will not tell you wether the field has been truncated or not.
I think this is up to your vendor to ensure that the generated report that is sent to you does not contain truncated values.
Of course, if you are sure that those fields never contain truncated values, then, indeed, you can separate them as per Bartus suggestion.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Let's say I write a simple script that contains the following:
date | awk '{print $1}'
date | awk '{print $2}'
Of course, when I run the script the output will look similar to:
Tue
Mar
What if I want my ouput to be on one line as follows:
Tue Mar
What changes would I need to... (2 Replies)
Discussion started by: cdunavent
2 Replies
2. Shell Programming and Scripting
I have 2 files with sample data enclosed.
1. GL (already sorted in ascending order by Gl number)
Gl number*glname*Year*opening balance
1000*Interest Income*2006*100.00
1005*Rental Income*2006*0.00
...
2. Transactions (file is not sorted on GL number or any other field)
Branch*Year*Gl... (12 Replies)
Discussion started by: augustinep
12 Replies
3. UNIX for Dummies Questions & Answers
Hi
I am fetcthing the data from the oracle database using SQLPLUS. Here is my script
#!/bin/ksh
echo `sqlplus -s <<EOF
set feedback off
set linesize 5000
set pages 0
set space 0
set echo off
set trimspool on
set colsep '|'
SELECT col1 , col2... (4 Replies)
Discussion started by: max_hammer
4 Replies
4. Shell Programming and Scripting
Dear all
I require help with AWK regarding this situation
Input is :
fn1 12345
fn1 23456
fn3 231513
fn1 22325
fn3 123125
Desired output is
fn1 12345 23456 22325
fn3 231513 123125 (5 Replies)
Discussion started by: Peasant
5 Replies
5. Shell Programming and Scripting
when i try this awk its giving out put as below.
awk '!(/^$/||/--/||/selected/||/^ *$/){print $1}' tmp.txt
output
=====
1
2010-08-03-12.31.26.126000
how excluede the 1st line ? i mean i want output only 2nd line i.e 2010-08-03-12.31.26.126000; (5 Replies)
Discussion started by: rocking77
5 Replies
6. Shell Programming and Scripting
Hi;
i m running an command like;
getfacl $(find /home/fstl/testShell/ -type f -ls | awk '{print $11}')
and i m getting outpiut for all files in "testShell" folder as;
# file: home/fstl/testShell/.script1.sh.swp
# owner: root
# group: root
user:fstl:rw-
user:ajay:rw-
group:root:r--... (1 Reply)
Discussion started by: ajaypadvi
1 Replies
7. UNIX for Dummies Questions & Answers
Hi all,
I'm writing a simple awk code:
awk 'BEGIN {FS="|"};{print "Type\tNumber\ttypes\tTotal";};{print $1, "\t", $2, "\t", $3, "\t", $4, "\t";}' db_query.txt
it gives me the result:
Type Number types Total
XXX 498.0 5100.0 5274.661
Type Number types Total... (7 Replies)
Discussion started by: messi777
7 Replies
8. Shell Programming and Scripting
Data
I was trying to write shell script which will be return the output in the below format
First i was trying to do these using sed.
sed -n '/.ksh/p' mainksh.ksh
sed -e 's/*\(.*\)/\1/g' mainksh.ksh
$RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file.
when i am... (0 Replies)
Discussion started by: rameshds
0 Replies
9. Shell Programming and Scripting
Hi ,
I was trying to find files of a particular date and did that but then I also wanted to format a field based on some condition so had put another if else in awk.
Now it is getting the files of particular date or also the files which are matching that if else condition.
find . -name "*"... (1 Reply)
Discussion started by: abhi1988sri
1 Replies
10. Shell Programming and Scripting
i would like to format the 9 character with suffix as "0".
i tried below it doesn't work.
>a=12345
> echo $a | awk '{printf "%-09s\n",$1}'
>12345
required output is 123450000
can you guys help me out ? (7 Replies)
Discussion started by: expert
7 Replies
LEARN ABOUT LINUX
dpkg::vendor
Dpkg::Vendor(3) libdpkg-perl Dpkg::Vendor(3)
NAME
Dpkg::Vendor - get access to some vendor specific information
DESCRIPTION
The files in /etc/dpkg/origins/ can provide information about various vendors who are providing Debian packages. Currently those files look
like this:
Vendor: Debian
Vendor-URL: http://www.debian.org/
Bugs: debbugs://bugs.debian.org
The file should be named according to the vendor name.
FUNCTIONS
$fields = Dpkg::Vendor::get_vendor_info($name)
Returns a Dpkg::Control object with the information parsed from the corresponding vendor file in /etc/dpkg/origins/. If $name is
omitted, it will use /etc/dpkg/origins/default which is supposed to be a symlink to the vendor of the currently installed operating
system. Returns undef if there's no file for the given vendor.
$name = Dpkg::Vendor::get_vendor_file($name)
Check if there's a file for the given vendor and returns its name.
$name = Dpkg::Vendor::get_current_vendor()
Returns the name of the current vendor. If DEB_VENDOR is set, it uses that first, otherwise it falls back to parsing
/etc/dpkg/origins/default. If that file doesn't exist, it returns undef.
$object = Dpkg::Vendor::get_vendor_object($name)
Return the Dpkg::Vendor::* object of the corresponding vendor. If $name is omitted, return the object of the current vendor. If no
vendor can be identified, then return the Dpkg::Vendor::Default object.
Dpkg::Vendor::run_vendor_hook($hookid, @params)
Run a hook implemented by the current vendor object.
1.16.0.3 2012-04-17 Dpkg::Vendor(3)