|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
cleansing file in unix
Post 302313525 by Amey Joshi on Wednesday 6th of May 2009 01:56:37 AM
05-06-2009
cleansing file in unix
Hi Experts,
Our requirement is to cleanse a specific formatted file in unix.
For example :
File pattern is :
Desired Result:
I have tried follwoing command, but it is not working 
cat sourcefile.txt| grep -v ^\| while read line
do
echo $line >> targetfile.txt
done
Any help on this??
Thanks in Advance!!
Our requirement is to cleanse a specific formatted file in unix.
For example :
File pattern is :
HTML Code:
Job name.......................................... \\\\Jobs\Amey ABC PQRS ABCD XYZ Job name.......................................... WEQ RED AAA
HTML Code:
ABC PQRS ABCD XYZ WEQ RED AAA
cat sourcefile.txt| grep -v ^\| while read line
do
echo $line >> targetfile.txt
done
Any help on this??
Thanks in Advance!!
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
My local server is :/usr/abcd/
Remote server is :/Usr/host/test/
I want to send files from local unix directory(All files starting with O_999) to
remote host unix directory.
Can any body give me the Unix Shell script to do this.
One more doubt: Shall we need to change the file... (1 Reply)
Discussion started by: raja_1234
1 Replies
2. Shell Programming and Scripting
Hi
Can we call a jsp page from Unix.if so please let me know how we can..
thanks for the help in advance...
thanks
kumar (0 Replies)
Discussion started by: mailsukumar
0 Replies
3. Shell Programming and Scripting
unix script must do the fiollowing
open a file containing comma delimited records
> each record contains 10 fields
> removes the 2nd field and use that same field containing fields 2 to 10
the original record after fprocessing should containing fields 1 and 3
a new erecord must be... (10 Replies)
Discussion started by: dwightja
10 Replies
4. Shell Programming and Scripting
I have a file with 27 fields seperated by pipe. I have a field 17 that is defined as numeric and the data coming in might contain character and
other miscellaneous data like (@,!,~,#,%,^,&,*,(,)).
I have to make sure that the column strictly contains numeric data and if it contains any of the... (2 Replies)
Discussion started by: dsravan
2 Replies
5. Shell Programming and Scripting
Hi Experts,
I have a requirement where i need to setup a batch job which runs everymonth and move the pdf files from unix server to windows servers.
Could some body provide the inputs for this.
and also please provide the inputs on how to map the network dirve in the unix like that... (1 Reply)
Discussion started by: ger199901
1 Replies
6. Shell Programming and Scripting
Hi, I am new to this subject.....Can someone please help me out with the script...
unix usernm "sdhftst"
unix pwd "chsd13"
windows usernm "dfghtst"
windows pwd "chsd13"
path..../xxx/xxxxx/xxxxxx/xxxxxxx
please can u get me a script...its only one file to get ftp.
Thanks... (2 Replies)
Discussion started by: himakiran9
2 Replies
7. UNIX Desktop Questions & Answers
Hi all,
I wish to know whether Unix can access window's file in Unix's terminal?
Apart from that, how to copy files or share files between Window and Unix? I get to know of secure copy, however, my company's Unix does not support the feature of secure copy? Any other method for me to share/... (5 Replies)
Discussion started by: jessy83
5 Replies
8. Shell Programming and Scripting
Dear All,
Can someone help to command or program to transfer the file from windows to Unix server and from one unix server to another Unix server in secure way.
I would request no samba client. (4 Replies)
Discussion started by: yadavricky
4 Replies
9. Shell Programming and Scripting
Hi All ,
I am very new to unix script.I am aware of unix commands but never put together in unix script level.If any one can suggest me technical guidance in the below scenario that will highly beneficial.
Data have been already migrated from mainframe to Hadoop file system(HDFS).HDFS server... (15 Replies)
Discussion started by: STCET22
15 Replies
10. Shell Programming and Scripting
Hello community, I am getting a log files from system and I need to clean the data and store as txt files for reporting purposes. Since these files are generated in Unix box, so we have to write shell script to handle the data cleansing.
Please find the sample file data looks like:
... (7 Replies)
Discussion started by: pdathu
7 Replies
LEARN ABOUT DEBIAN
ecaccess-job-get
ECACCESS-JOB-GET(1p) User Contributed Perl Documentation ECACCESS-JOB-GET(1p) NAME
ecaccess-job-get - Download a Job Output/Input/Error File SYNOPSIS
ecaccess-job-get -version|-help|-manual ecaccess-job-get [-debug] [-input|-error] [-encrypt] [-binary] [-bufsize length] job-id local-target-file DESCRIPTION
Allow downloading the Job Output/Input/Error Files with identifier job-id. The file is downloaded localy in the local-target-file. ARGUMENTS
job-id The identifier of the ECaccess Job to retrieve. local-target-file The name of the Local Target File. OPTIONS
-input By default the Job Output File is downloaded. Using this option allow downloading the Job Input File instead. -error By default the Job Output File is downloaded. Using this option allow downloading the Job Error File instead. -encrypt By default files are downloaded through the plain text channel (http). Using this option will force the download to occurs through the SSL secure channel (https). -binary By default files are downloaded as text files. This option will download files as binary files (decode_base64 required). Please note that text files can also be downloaded in binary mode but text mode is faster. You should use this option if your job output is containing non-text characters. -bufsize length Specify the length of the buffer (in bytes) which is used to download the file. The larger the buffer the smaller the number of http/s requests. By default a buffer of 524288 bytes(512KB) is used. -version Display version number and exits. -help Print a brief help message and exits. -manual Prints the manual page and exits. -debug Display the SOAP messages exchanged. EXAMPLES
ecaccess-job-get 124356 ./ecaccess-job-124356.output Download the output of the ECaccess Job 124356 in the local ecaccess-job-124356.output file. SEE ALSO
ecaccess-job-delete, ecaccess-job-list, ecaccess-job-restart, ecaccess-job-submit and ecaccess. perl v5.14.2 2012-04-16 ECACCESS-JOB-GET(1p)