To Extract words from File based on Position Post: 302399437

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers To Extract words from File based on Position Post 302399437 by kuttu123 on Sunday 28th of February 2010 03:37:22 AM

02-28-2010

Registered User

Hi

b/w is short form of 'between'......

Starting position of the String is where the words like Orange/Mango/cricket etc.. (starting position is 8 I guess...and from there next 7 characters )

i/p file data :--->

I like Orange Very Much
I like Mango also
We are Grape lovers.
We play Cricket usually
We are Chess players

o/p file data needed -->

I like Apple Very Much
I like Apple also
We are Grape lovers.
We play Football usually
We are Football players

I need the original lines with the words replaced in the output file if they happen to fall into these columns.

but would like to display the portions replaced alone also . This for only display purpose.

---------- Post updated at 02:51 AM ---------- Previous update was at 02:43 AM ----------

Malcom..

Seems your code is fine..Thanks..I will confirm with in 15 mins.

Thanks

---------- Post updated at 03:37 AM ---------- Previous update was at 02:51 AM ----------

Malcome,

Your script is working fine if both strings ( Original and replaced part )
are of identical size.

ie It is working fine If am replacing 'Orange' (6 leter ) by another 6 leter word (say 'apples').

But If am replacing a 7 letter word ( say 'Cricket' ) with a 4 letter word ( say 'Golf' ) then its not working fine. It will replace the word .But position of next column changes.

This is wat i need -->

If a 7 leter word is replaced by a 5 leter word, then next 2 positions will be 'SPACES' so that the position of next column remains unchanged.

I guess u got my problem.

kuttu123

View Public Profile for kuttu123

Find all posts by kuttu123

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extract words to new file

Hi there, Unix Gurus Working with big listings of english sentences for my pupils, of the type: 1. If the boss's son had been , someone would have asked for money by now. 2. Look, I haven't a crime, so why can't you let me go? .... I wondered how to extract the words between brackets in...

2. Shell Programming and Scripting

Extract data based on position

The file has record length 200. And i have 100 search strings which are ten digits of character from 1 to 10 characters all of them are unique, they need to searched in a file. Please help me to pull the records based on position (say from 1-10). test data 1FAHP2DW0BG115206RASHEED ...

3. UNIX for Dummies Questions & Answers

Script to delete a word based on position in a file

Hi, I am new to unix. I want to delete 2 words placed at position say for example at 23rd and 45th position in a line. I used sed but couldnt achieve this. Example: the file contains 2 lines 12345 98765 "12345" 876 12345 98765 "64578" 876 I want to delete " placed at position 13 and 19...

4. UNIX for Dummies Questions & Answers

extract regions of file based on start and end position

Hi, I have a file1 of many long sequences, each preceded by a unique header line. file2 is 3-columns list: headers name, start position, end position. I'd like to extract the sequence region of file1 specified in file2. Based on a post elsewhere, I found the code: awk...

5. Shell Programming and Scripting

Put words to fix position in a file

Hi all, There are several lines in my file as a=123,b=dene,c=2312,d=234234,g=vxcvxcv,h=44 a=3,b=dene,c=22,d=23422342334,g=vxcvxcv,h=4 a=123,b=dene,c=2312,d=234234,g=vxcvxcv,h=678 I take values with this command awk -F '' '{print $1,$2,$3}' a.txt I want to put values to a fix position...

6. Shell Programming and Scripting

Extract substring specif position and length from file line

Hi gurus, I am trying to figure out how to extract substring from file line (all lines in file), as specified position and specified legth. Example input (file lines) dhaskjdsa dsadhkjsa dhsakjdsad hsadkjh dsahjdksahdsad sahkjd sahdkjsahd sajkdh adhjsak I want to extract substring on...

7. Shell Programming and Scripting

Split file based on distinct value at specific position

OS : Linux 2.6x Shell : Korn In a single file , how can I identify all the Uniqe values at a specific character position and length of each record , and simultaneously SPLIT the records of the file based on each of these values and write them in seperate files . Lets say : a) I want to...

8. Shell Programming and Scripting

Search for a string at a particular position and replace with blank based on position

Hi, I have a file with multiple lines(fixed width dat file). I want to search for '02' in the positions 45-46 and if available, in that lines, I need to replace value in position 359 with blank. As I am new to unix, I am not able to figure out how to do this. Can you please help me to achieve...

9. Shell Programming and Scripting

Search words in any quote position and then change the words

hi, i need to replace all words in any quote position and then need to change the words inside the file thousand of raw. textfile data : "Ninguno","Confirma","JuicioABC" "JuicioCOMP","Recurso","JuicioABC" "JuicioDELL","Nulidad","Nosino" "Solidade","JuicioEUR","Segundo" need...

10. Shell Programming and Scripting

Replace particular words in file based on if finds another words in that line

Hi All, I need one help to replace particular words in file based on if finds another words in that file . i.e. my self is peter@king. i am staying at north sydney. we all are peter@king. How to replace peter to sham if it finds @king in any line of that file. Please help me...

LEARN ABOUT DEBIAN

sql::reservedwords::postgresql

SQL::ReservedWords::PostgreSQL(3pm)			User Contributed Perl Documentation		       SQL::ReservedWords::PostgreSQL(3pm)

NAME

       SQL::ReservedWords::PostgreSQL - Reserved SQL words by PostgreSQL

SYNOPSIS

	  if ( SQL::ReservedWords::PostgreSQL->is_reserved( $word ) ) {
	      print "$word is a reserved PostgreSQL word!";
	  }

DESCRIPTION

       Determine if words are reserved by PostgreSQL.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3, 7.4, 8.0 or 8.1.

       is_reserved_by_postgresql7( $word )
	   Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3 or 7.4.

       is_reserved_by_postgresql8( $word )
	   Returns a boolean indicating if $word is reserved by either PostgreSQL 8.0 or 8.1.

       reserved_by( $word )
	   Returns a list with PostgreSQL versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_postgresql7
       is_reserved_by_postgresql8
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://www.postgresql.org/docs/manuals/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28				       SQL::ReservedWords::PostgreSQL(3pm)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extract words to new file

Discussion started by: eldeingles

2. Shell Programming and Scripting

Extract data based on position

Discussion started by: zooby

3. UNIX for Dummies Questions & Answers

Script to delete a word based on position in a file

Discussion started by: nbks2u

4. UNIX for Dummies Questions & Answers

extract regions of file based on start and end position

Discussion started by: pathunkathunk