03-11-2011
need help on manipulating a file
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
Infile-
asd,sdfgsdf,,
<blank line 1>
fgsdfg, , , ,asfa,
<blank line 2>
<blank line 3>
sdfd,sdfd, ,
asd,asdd,
asdf, , , ,dsfd,
afdd,dsd
blank line 1 - potential data
blank line 2 - potential data
blank line 3 - record seperator
In the above ex, blank line1,2 is not a record seperator but it has a NULL data which is identified in the ASCII format. I'm trying to make the file into each data record in a single row as below, replacing the non-viewable data fields into some string (*$& here)
Output-
asd,sdfgsdf,, *$&,*$& ,fgsdfg, , , ,asfa, *$&
sdfd,sdfd, ,asd,asdd,asdf, , , ,dsfd,afdd,dsd
Please note that each blank line can have one or more fields in it
Thanks
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. UNIX for Dummies Questions & Answers
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... (2 Replies)
Discussion started by: sirrtuan
2 Replies
5. 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
6. 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
7. 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
8. 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
9. 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
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
anacrontab
ANACRONTAB(5) Anacron Users' Manual ANACRONTAB(5)
NAME
/etc/anacrontab - configuration file for anacron
DESCRIPTION
The file /etc/anacrontab describes the jobs controlled by anacron(8). Its lines can be of three kinds: job-description lines, environment
assignments, or empty lines.
Job-description lines are of one of these two forms:
period delay job-identifier command
@period_name delay job-identify command
The period is specified in days, the delay in minutes. The job-identifier can contain any non-blank character, except slashes. It is used
to identify the job in Anacron messages, and as the name for the job's timestamp file. The command can be any shell command. The fields
can be separated by blank spaces or tabs. The period_name can only be set to monthly at the present time. This will ensure jobs are only
run once a month, no matter the number of days in this month, or the previous month.
Environment assignment lines are of the form:
VAR = VALUE
Spaces around VAR are removed. No spaces around VALUE are allowed (unless you want them to be part of the value). The assignment takes
effect from the next line to the end of the file, or to the next assignment of the same variable.
Empty lines are either blank lines, line containing white-space only, or lines with white-space followed by a '#' followed by an arbitrary
comment.
You can continue a line onto the next line by ending it with a ''.
SEE ALSO
anacron(8)
The Anacron README file.
AUTHOR
Itai Tzur <itzur@actcom.co.il>
Currently maintained by Pascal Hakim <pasc@(debian.org|redellipse.net)>.
Pascal Hakim 2004-07-11 ANACRONTAB(5)