Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to separate file content
Top Forums UNIX for Dummies Questions & Answers How to separate file content Post 302226120 by vinsara on Monday 18th of August 2008 09:53:05 AM
Old 08-18-2008
Hi drl,

I have tried both your perl and ksh script but it was not giving me the expected output. When I am running your both perl and ksh script the content of the file is splited as fields but it is not going for next line. For example:

The output what i am getting is when running the script is:

Yuk Ming Court [Blks A-C & CP] Tseung Kwan O Asia Insurance Co Ltd

Yuk Po Court [Blks A-H & CP] Sheung Shui "China BOCOM Insurance Co., Ltd."

Yukon Court [Blks & CP] 2-4 Conduit Road Concord Insurance Co Ltd

Yung Shing Court [Blks A-C & CP] Fanling ING General Insurance International


but i want output like:

Yuk Ming Court [Blks A-C & CP]
Tseung Kwan O
Asia Insurance Co Ltd

Yuk Po Court [Blks A-H & CP]
Sheung Shui
"China BOCOM Insurance Co., Ltd."

Yukon Court [Blks & CP]
2-4 Conduit Road
Concord Insurance Co Ltd

Yung Shing Court [Blks A-C & CP]
Fanling
ING General Insurance International


Please help me on this.

Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To read and separate number and words in file and store to two new file using shell

hi, I am a begginer in unix and i want to know how to open a file and read it and separate the numbers & words and storing it in separate files, Using shell scripting. Please help me out for this. Regards S.Kamakshi (2 Replies)
Discussion started by: kamakshi s
2 Replies

2. UNIX for Dummies Questions & Answers

creating separate directories according to file extension and keeping file in different directory as

unix program to which a directory name will be passed as parameter. This directory will contain files with various extensions. This script will create directories with the names of the extention of the files and then put the files in the corresponding folder. All files which do not have any... (2 Replies)
Discussion started by: Deekay.p
2 Replies

3. Shell Programming and Scripting

How to split a data file into separate files with the file names depending upon a column's value?

Hi, I have a data file xyz.dat similar to the one given below, 2345|98|809||x|969|0 2345|98|809||y|0|537 2345|97|809||x|544|0 2345|97|809||y|0|651 9685|98|809||x|321|0 9685|98|809||y|0|357 9685|98|709||x|687|0 9685|98|709||y|0|234 2315|98|809||x|564|0 2315|98|809||y|0|537... (2 Replies)
Discussion started by: nithins007
2 Replies

4. Shell Programming and Scripting

Separate lines in csv by column content (newbie)

Hello everyone I have a csv file organized just like in the following example: col1,col2,col3,CODE_0, ... , colN col1,col2,col3,CODE_0, ... , colN col1,col2,col3,CODE_1, ... , colN col1,col2,col3,CODE_1, ... , colN col1,col2,col3,CODE_1, ... , colN col1,col2,col3,CODE_2, ... , colN... (7 Replies)
Discussion started by: yomaya
7 Replies

5. Shell Programming and Scripting

Compare large file and identify difference in separate file

I have a very large system generated file containing around 500K rows size 100MB like following HOME|ALICE STREET|3||NEW LISTING HOME|NEWPORT STREET|1||NEW LISTING HOME|KING STREET|5||NEW LISTING HOME|WINSOME AVENUE|4||MODIFICATION CAR|TOYOTA|4||NEW LISTING CAR|FORD|4||NEW... (9 Replies)
Discussion started by: jubaier
9 Replies

6. Shell Programming and Scripting

Compare two string in two separate file and delete some line of file

Hi all i want to write program with shell script that able compare two file content and if one of lines of file have # at the first of string or nothing find same string in one of two file . remove the line in second file that have not the string in first file. for example: file... (2 Replies)
Discussion started by: saleh67
2 Replies

7. Shell Programming and Scripting

Sed: replace content from file with the content from file

