Record splitting with AWK

maixu134 · #1 (**permalink**) 10-23-2008

Hi all !

I need your help as quick as possible.

My input file like this:

bạc tình （薄情） 1 . 薄情な．２．夫婦或いは男女の不貞を指す。
bách (百，迫)1.100ﾄﾞｿ. tr a m b a c ともいう．２．柏（ｶヽしわ）･　3.圧迫する．４．差し迫った，

My propose is take the value in the firt bracket. I used the command like :
...if (index( $3,"(")==1)$3=substr($3,2,index($3,")")-1);
else if (index( $3,"(")==1)$3=substr($3,2,index($3,")1."-3);
and my result with the fist line, i take the value 薄情.
but the second line, the value is wrong. Because it took 百，迫)1.100ﾄﾞｿ. tr a m b a c ともいう．２．柏（ｶヽしわ.
but I want to take the 百，迫.

So what can I do?

radoulov · #2 (**permalink**) 10-23-2008

Try this:

Code:

awk -F'[)(]' '{print $2}' infile

Note:

Moved to Q & A.
To the OP: please don't post to unrelated old threads, open a new one instead.
Thank you!

maixu134 · #3 (**permalink**) 10-23-2008

But I did not know what does this mean of funtion -F

Franklin52 · #4 (**permalink**) 10-23-2008

Try this, I have used ( or ) as fieldseparators:

Code:

awk 'BEGIN{FS="\(|\)"} {print $2}' file

Regards

maixu134 · #5 (**permalink**) 10-23-2008

Before, I do like this:
BEGIN {
FS="\t";RS="\n";
}
Because now I want to take the words during ( ), and $3 it means the value I will take.
I write like this
if (index( $3,"(")==0 && index($3,"・・)==0)$3="";
else if (index( $3,"(")==1)$3=substr($3,2,index($3,"・・)-2);

My result will have 2 column, 1 is
bách
and the second column is 百，迫
but now I have problem when the lines have 2 ( ) like this
bách (百，迫)1.100ﾄﾞｿ. tr a m b a c ともいう．２．柏（ｶヽしわ)

After the bách I use tab code(button) and before the bách I also using the tab code.

And my result is
bách 百，迫)1.100ﾄﾞｿ. tr a m b a c ともいう．２．柏（ｶヽしわ

Then could you help me to fix my mistake?

Franklin52 · #6 (**permalink**) 10-23-2008

The problem is that the file is not well structured, you can try:

Code:

awk -F'[)(]' '{print $1, $2}' infile

Regards

radoulov · #7 (**permalink**) 10-23-2008

Quote:

Originally Posted by maixu134

Before, I do like this:
BEGIN {
FS="\t";RS="\n";
}
Because now I want to take the words during ( ), and $3 it means the value I will take.
I write like this
if (index( $3,"(")==0 && index($3,"・・)==0)$3="";
else if (index( $3,"(")==1)$3=substr($3,2,index($3,"・・)-2);

My result will have 2 column, 1 is
bách
and the second column is 百，迫
but now I have problem when the lines have 2 ( ) like this
bách (百，迫)1.100ﾄﾞｿ. tr a m b a c ともいう．２．柏（ｶヽしわ)

After the bách I use tab code(button) and before the bách I also using the tab code.

And my result is
bách 百，迫)1.100ﾄﾞｿ. tr a m b a c ともいう．２．柏（ｶヽしわ

Then could you help me to fix my mistake?

OK,
could you please post the output of the command below and explain what's wrong with it?
Just run it in your terminal:

Code:

awk -F'[)(]' '{print $1, $2}' name_of_your_input_file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Print Full record and substring in that record	ukatru	UNIX for Advanced & Expert Users	1	09-19-2008 06:32 PM
how to read record by record from a file in unix	raoscb	UNIX for Dummies Questions & Answers	1	05-16-2008 06:30 AM
Splitting a file based on record sin another file	er_ashu	UNIX for Dummies Questions & Answers	7	05-15-2008 11:06 PM
Script to search a bad record in a file then put the record in the bad file	shilendrajadon	Shell Programming and Scripting	2	12-28-2007 10:02 AM
splitting a record and adding a record to a file	rsolap	Shell Programming and Scripting	1	08-13-2007 01:58 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by