cut a string in a textfile line per line Post: 302313479

Sponsored Content

Top Forums Shell Programming and Scripting cut a string in a textfile line per line Post 302313479 by vgersh99 on Tuesday 5th of May 2009 07:24:41 PM

05-05-2009

Moderator

given your sample tmp2.txt:

Code:

BAC0904102604 -> BAC
AFR0904102604 -> AFR
HHF0904102604 -> HHF
UI100904102907 ->UI10
sdf_ada_9541-9543.1 -> sdf_ada
_fsf13145533 -> fsf

and myTextFile:

Code:

BAC0904102604foo
AFR0904102604bar fred
sdf_ada_9541-9543.1foo
HHF0904102604function
UI100904102907brick
sdf_ada_9541-9543.1red
_fsf13145533black
BAC0904102604yellow
sdf_ada_9541-9543.1fred

nawk -f izuma.awk tmp2.txt myTextFile

Code:

# reading the FIRST file specified on the command line.
# create an array 'arr' indexed by the FIRST field ($1) of the file with the value from the THIRD
# field ($3) of the file. Jump to the 'next' record without executing the rest of the code.
FNR==NR { arr[$1]=$3; next }

# reading the SECOND file specified on the command line.
{

  # iterate through all the entries in array 'arr' - 'i' contains the INDEX to array 'arr'
  # substitute a value of 'i' from the begging of the line (^) with the value of 'arr[i]'.
  # 'gsub' returns the NUMBER of the performed substitutions
  # add the number of the substitutions to an array 'sum' indexed by 'arr[i]'
  for( i in  arr)
     sum[arr[i]]+=gsub("^" i, arr[i])
}
END {

  # iterate through the array 'sum' outputting the total number of the performed substitutions
  # per pattern/prefix
  for (i in sum)
    printf("[%s] -> [%d]\n", i, sum[i])
}

Last edited by vgersh99; 05-06-2009 at 08:16 AM.. Reason: comments

vgersh99

View Public Profile for vgersh99

Find all posts by vgersh99

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To cut end string from line

HI, I want to cut end string from line. e.g. i have following input line /users/home/test.txt I want to get end string 'test.txt' from above line and length of that end string will change and it always start after '/'. Thanks, Visu

2. Shell Programming and Scripting

4 GB delimited-textfile on ONE LINE

3. Shell Programming and Scripting

Cut string from a line into a variable

Hi, I am working on a ksh script and I�m stuck on the following: I have to get the pthread_id from a procstack file for a particular tid#. ---------- tid# 1274057 (pthread ID: 1800) ---------- ---------- tid# 1736913 (pthread ID: 4019) ---------- ---------- tid# 1478705 (pthread ID: ...

4. Shell Programming and Scripting

Get line of textfile and store it in variable

Hi! I need to do the following: (1) I wan't to extract a line of a textfile (defined by a numer) and store it into a variable... (2) ...but I want to cut out a part of the line which is between two tokens and store just this to the variable Example: BlaBlaBla Bla2Bla2Bla2 *pPointerOne;...

5. Shell Programming and Scripting

How to extract more than 1 line in a textfile ?

Hi, I'm starting a little project with a shell script but I'm don't know how to do it. Maybe someone can help me. I have un text file like this : I'd like to do a script who will extract from my file from @ADDLINE1@ to @ADDLINE4@ only and I have no idea how to do this. Any idea ? ...

6. Solaris

Line too long error Replace string with new line line character

I get a file which has all its content in a single row. The file contains xml data containing 3000 records, but all in a single row, making it difficult for Unix to Process the file. I decided to insert a new line character at all occurrences of a particular string in this file (say replacing...

7. Shell Programming and Scripting

Cut line up to a string

hi all In my bash script I want to cut a line up to a specific string and keep the rest of it but only up to a ".How can I do that?I imagine something with sed.. Let's say my line is: Jennifer Jones (student) "id:376765748587/7465674775" NewYork and i only want to keep: ...

8. Shell Programming and Scripting

Write $line number into textfile and read from line number

Hello everyone, I don't really know anything about scripting, but I have to manage to make this script, out of necessity. #!/bin/bash while read -r line; do #I'm reading from a big wordlist instructions using $line done Is there a way to automatically write the $line number the script...

9. Shell Programming and Scripting

awk print in one line after reading textfile with paragraphs

Hello everybody I have a text file which has the following format: nmm "text20140601.033954text" "text" "text" "text" , ... , "text" "text" , ... , Lat 36.3247 Lon 16.0588 Depth 8 "text", ... , "text" "text", ..., CovXX 1.65 CovYY 2.32 CovZZ 1.2 "text" , ..., "text nmm ...

LEARN ABOUT NETBSD

cut

CUT(1)							    BSD General Commands Manual 						    CUT(1)

NAME

     cut -- select portions of each line of a file

SYNOPSIS

     cut -b list [-n] [file ...]
     cut -c list [file ...]
     cut -f list [-d delim] [-s] [file ...]

DESCRIPTION

     The cut utility selects portions of each line (as specified by list) from each file and writes them to the standard output.  If the file
     argument is a single dash ('-') or no file arguments were specified, lines are read from the standard input.  The items specified by list can
     be in terms of column position or in terms of fields delimited by a special character.  Column numbering starts from 1.

     list is a comma or whitespace separated set of increasing numbers and/or number ranges.  Number ranges consist of a number, a dash (-), and a
     second number and select the fields or columns from the first number to the second, inclusive.  Numbers or number ranges may be preceded by a
     dash, which selects all fields or columns from 1 to the first number.  Numbers or number ranges may be followed by a dash, which selects all
     fields or columns from the last number to the end of the line.  Numbers and number ranges may be repeated, overlapping, and in any order.	It
     is not an error to select fields or columns not present in the input line.

     The options are as follows:

     -b list	 The list specifies byte positions.

     -c list	 The list specifies character positions.

     -d string	 Use the first character of string as the field delimiter character.  The default is the <TAB> character.

     -f list	 The list specifies fields, separated by the field delimiter character.  The selected fields are output, separated by the field
		 delimiter character.

     -n 	 Do not split multi-byte characters.

     -s 	 Suppresses lines with no field delimiter characters.  Unless specified, lines with no delimiters are passed through unmodified.

EXIT STATUS

     cut exits 0 on success, 1 if an error occurred.

SEE ALSO

     paste(1)

STANDARDS

     The cut utility conforms to IEEE Std 1003.2-1992 (``POSIX.2'').

BSD
								 December 21, 2008							       BSD

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To cut end string from line

Discussion started by: visu

2. Shell Programming and Scripting

4 GB delimited-textfile on ONE LINE

Discussion started by: magedfawzy

3. Shell Programming and Scripting

Cut string from a line into a variable

Discussion started by: tmf33uk

4. Shell Programming and Scripting

Get line of textfile and store it in variable

Discussion started by: Michi21609

5. Shell Programming and Scripting

How to extract more than 1 line in a textfile ?

Discussion started by: Poulki

6. Solaris

Line too long error Replace string with new line line character

Discussion started by: ducati

7. Shell Programming and Scripting

Cut line up to a string

Discussion started by: vlm

8. Shell Programming and Scripting

Write $line number into textfile and read from line number

Discussion started by: bobylapointe

9. Shell Programming and Scripting

awk print in one line after reading textfile with paragraphs

Discussion started by: phaethon

LEARN ABOUT NETBSD

cut