How do i find the first number in each line and insert dummy string into the missing columns? Post: 302569760

Sponsored Content

Top Forums Shell Programming and Scripting How do i find the first number in each line and insert dummy string into the missing columns? Post 302569760 by Szaffy on Tuesday 1st of November 2011 12:02:16 PM

11-01-2011

Registered User

Quote:

Originally Posted by CarloM

Is the numeric 4 column in the output always going to be column 5, or is it variable (whatever the maximum num4 column was in the input)?

Hi Carlo,

Numeric field is in variable position (column) in the input file!

First line 1808 is in column4
Second line 1802 is in column3
..
..
Last line 1797 is in column5

Regards
Szaffy

---------- Post updated at 04:02 PM ---------- Previous update was at 03:59 PM ----------

Quote:

Originally Posted by ahamed101

Try this...

Code:

awk '
  NR==FNR{a[$0]=NF;x<NF?x=NF:NULL;next}
  END{
    for(i in a){
      if(a[i]==x){ print i; continue }
      split(i,arr," "); s=length(arr);
      num2=arr[s];num1=arr[s-1]
      for(j=s-1;j<=x;j++){ arr[j]="DUMMYSTR" }
      arr[x-1]=num1; arr[x]=num2
      for(j=1;j<=length(arr);j++){ printf arr[j]" " }
      printf "\n"
    }
  }' input_file | sort

--ahamed

Hi Ahamed,

I getting the following error:

awk: Cannot read the value of arr. It is an array name.

Regards
Szaffy

Szaffy

View Public Profile for Szaffy

Find all posts by Szaffy

9 More Discussions You Might Find Interesting

1. AIX

How to insert dummy columns

Hi My requirement is as follows, I have a input feed coming for X as A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P; A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P; A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P; A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P; A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P; any other feed coming from Y is as ...

2. Shell Programming and Scripting

Insert text at line number

I wrote a script to grep for a closing XML node. Then I need it to navigate up a line and insert some XML. Then go to the next occurrance. I have this INSERT_NODE='<QUANTITATIVE NAME="'${QR_NAME}'" QUANT="1" />' GREP_FOR='</JOB>' TMP_FILE=/tmp/lineArray.$$ if ]; then continue else ...

3. Shell Programming and Scripting

find out line number of matching string using grep

Hi all, I want to display line number for matching string in a file. can anyone please help me. I used grep -n "ABC" file so it displays 6 ABC. But i only want to have line number,i don't want that it should prefix matching context with line number. Actually my original...

4. UNIX for Dummies Questions & Answers

To find missing numbers from a number series

Hi, My requirement is I have an input file with a continuous series from 10000 to 99999. I have some numbers missing from those series. I want a output file which produces those missing numbers. Eg: 10002, 99999 are missing from the series then the output file should contain those...

5. Shell Programming and Scripting

Find missing string with bash

If I have a file called file A with a list of filenames. How do I find all the filenames in file A that aren't contained in file B? I want to use bash scripting.

6. Shell Programming and Scripting

find string nth occurrence in file and print line number

Hi I have requirement to find nth occurrence in a file and capture data from with in lines (between lines) Data in File. <QUOTE> <SESSION> <ATTRIBUTE NAME='Parameter Filename' VALUE='file1.parm'/> <ATTRIBUTE NAME='Service Name' VALUE='None'/> </SESSION> <SESSION> <ATTRIBUTE...

7. Shell Programming and Scripting

Script to output a line missing a number

Ok, Lets see if I can explain this We have a script that pulls information from multiple files and outputs it, however I only need 2 Columns (of 11) from it right now I run the script like this: tkxtrn | awk '{print $5" "" "$9}' This gives me column 5 and 9, the only two I care for ...

8. Shell Programming and Scripting

Insert String every n lines, resetting line counter at desired string

I need to read a text file and insert a string every n lines, but also have the line counter restart when I come across a header string. Line repeating working every 3 lines using code: sed '0~3 s/$/\nINSERT/g' < INPUT/PATH/FILE_NAME.txt > OUTPUT/PATH/FILE_NAME.txt I cannot seem to find...

9. Shell Programming and Scripting

awk to insert missing string based on pattern in file

Using the file below, which will always have the first indicated by the digit after the - and last id in it, indicated by the digit after the -, I am trying to use awk to print the missing line or lines in file following the pattern of the previous line. For example, in the file below the next...

LEARN ABOUT DEBIAN

tabfunc

TABFUNC(1)						      General Commands Manual							TABFUNC(1)

NAME

       tabfunc - convert table to functions for rcalc, etc.

SYNOPSIS

       tabfunc [ -i ] func1 [func2 ..]

DESCRIPTION

       Tabfunc	reads  a  table  of  numbers  from  the  standard input and converts it to an expression suitable for icalc(1), rcalc(1) and their
       cousins.  The input must consist of a M x N matrix of real numbers, with exactly one row per line.  The number of columns  must	always	be
       the same in each line, separated by whitespace and/or commas, with no missing values.  The first column is always the independent variable,
       whose value indexes all of the other elements.  This value does not need to be evenly spaced, but it must be either monotonically  increas-
       ing  or	monotonically decreasing.  (I.e. it cannot go up and then down, or down and then up.)  Maximum input line width is 4096 characters
       and the maximum number of data rows is 1024.  Input lines not beginning with a numerical value will be silently ignored.

       The command-line arguments given to tabfunc are the names to be assigned to each column.  Tabfunc then produces a single function for  each
       column  given.	If  there are some columns which should be skipped, the dummy name "0" may be given instead of a valid identifier.  (It is
       not necessary to specify a dummy name for extra columns at the end of the matrix.)

       The -i option causes tabfunc to produce a description that will interpolate values in between those given for the independent  variable	on
       the input.

EXAMPLE

       To convert a small data table and feed it to rcalc for some calculation:

	 rcalc -e `tabfunc f1 f2 < table.dat` -f com.cal

AUTHOR

       Greg Ward

SEE ALSO

       cnt(1), icalc(1), neaten(1), rcalc(1), rlam(1), total(1)

RADIANCE
							      10/8/97								TABFUNC(1)