Add an incrementing identity column to a file Post: 302983960

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Add an incrementing identity column to a file Post 302983960 by MadeInGermany on Wednesday 19th of October 2016 04:26:36 AM

Old

10-19-2016

Registered User

Thanks for the note. A typo. I have corrected my post.

MadeInGermany

View Public Profile for MadeInGermany

Find all posts by MadeInGermany

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Port incrementing using one file

Hi I wrote this script with the help of you guyz.My next challenge is to increment the port using single file.So far iam using this code to increment hp1 and hp2 .To increment port numbers, iam using two different files (.default_port_hp1 and .default_port_hp2).The challenge for me is to use...

2. Shell Programming and Scripting

Need to add letters to a column and add in a new column subtracting from another column

So I have this input 1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI 1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI 1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI 1 10583 rs58108140 G A ...

3. Shell Programming and Scripting

incrementing lines in the file & format output.

Hi All, I need read the file and out put format as below using ksh, I wrote below script its keep on repeating first line in the file. may i know the best way to get the below out put while incrementing line in the file. cat b.txt |awk '{print $0}' |while read line do aa=`cat $line |head -1...

4. Shell Programming and Scripting

Auto incrementing a particular column values

Hi All, I have the input file(.csv) like below. SNo,Step,Data 1,0,1 2,0,2 3,1,1 4,2,2 5,0,3 6,0,4 and I need the following output. 1,0,1 2,0,2 3,1,1 4,2,2 5,3,3 6,3,4

5. Shell Programming and Scripting

Change numbers in a file, incrementing them

Hello, Here's a file of mine: key1:431 key2:159 key3:998 I need to change these keys to something bigger - and I actually need to shift them all by a range of 3. The output would be: key1:434 key2:162 key3:1001 I can't find the propper sed/awk line that would alter all my...

6. UNIX for Dummies Questions & Answers

Incrementing the New File Version Number

Hello All, In the below script i am trying to check and list the file names, get the last file with highest version number and then increment the version number when i create another file. Example: file1 is COBANK_v1.xml and file2 i want to put it as COBANK_v2.xml, to achieve this i am using awk...

7. UNIX for Advanced & Expert Users

Add an incrementing identity column to a file

Two questions: 1) Is there a way to create a new column (i.e. ID) to an existing file containing data and the new column ID populate as an auto incrementing number? for example: (Current file has headers and is PIPE delimited.) **data looks like this** "COL1"|"COL2"|"COL3"|"COL4"|"COL5"...

8. UNIX for Beginners Questions & Answers

Incrementing the New File Version Number

Hi, This is my first post here. I am using cygwin on Windows 7. I am starting with a data file with filename "name_1.ext", like "20180831_snapgenotypes_1.csv". The "_1" before ".ext" is a version number. Integers (0-99) are sufficient. They don't have to be like "1.0.0". The filename may...

LEARN ABOUT OPENSOLARIS

note

note(4) 							   File Formats 							   note(4)

NAME

       note - specify legal annotations

SYNOPSIS

       /usr/lib/note

DESCRIPTION

       Each  file  in  this  directory	contains  the NOTE (also _NOTE) annotations legal for a single tool.  The name of the file, by convention,
       should be the tool vendor's stock name, followed by a hyphen, followed by the tool name. For example, for Sun's lock_lint tool the filename
       should be SUNW-lock_lint.

       The  file should contain the names of the annotations understood by the tool, one per line.  For example, if a tool understands the follow-
       ing annotations:

	 NOTE(NOT_REACHED)
	 NOTE(MUTEX_PROTECTS_DATA(list_lock, list_head))

       then its file in /usr/lib/note should contain the entries:

	 NOT_REACHED
	 MUTEX_PROTECTS_DATA

       Blank lines, and lines beginning with a pound (#), are ignored.

       While /usr/lib/note is the default directory tools search for such files, they can be made to search other directories  instead	simply	by
       setting	 environment   variable   NOTEPATH   to   contain   the  paths,  separated  by	colons,  of  directories  to  be  searched,  e.g.,
       /usr/mytool/note:/usr/lib/note.

USAGE

       These files are used by such tools whenever they encounter NOTEs they do not understand.  If a file in /usr/lib/note contains  the  annota-
       tion, then it is valid. If no such file contains the annotation, then the tool should issue a warning complaining that it might be invalid.

ENVIRONMENT VARIABLES

       NOTEPATH    specify paths to be searched for annotation files. Paths are separated by colons (":").

SEE ALSO

       NOTE(3EXT)

SunOS 5.11							    17 Jan 1995 							   note(4)