Hi, I am having trouble while using 'sed' with reading files. Please help. I have 3 files. File A, file B and file C. I want to find content of file B in file A and replace it by content in file C. Thanks a lot!! Here is a sample of my question. e.g. (file A: a.txt; file B: b.txt; file... (3 Replies)
Discussion started by: dirkaulo
3 Replies

8. Shell Programming and Scripting

How to grep a log file for words listed in separate text file?

Hello, I want to grep a log ("server.log") for words in a separate file ("white-list.txt") and generate a separate log file containing each line that uses a word from the "white-list.txt" file. Putting that in bullet points: Search through "server.log" for lines that contain any word... (15 Replies)
Discussion started by: nbsparks
15 Replies

9. Shell Programming and Scripting

How to remove exisiting file content from a file and have to append new file content?

hi all, i had the below script x=`cat input.txt |wc -1` awk 'NR>1 && NR<'$x' ' input.txt > output.txt by using above script i am able to remove the head and tail part from the input file and able to append the output to the output.txt but if i run it for second time the output is... (2 Replies)
Discussion started by: hemanthsaikumar
2 Replies

10. Programming

creating separate output file for each input file in python

Experts, Need your help for this. Please support My motive is to create seperate output file for each Input Files(File 1 and File2) in another folder say(/tmp/finaloutput) Input files File 1(1.1.1.1.csv) a,b,c 43,17104773,3 45,17104234,4 File 2(2.2.2.2.csv) a,b,c 43,17104773,1... (2 Replies)
Discussion started by: as7951
2 Replies

LEARN ABOUT DEBIAN

finance::quote::yahoo::asia

Finance::Quote::Yahoo::Asia(3pm)			User Contributed Perl Documentation			  Finance::Quote::Yahoo::Asia(3pm)

NAME

       Finance::Quote::Yahoo::Asia - Fetch quotes from Yahoo Asia

SYNOPSIS

	   use Finance::Quote;
	   $q = Finance::Quote->new;

	   %info = $q->fetch("asia","CREA.SI"); # Failover to other methods ok.
	   %info = $q->fetch("yahoo_asia","CREA.SI"); # Use this module only.

DESCRIPTION

       This module fetches information from Yahoo Asia.  Symbols should be provided in the format "SYMBOL.EXCHANGE", where the exchange code is
       one of the following:

	       SI - Singapore
	       BO - Bombay
	       JK - Jakarta
	       HK - Hong Kong
	       NS - India
	       KS - Korea
	       KL - Kuala Lumpur
	       NZ - New Zealand
	       SS - Shanghai
	       SZ - Shenzhen
	       TW - Taiwan
	       TH - Thailand

       This module provides both the "asia" and "yahoo_asia" methods.  The "asia" method should be used if failover methods are desirable.  The
       "yahoo_asia" method should be used you desire to only fetch information from Yahoo Europe.

       Stocks are returned in the currency of the local exchange.  You can use Finance::Quote's set_currency() feature to change the currency in
       which information is returned.

       This module is loaded by default by Finance::Quote, but can be loaded explicitly by specifying the parameter "Yahoo::Asia" to
       Finance::Quote->new().

       Information obtained by this module may be covered by Yahoo's terms and conditions.  See http://sg.finance.yahoo.com/ for more details.

LABELS RETURNED

       This module returns all the standard labels (where available) provided by Yahoo.  See Finance::Quote::Yahoo::Base for a list of these.  The
       currency label is also returned.

BUGS

       The currency of each exchange has not been thoroughly confirmed.  If you find an exchange is returning in an incorrect exchange, please use
       the bug tool at http://sourceforge.net/projects/finance-quote to report it.

SEE ALSO

       Yahoo Asia, http://sg.finance.yahoo.com/

       Finance::Quote::Yahoo::Base

perl v5.14.2							    2014-03-03					  Finance::Quote::Yahoo::Asia(3pm)
All times are GMT -4. The time now is 01:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy