Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Reducing multiple entries in a tri-lingual dictionary to single entries
Top Forums Shell Programming and Scripting Reducing multiple entries in a tri-lingual dictionary to single entries Post 302942051 by Scrutinizer on Friday 24th of April 2015 12:13:03 AM
Old 04-24-2015
Hi, try:
Code:
awk '{n=split($1,F,/[,;]/); for(i=1; i<=n; i++) print F[i],$2,$3}' FS='\t' OFS='\t' file

--edit--
This will work on Linux / Unix. Just noticed that it needs to work under Windows.

Can't help you there.. I know there can be quoting issues, maybe CR/LF related issues...

Perhaps you could put the script in a file and execute that:

keyword_split.awk:
Code:
BEGIN {
  FS=OFS="\t"
}
{
  n=split($1,F,/[,;]/)
  for(i=1; i<=n; i++) print F[i],$2,$3
}

And execute with
Code:
awk -f keyword_split.awk file

Or use Cygwin or some other simulation...
Last edited by Scrutinizer; 04-24-2015 at 01:45 PM..
This User Gave Thanks to Scrutinizer For This Post:
gimley
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Tri-booting?

Is it possible to triple boot with Solaris 9 (x86 version)? I installed XP Prof first, then Linux Fedora. Currently there it is a dual boot, and the dual boot software came with Fedora. I already used partition magic to allocate 5 gigs of free space on my disk. Basically my questions are:... (1 Reply)
Discussion started by: CapsuleCorpJX
1 Replies

2. UNIX for Dummies Questions & Answers

Need advice! Removing multiple entries in a single file!

Hello, I have a file Test.txt with 9 columns that looks like this: 1g12 A 14 19 2OAY A 326 331 AAAASA 1l7v A 68 73 1l7v A 68 73 AALAIS 1l7v A 68 73 1XVW B 72 77 AALAIS 1l7v A 68 73 1XXU A 65 70 AALAIS 1l7v A 68 73 1XXU B 65 70 AALAIS 1l7v A 68 73 1XXU C 65 70 AALAIS 1l7v A 68 73 1XXU D... (4 Replies)
Discussion started by: InfoSeeker
4 Replies

3. UNIX for Dummies Questions & Answers

Grep multiple strings in multiple files using single command

Hi, I will use below command for grep single string ("osuser" is search string) ex: find . -type f | xarg grep -il osuser but i have one more string "v$session" here i want to grep in which file these two strings are present. any help is appreciated, Thanks in advance. Gagan (2 Replies)
Discussion started by: gagan4599
2 Replies

4. Shell Programming and Scripting

Multiple lines in a single column to be merged as a single line for a record

Hi, I have a requirement with, No~Dt~Notes 1~2011/08/1~"aaa bbb ccc ddd eee fff ggg hhh" Single column alone got splitted into multiple lines. I require the output as No~Dt~Notes 1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh" mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies

5. Shell Programming and Scripting

Awk match multiple columns in multiple lines in single file

Hi, Input 7488 7389 chr1.fa chr1.fa 3546 9887 chr5.fa chr9.fa 7387 7898 chrX.fa chr3.fa 7488 7389 chr21.fa chr3.fa 7488 7389 chr1.fa chr1.fa 3546 9887 chr9.fa chr5.fa 7898 7387 chrX.fa chr3.fa Desired Output 7488 7389 chr1.fa chr1.fa 2 3546 9887 chr5.fa chr9.fa 2... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

6. Shell Programming and Scripting

Filtering out Non-Lingual characters

In one of our project requirements , we will be SCANNING ALL RECORDS OF AN INPUT TEXT FILE AND WILL BE FILTERING OUT RECORDS WHICH CONTAINS NON-LINGUAL CHARACTERS What's meant by this requirement is that we will be retaining records that contains alphabets used in any language , like English... (1 Reply)
Discussion started by: kumarjt
1 Replies

7. Shell Programming and Scripting

Multiple entries for shell

I have a simple shell file (convert.sh), that I would like to add a loop to that allows the user to have the "Enter ID:" prompt keep displaying until end is typed. So instead of: bash ~/convert.sh Enter ID:123 bash ~/convert.sh Enter ID:456 bash ~/convert.sh Enter ID:789 The user would... (7 Replies)
Discussion started by: cmccabe
7 Replies

8. Shell Programming and Scripting

Script to code every 2 consecutive entries as single entry

All, I come across the below requirement and my search on the previous posts did not result into any matches. I have one column of data from a csv file like below. And I need to add additional column based on string count in first column. Given column, Required column, Other columns A, 1,... (8 Replies)
Discussion started by: ks_reddy
8 Replies

9. Shell Programming and Scripting

Help need to convert bi-lingual files in sub-title format

I have a large number of files in the standard subtitle format with the additional proviso that the files are bi-lingual i.e. English and a second language: in this case Hindi. A small sample is given below: 00 04 07 08 00 04 11 00 I mean very high fever... He even vomited. 00 04 07 08 00... (6 Replies)
Discussion started by: gimley
6 Replies

10. Shell Programming and Scripting

Identifying single words in a dictionary database

I am reworking a Marathi-English dictionary to be out on open-source. My dictionary has the Headword in Marathi, followed by its Part of Speech and subsequently by its English glosses as in the examples below; अकरसणें v i To contract, shrink. अकरा a Eleven. अकराळ a Frightful, terrible. विकराळ... (2 Replies)
Discussion started by: gimley
2 Replies

LEARN ABOUT DEBIAN

dictconv

DICTCONV(1)							   User Commands						       DICTCONV(1)

NAME

       DictConv: - dictionary file converter

SYNOPSIS

       dictconv [-hv] -o OUTPUT_FILE INPUT_FILE

DESCRIPTION

       Convert INPUT_FILE dictionary to OUTPUT_FILE dictionary.  The extension of file determines the dictionary type.

       -o     OUTPUT_FILE	path to target dictionary

       INPUT_FILE
	      path to source dictionary

       -h     print help message and exit

       -?     print help message and exit

       -v     shows the version information and exit

   INPUT_FILE can be:
	      Babylon Glossary (.bgl) Freedict dictionary (.tei) Sdictionary dictionary (.dct) StarDict dictionary (.ifo)

   OUTPUT_FILE can be:
	      DICT dictionary (.index) PlainText dictionary (.dic) StarDict dictionary (.ifo)

       Convert INPUT_FILE dictionary to OUTPUT_FILE dictionary.  The extension of file determines the dictionary type.

       -o     OUTPUT_FILE	path to target dictionary

       INPUT_FILE
	      path to source dictionary

       -h     print help message and exit

       -?     print help message and exit

       -v     shows the version information and exit

   INPUT_FILE can be:
	      Babylon Glossary (.bgl) Freedict dictionary (.tei) Sdictionary dictionary (.dct) StarDict dictionary (.ifo)

   OUTPUT_FILE can be:
	      DICT dictionary (.index) PlainText dictionary (.dic) StarDict dictionary (.ifo)

SEE ALSO

       DictConv homepage: http://ktranslator.sourceforge.net/

       The GNU General Public License.

AUTHOR

       DictConv was written by Raul Fernandes <rgfbr@yahoo.com.br>.

       This manual page was written by Francesco Namuri with help2man tool.

Francesco Namuri						     July 2007							       DICTCONV(1)
All times are GMT -4. The time now is 09:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy