Need a shell script to clean data Post: 302663239

Sponsored Content

Top Forums Shell Programming and Scripting Need a shell script to clean data Post 302663239 by netbanker on Wednesday 27th of June 2012 06:55:19 PM

06-27-2012

Registered User

thank you Sir,

my file has some other data I donot want to delete

Code:

source database: WEBSUN1.WORLD                                                  
owner: WS_APP_OWNER                                                             
object: DZPRCP                                                                  
is tag null: Y                                                                  
command_type: UPDATE      
old(1): PRCNCP 
1 
old(2): PRSKU 
6480966 
old(2): PRSKU2 
old(3): PRPRCE 
89.99 
new(1): PRCNCP 
8 
new(2): PRSKU 
6480966 
new(3): PRPRCE 
89.99

can I have:

Code:

source database: WEBSUN1.WORLD                                                  
owner: WS_APP_OWNER                                                             
object: DZPRCP                                                                  
is tag null: Y                                                                  
command_type: UPDATE  
new(1): PRCNCP 8 
new(2): PRSKU 6480966 
new(3): PRPRCE 89.99

Last edited by Franklin52; 06-28-2012 at 04:55 AM.. Reason: Please use code tags for data and code samples

netbanker

View Public Profile for netbanker

Find all posts by netbanker

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

clean up script

I have a script which would monitor a given directory and delete any files which are older than 10 days. I was going to set the 10 crob jobs to perform this operation for 10 different directories (some are actually sub-directories), but my boss doesn't like that idea, so I need to do that in one...

2. OS X (Apple)

Startup script to clean out trash can

I need to know how I would be able to clean out the trash can of a single "dumb" user every time the MAC is turned on. Back ground. OS 10.3x G3 Mac Two users configured... 1) Root or Admin (superuser) 2) student (Simple no access to anything but shared folder for files etc.) The problem...

3. BSD

clean data from partition

Anyone know of an automated utility that will fill a designated partition with random data then delete the data? We have several harddrives that need certain partitions cleaned of sensitive data before they are placed back in service. Thanks Thumper

4. Shell Programming and Scripting

Bourne Shell: Clean Display of stored procedure's output

Environment: Sun UNIX Language: Bourne Shell I have the following script and it works fine. Unfortunately, from user's perspective, it looks very messy because the user is able to see the output of the process caused by the print command. Is there a better way to overcome it? Here's the...

5. Shell Programming and Scripting

How to clean this script?

Hello guys, this script partially works but it's still pretty ugly and, moreover, if the month is jan/feb/mar... it doesn't work at all. Could anyone say me how to correct, cut and clean a little bit? #!/usr/bin/ksh egrep -v -e "^\s*#" /file/permission | awk '{ print $1 }' | sort | uniq...

6. UNIX for Advanced & Expert Users

Convert column data to row data using shell script

Hi, I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated. Thanks.

7. Shell Programming and Scripting

Script to FTP,clean up and email

Hi i need a unix script to do the following tasks. My folder structure is /home/MSTR/test and will have the following folder within it Cache Lookup Source Target 1. On the Source & Target folder i have to take a copy of files older than 5 days and move(FTP) it into local machines C:\Backup...

8. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas

9. UNIX for Dummies Questions & Answers

'awk' help for script to clean out wireless.

I've been working on a script to clean out the wireless connections on my MAC. I know the terminal command to do this (that part is not rocket science ;) ) So I thought I would have a go at automating this but I'm having trouble with the 'awk' command & the correct context. My code is := ...

10. UNIX for Beginners Questions & Answers

UNIX Script to clean files

Hello All, I need a script that would delete files which are more than "X" number of days old, also if there can be a log file of the deleted files for reference. I am from windows background hence finding it difficult. Any help is much appreciated Regards Wert

LEARN ABOUT DEBIAN

fiaif-update

FIAIF-UPDATE(8) 				      Administration and Privileged Commands					   FIAIF-UPDATE(8)

NAME

       fiaif-update - tests for new version and updated reserved_networks file.

SYNOPSIS

       fiaif-update [--silent] [--help] <update|check>

DESCRIPTION

       Tests for new version and updated reserved_networks file.

       --silent
	      If this flag is present, then no textual output will be given.

       check  Test if a new version of FIAIF is available.

       update Retrieves  the  files  reserved_networks	from  the FIAIF website, and compared the version with the currently installed version, as
	      pointed to by fiaif.conf.  If the retrieved version is newer, the old version is silently replaced.

       help   Prints the synopsis.

EXIT CODE

       If updating the exit code will be non-zero if no update was performed, else the exit code will be zero.

FILES

       /etc/fiaif/fiaif.conf
	      The configuration file for FIAIF
       /etc/fiaif/private_networks
	      A list of private networks as specified by RFC1918
       /etc/fiaif/reserved_networks
	      A list of reserved networks as specified by IANA.

REPORTING BUGS

       Report bugs to <fiaif@fiaif.net>.

AUTHOR

       Anders Fugmann <anders(at)fugmann.net>

SEE ALSO

       fiaif(8), fiaif.conf(5)

Linux								     Feb 2003							   FIAIF-UPDATE(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

clean up script

Discussion started by: mpang_

2. OS X (Apple)

Startup script to clean out trash can

Discussion started by: Andrek

3. BSD

clean data from partition

Discussion started by: thumper

4. Shell Programming and Scripting

Bourne Shell: Clean Display of stored procedure's output

Discussion started by: totziens