Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Add new column in Text File
Top Forums Shell Programming and Scripting Add new column in Text File Post 302288690 by pareshan on Tuesday 17th of February 2009 05:29:29 PM
Old 02-17-2009
I dint say anything like last part..If I did then I mean that database part only I guess. Actually I know I can load data into database using sqlloader but I want to do using the script I have but I am not able to figure it out how. my script which will generate the formatted_bdf output is

Code:
#!//opt/perl/bin/perl
use strict;
use warnings;
my ($filesystem);
foreach (qx(bdf)) { ##executing bdf command here
 next if/^Filesystem/; ##Skip the header line
 if(!/%/) { ##remember on next line if no percentage on this line
  chomp; ##clean up the new line
  $filesystem = $_; ## remember
  next;
 }
 $_ = $filesystem . $_ if /^\s/; ## add filesystem for wrapped lines  
 #next if /^\w+:/; #skip NFS mount with ":" in first word ##To skip the NFS mount 
 #chomp;
 s/% / /; ## strip percentage sign
 s/\s+/ /g; ## replace all tabs and spaces with just 1 space
 my ($fs, $kbytes, $used, $avail, $pct_used, $mount) = split; ## now have each column in a variable
 ## do anything you like with the columns (like preparing an oracle insert)
 ##print $_, "\n" ; # just to prove new glued line
 ##print qq(fs=$fs used=$pct_used \n);
 print qq($fs $kbytes $used $avail $pct_used $mount\n);
}

But the problem is my oracle table have some extra columns other than the value I will get from that bdf_output so I am thinking how can I do that...

Thats where I need help on ...

lets say my table have 8 fields and I get 6 output from the bdf and which are stored on the respective variables which you can see on the script above. so how can i directly insert that value in the table including 2 more columns with different values

help help
Last edited by otheus; 02-18-2009 at 05:39 AM.. Reason: code tags, formatting
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to get First column from the text file

Hey Guys, I have a very urgent requirement regaridng the searching for value on the text file. The text file is in the below format Number Description "112323", mysampletest1 "12122412", mysampletest2 "11232143", mysampletest3 I need to get the first column like 112323... (2 Replies)
Discussion started by: rahman_riyaz
2 Replies

2. UNIX for Dummies Questions & Answers

Replacing a column in a text file

Say I had a text file that contained four columns, like the following: Mack Christopher:237 Avondale Blvd:970-791-6419:S Ben Macdonor:30 Dragon Rd:647-288-6395:B I'm making a loop that will replace the fourth column a line in the file with the contents of a variable 'access', but I have no... (6 Replies)
Discussion started by: Sotau
6 Replies

3. Shell Programming and Scripting

Finding the last column value from a text file

Hi, I need to find out the last column value from a text file which is delimited by a tab. The issue here is the last column# for each record can be different i.,e, 1st record can have the last column as 15 and the second record can have the last column as "17". I have to search a string... (3 Replies)
Discussion started by: naveen_sangam
3 Replies

4. UNIX for Dummies Questions & Answers

Add a new column to a tab delimited text file

I want to add a new column to a tab delimited text file. It will be the first column and it will just be 1's. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

5. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

6. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

7. UNIX for Dummies Questions & Answers

Extracting the last column of a text file

I would like to extract the last column of a text file but different rows of the text file have different numbers of columns. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

8. Shell Programming and Scripting

Howto add a constant column to the text file

Hi, I am converting a .DBF file to pipe delimited file my requirement is like lets say my .DBF is residing in path /a/b/c/d/f/abc.DBF I need my .txt file as having a column with source _cd =f sample data in .DBF in folder "f" c1 c2 c3 1 2 3 in txt file it should be... (4 Replies)
Discussion started by: angel12345
4 Replies

9. UNIX for Dummies Questions & Answers

Add a column of 0's to a text file

Hi, I have a text file with many column (1,000,000+). I want to add a column of 0's as the third column. I tried: awk '{$3=0}1' input file > output file But it simply replaces the third column with 0's instead of adding a new column. How do I go about doing this? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies

10. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies

LEARN ABOUT XFREE86

lsns

LSNS(8) 						       System Administration							   LSNS(8)

NAME

       lsns - list namespaces

SYNOPSIS

       lsns [options] [namespace]

DESCRIPTION

       lsns  lists  information  about all the currently accessible namespaces or about the given namespace.  The namespace identifier is an inode
       number.

       The default output is subject to change.  So whenever possible, you should avoid using default outputs in your scripts.	Always	explicitly
       define expected columns by using the --output option together with a columns list in environments where a stable output is required.

       Note  that lsns reads information directly from the /proc filesystem and for non-root users it may return incomplete information.  The cur-
       rent /proc filesystem may be unshared and affected by a PID namespace (see unshare --mount-proc for more details).  lsns is not able to see
       persistent namespaces without processes where the namespace instance is held by a bind mount to /proc/pid/ns/type.

OPTIONS

       -J, --json
	      Use JSON output format.

       -l, --list
	      Use list output format.

       -n, --noheadings
	      Do not print a header line.

       -o, --output list
	      Specify which output columns to print.  Use --help to get a list of all supported columns.

	      The default list of columns may be extended if list is specified in the format +list (e.g. lsns -o +PATH).

       -p, --task pid
	      Display only the namespaces held by the process with this pid.

       -r, --raw
	      Use the raw output format.

       -t, --type type
	      Display  the  specified type of namespaces only.	The supported types are mnt, net, ipc, user, pid, uts and cgroup.  This option may
	      be given more than once.

       -u, --notruncate
	      Do not truncate text in columns.

       -V, --version
	      Display version information and exit.

       -h, --help
	      Display help text and exit.

AUTHORS

       Karel Zak <kzak@redhat.com>

SEE ALSO

       nsenter(1), unshare(1), clone(2), namespaces(7)

AVAILABILITY

       The lsns command is part of the util-linux package and is available from https://www.kernel.org/pub/linux/utils/util-linux/.

util-linux							   December 2015							   LSNS(8)
All times are GMT -4. The time now is 05:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy