Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

How to separate file content

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to separate file content
# 1  
Old 08-13-2008
How to separate file content
Hi All,

I have a file like below which is having 3 fields namely companycode, companylocation & companyaddress and i want to separate all the fields individually.

How can i do?

File Structure:
----------------
Code:
Aberdeen Centre [Blks A-U  & CP]    Aberdeen        The Ming An Ins Co (HK) Ltd 
Academic Terrace [Towers 1-3]    "101 Pokfulam Road, HK"        Zurich Insurance Co Ltd 
Academic Terrace [Car Park Portion]    "102 Pokfulam Road, HK"        Concord Insurance Co Ltd 
Admiralty Centre [Towers I & II]    MTRC Property        Zurich Insurance Co Ltd 
"Aegean Coast [Blks 1-3, 5-8 & CP]"    So Kwun Wat        Sun Hung Kai Properites Ins Ltd 
Affluence Garden [Blks 1-5 & CP & Nursery]    Tuen Mun        China Pacific Insurance Co (HK) Ltd 
Aldrich Garden [Blks 1-10 & CP]    "2 Oi Lai Street, Shau Kei Wan"        Concord Insurance Co Ltd 
All Fit Garden [Blk A - D & CP]    20-22 Bonham Road        Asia Insurance Co Ltd 
"Allway Gardens [A-H,J-N,P-R & CP]"    "No.191 Tsuen King Circuit, Tsuen Wan, NT"        Asia Insurance Co Ltd 
Amoy Gardens [Blks A-S]    "77 Ngau Tau Kau Road, Kowloon Bay"        The Ming An Ins Co (HK) Ltd 
Anglers' Bay [Towers I & II & CP]    "No.18A Castle Peak Road, Sham Tseng, Tsuen Wan, NT"        Bank of China Group Ins Co Ltd 
"Aqua Marine [Blk 1-3, 5-6 & CP]"    "8 Sham Shing Road, Cheung Sha Wan"        The Ming An Ins Co (HK) Ltd 
Avalon [Blk A - B]    Tai Hang        Wing Hang Zurich Insurance Co Ltd 
Baguio Villa [Blk 41-44]    550 - 555 Victoria Road        Asia Insurance Co Ltd 
Balwin Court [Blk 1-5 & CP]    Mongkok        Asia Insurance Co Ltd 
Banyan Garden Phase I [Blks 1-3  & CP]    "863 Lai Chi Kok Road, Cheung Sha Wan"        The Ming An Ins Co (HK) Ltd 
Banyan Garden Phase II [Blks 7-8 & CP]    "863 Lai Chi Kok Road, Cheung Sha Wan"        The Ming An Ins Co (HK) Ltd 
Banyan Garden Phase III [Blks 5-6 & CP]    "863 Lai Chi Kok Road, Cheung Sha Wan"        The Ming An Ins Co (HK) Ltd 
Bauhinia Garden [Blks & CP]    Hung Shui Kiu        The Ming An Ins Co (HK) Ltd 
"Bauhinia Garden - TKO [Blks 1-8 ,CP & Commercial blk]"    "11 Tong Chun Street, Tseung Kwan O"        HSBC Insurance Limited 
Bay View Garden [Blks 1-3 & CP]    "Wing Ting Road, Ngau Chi Wan"        Zurich Insurance Co Ltd 
Bay View Mansion [Blks A-B & CP]    Moreton Terrace        HSBC Insurance Limited 
Baycrest [Blks 1-6 & CP]    "8 Hang Ming Street, Ma On Shan"        Sun Hung Kai Properites Ins Ltd 
Bayshore Apartments [Blk A - D]    Aberdeen        Royal & Sun Alliance Ins Co Ltd 
Bayshore Towers [Blks 1-6 & CP]    "608 Sai Sha Road, Ma On Shan"        The Ming An Insurance Co (HK) Ltd 
Bayview Garden [Blks 1-5 & CP]    Tsuen Wan        Asia Insurance Co Ltd 
Bayview Mansion [Blk A - B & CP]    "No.21 Moreton Terrace, Causeway Bay"        HSBC Insurance (Asia) Ltd. 
Bayview Terrace [Blk 1 - 26 & CP]    "107 Castle Peak Road, Tuen Mun"        "China BOCOM Insurance Co., Ltd." 
Beacon Heights [Blks 1-19 & CP]    Kowloon Tong        AXA General Insurance Hong Kong Ltd 
Beauty Court [Blks & CP]    Mid-Level        The Ming An Ins Co (HK) Ltd 
Bel Air Heights [Blks 1-4]    "Lung Poon Street / Fung Tak Road, Diamond Hill"        Asia Insurance Co Ltd 
Belair Monte [Blks 1-7 & CP]    "3 Ma Sik Road, Fanling"        Concord Insurance Co Ltd 
Belvedere Garden (Phase 1) [PH01 Blks 1-3 & CP]    Tsuen Wan        The Ming An Ins Co (HK) Ltd 
Belvedere Garden (Phase 2) [PH02 Blks 1-9 & CP]    Tsuen Wan        The People's Insurance Co of China  
Belvedere Garden (Phase 3) [PH03 Blks 1-7 & CP]    Tsuen Wan        The Ming An Ins Co (HK) Ltd 
"Beneville [Blks 1-3, 5 & CP]"    "18 Tuen Kwai Road, Tuen Mun"        Sun Hung Kai Properites Ins Ltd 
Beverly Garden  [Blks 1-10 & CP]    Tseung Kwan O        Allianz Insurance (HK) Ltd

Thanks in advance.
Last edited by jim mcnamara; 08-13-2008 at 04:11 PM..
# 2  
Old 08-13-2008
There is no "pattern" as what divides the fields into 3 indentifiable fields. Is it by column?
ie field 1 goes from Col 1 - 34, Col 2 35 - 102, etc. Or the gaps of several white spaces?
# 3  
Old 08-13-2008
Hi..

The first column ends after this symbol ].
then the remaining words of each line is 2nd and 3rd columns respectively.

Eg.
Aberdeen Centre [Blks A-U & CP] is the first column value.
--------------------------------
Aberdeen is the second column value.
--------
The Ming An Ins Co (HK) Ltd is the third column value.
---------------------------


Based on this value i want to split the content individually. Please help me.

Thanks.
# 4  
Old 08-14-2008
Hi All,

Please somebody help me on this..
I believe, I have given the sufficient details.
If anybody wants more details please let me know.

Thanks in advance.
# 5  
Old 08-14-2008
please post input content and expected output content
# 6  
Old 08-14-2008
Code:
awk -F'   +' '{printf"%-60s%-60s%s\n", $1,$2,$3}' file

or if you have more than 3 fields


Code:
awk -F'   +' '{for(i=1;i<=NF;i++) printf"%-60s",$i; print ""}' file

# 7  
Old 08-14-2008
Maybe
sed s/\ \ \ \ /:/g filename | awk -F: '{print $1}'
sed s/\ \ \ \ /:/g filename | awk -F: '{print $2}'
sed s/\ \ \ \ /:/g filename | awk -F: '{print $4}'
might work assuming the spacing is correctly presented in the example code (i.e. four spaces between columns 1 and 2 and eight spaces between columns 2 and 3) and there are never as many as four spaces anywhere but in the separation of fields. The colon ":" may be substituted for any character that does not appear in the file.

(As an aside
sed s/\ \ \ \ /:/g filename | awk -F: '{print $3}'
was intentionally skipped as this would produce nothing given the above assumptions are correct.)
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question