|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Help!! manipulating file
Post 302215547 by sirrtuan on Wednesday 16th of July 2008 04:41:59 PM
07-16-2008
Help!! manipulating file
Hi all,
I need help manipulating the file below.
Here is what I needed to do.
First, I have to replace INSUPD to DELETE.
Then I need to change the content of the file around by flipping the contents in the file from the bottom to the top (start from "CMD")
How should I attack this?
Here is the original file.
SET DECIMAL ,
SET DATAFORMAT DELIMITED
SET SEPARATOR ~
SET PREFIX DATA NONE
SET QUOTE NONE
SET DATEFORMAT DD-MM-YYYY
CMD INSUPD format
ATT code nature_e
INC /usr/tmp/FORMAT.fmt
CMD INSUPD format_element
ATT sqlname_c
INC /usr/tmp/FORMAT.elt
CMD INSUPD denomination format_element
ATT object_id
INC /usr/tmp/FORMAT.feden
CMD INSUPD script_definition
ATT attribute.sqlname_c
INC /usr/tmp/FORMAT.def
Here is what I want it to be.
SET DECIMAL ,
SET DATAFORMAT DELIMITED
SET SEPARATOR ~
SET PREFIX DATA NONE
SET QUOTE NONE
SET DATEFORMAT DD-MM-YYYY
CMD INSUPD script_definition
ATT attribute.sqlname_c
INC /usr/tmp/FORMAT.def
CMD INSUPD denomination format_element
ATT object_id
INC /usr/tmp/FORMAT.feden
CMD INSUPD format_element
ATT sqlname_c
INC /usr/tmp/FORMAT.elt
CMD INSUPD format
ATT code nature_e
INC /usr/tmp/FORMAT.fmt
Here is what I got so far.
#/bin/ksh
# Replacing INSUPD with DELETE
/bin/sed -e "s:INSUPD
ELETE:" /usr/tmp/XYZ_FILE.cmd | awk '{print};/INC .*.del/{exit}' > /usr/tmp/ XYZ_FILE.del.cmd
#end script
I need help manipulating the file below.
Here is what I needed to do.
First, I have to replace INSUPD to DELETE.
Then I need to change the content of the file around by flipping the contents in the file from the bottom to the top (start from "CMD")
How should I attack this?
Here is the original file.
SET DECIMAL ,
SET DATAFORMAT DELIMITED
SET SEPARATOR ~
SET PREFIX DATA NONE
SET QUOTE NONE
SET DATEFORMAT DD-MM-YYYY
CMD INSUPD format
ATT code nature_e
INC /usr/tmp/FORMAT.fmt
CMD INSUPD format_element
ATT sqlname_c
INC /usr/tmp/FORMAT.elt
CMD INSUPD denomination format_element
ATT object_id
INC /usr/tmp/FORMAT.feden
CMD INSUPD script_definition
ATT attribute.sqlname_c
INC /usr/tmp/FORMAT.def
Here is what I want it to be.
SET DECIMAL ,
SET DATAFORMAT DELIMITED
SET SEPARATOR ~
SET PREFIX DATA NONE
SET QUOTE NONE
SET DATEFORMAT DD-MM-YYYY
CMD INSUPD script_definition
ATT attribute.sqlname_c
INC /usr/tmp/FORMAT.def
CMD INSUPD denomination format_element
ATT object_id
INC /usr/tmp/FORMAT.feden
CMD INSUPD format_element
ATT sqlname_c
INC /usr/tmp/FORMAT.elt
CMD INSUPD format
ATT code nature_e
INC /usr/tmp/FORMAT.fmt
Here is what I got so far.
#/bin/ksh
# Replacing INSUPD with DELETE
/bin/sed -e "s:INSUPD
ELETE:" /usr/tmp/XYZ_FILE.cmd | awk '{print};/INC .*.del/{exit}' > /usr/tmp/ XYZ_FILE.del.cmd#end script
Last edited by sirrtuan; 07-16-2008 at 06:37 PM..
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have a file containing two fields, Name and Time, with about 57 lines in this file. I am struggling to create a loop that will cut out the first ten lines of this file and echo it to the screen. Can anybody help me please. (1 Reply)
Discussion started by: mariner
1 Replies
2. Shell Programming and Scripting
hey guys, need ur expert help. m a core banker got stuck in someting techie and cant find a solution
have manged to extract a file from oracle apps in a format that looks something like this...
REC- A b c d x
INV- A b... (6 Replies)
Discussion started by: komalkg
6 Replies
3. Solaris
Help...please.
I have a log that contains
Warning Authentication Failed: User GHDT88998HS doesn't exit: The User GHDT88998HS could not be found Mar 22, 2008 5:22:22AM com.hometel.ttm.auth.userlogin.
about maybe a thousand entries failed user acct message
How can I grab just the username... (2 Replies)
Discussion started by: rivendell500
2 Replies
4. Shell Programming and Scripting
Hi
I have a text file as follows
BOB
14/14
TOM
94/94
SAM
3/3
CRIS
13/13
TOM
6/6
CRIS
27/27
SAM
2/2
JACK
25/25
CRIS (6 Replies)
Discussion started by: shellignorant
6 Replies
5. Shell Programming and Scripting
How can i use sed to extract the user name and home directory from the /etc/passwd/ file on my server. (11 Replies)
Discussion started by: Pauline mugisha
11 Replies
6. Shell Programming and Scripting
Hi everybody,
I need an urgent help with a BASH script. I have file which contains (besides the other data) the lines with the following structure identified by with keyword PCList:
<PARAMETER NAME="PCList"
TYPE="LIST_STRUCTURE"
MODEL="{,}"
... (1 Reply)
Discussion started by: sameucho
1 Replies
7. Shell Programming and Scripting
Hello everyone,
I am trying to manipulate a large .csv file where I have output similar to the following -
http://imgur.com/TEXD8.png
The result that I am looking for would be to consolidate the first column, but combine the second and third column so it still relates to the first. I... (8 Replies)
Discussion started by: xxwohxx
8 Replies
8. Shell Programming and Scripting
We need to convert a field in a csv file which is in cents to dollars.(divide by 100) in our shell script.
Can some body help me? (3 Replies)
Discussion started by: Deepthz
3 Replies
9. Shell Programming and Scripting
Hi,
I need a shell/command to achieve this task.
I've a delimited unloaded file from oracle in a scrambled format as shown below with many blank lines in it, I'm just trying to tailor it in a format that would be compatible to view and load it to a IDS db.
Here is the problem
... (1 Reply)
Discussion started by: divak
1 Replies
10. Shell Programming and Scripting
Hi
I have a file content.txt where I want to replace the value of second column of the file with half of the value of that column.
I only have to replace if the second column starts with COM_, rest all values have to be same
eg,
cat content.txt
|COM_A|123|JHV|8475
|ABC|2765|BV|876... (7 Replies)
Discussion started by: infyanurag
7 Replies
LEARN ABOUT DEBIAN
hwloc_cpuset_to_glibc_sched_affinity
Helpers for manipulating glibc sched affinity(3) Hardware Locality (hwloc) Helpers for manipulating glibc sched affinity(3) NAME
Helpers for manipulating glibc sched affinity - Functions static inline int hwloc_cpuset_to_glibc_sched_affinity (hwloc_topology_t topology , hwloc_const_cpuset_t hwlocset, cpu_set_t *schedset, size_t schedsetsize) static inline int hwloc_cpuset_from_glibc_sched_affinity (hwloc_topology_t topology , hwloc_cpuset_t hwlocset, const cpu_set_t *schedset, size_t schedsetsize) Function Documentation static inline int hwloc_cpuset_from_glibc_sched_affinity (hwloc_topology_t topology, hwloc_cpuset_thwlocset, const cpu_set_t *schedset, size_tschedsetsize) [static] Convert glibc sched affinity CPU set schedset into hwloc CPU set. This function may be used before calling sched_setaffinity or any other function that takes a cpu_set_t as input parameter. schedsetsize should be sizeof(cpu_set_t) unless schedset was dynamically allocated with CPU_ALLOC static inline int hwloc_cpuset_to_glibc_sched_affinity (hwloc_topology_t topology, hwloc_const_cpuset_thwlocset, cpu_set_t *schedset, size_tschedsetsize) [static] Convert hwloc CPU set toposet into glibc sched affinity CPU set schedset. This function may be used before calling sched_setaffinity or any other function that takes a cpu_set_t as input parameter. schedsetsize should be sizeof(cpu_set_t) unless schedset was dynamically allocated with CPU_ALLOC Author Generated automatically by Doxygen for Hardware Locality (hwloc) from the source code. Version 1.4.1 Mon Feb 27 2012 Helpers for manipulating glibc sched affinity(3)