Adding a new column as sequential number but with a little complication Post: 302588691

Sponsored Content

Top Forums Shell Programming and Scripting Adding a new column as sequential number but with a little complication Post 302588691 by johnhips on Monday 9th of January 2012 06:18:41 PM

01-09-2012

Registered User

This is my desired output and I cannot get it to work.

Code:

"KEYRECORD"|"SA ID"|"PER ID"|"SP ID"|"ACCT ID"|"PREM ID"|"PHONE"|"NA
1|"          "|"          "|"3197691605"|"          "|"3197691657"|"
2|"          "|"          "|"3246309010"|"          "|"3246309029"|"
3|"          "|"          "|"3350909705"|"          "|"3311776290"|"
3|"          "|"          "|"3311776205"|"          "|"3311776290"|"
4|"          "|"          "|"3329099805"|"          "|"3329099858"|"
5|"          "|"          "|"3621605305"|"          "|"3621605356"|"
6|"0001344005"|"3157734331"|"3209921605"|"0001344441"|"3209921631"|"
6|"7189943005"|"3231403121"|"3210736405"|"0001344441"|"3210736492"|"
7|"0006746005"|"3287909287"|"3340056905"|"0006746763"|"3340056937"|"
8|"0007922990"|"5053661026"|"3519545205"|"0007922859"|"3519545208"|"
9|"0008717005"|"3508935326"|"3519329105"|"0008717685"|"3519329168"|
10|"0008969005"|"7117287080"|"3613118705"|"0008969048"|"3613118796"|
11|"0009160005"|"5094212566"|"3467460805"|"0009160056"|"3467460835"|

---------- Post updated at 06:18 PM ---------- Previous update was at 05:52 PM ----------

You are the best! I cannot figure how to compare the enclosed quotes and this fixed my code!! Thanks again!!

johnhips

View Public Profile for johnhips

Find all posts by johnhips

10 More Discussions You Might Find Interesting

1. Programming

Reading special characters while converting sequential file to line sequential

We have to convert a sequential file to a 80 char line sequential file (HP UX platform).The sequential file contains special characters. which after conversion of the file to line sequential are getting coverted into "new line" or "tab" and file is getting distorted. Is there any way to read these...

2. UNIX for Dummies Questions & Answers

Adding a column with the row number using awk

Is there anyway to use awk to add a first column to my data that automatically goes from 1 to n , where n is the numbers of my rows?:confused:

3. Programming

Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX

Writing a Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX I have over the years come across the same issue a couple of times, and it normally is that the read speed on SAN is absolutely atrocious when doing non-sequential I/O to the disks. Problem being of...

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256...

5. Shell Programming and Scripting

Taking largest (negative) number from column of coordinates and adding positive form to every other

Hello all, I'm new to the forums and hope to be able to contribute something useful in the future; however I must admit that what has prompted me to join is the fact that currently I need help with something that has me at the end of my tether. I have a PDB (Protein Data Bank) file which I...

6. UNIX for Dummies Questions & Answers

Inserting a sequential number into a field on a flat file

I have a csv flatfile with a few million rows. I need to replace a field (field number is 85) in the file with a sequential number. As an example, let's assume there are only 4 fields in the file: A,A,,32 A,A,,27 A,B,,43 C,C,,354 If I wanted to amend the 3rd field in this way my...

7. Shell Programming and Scripting

Add markup tag and sequential number after specific line

Hello, This one has me a bit stumped. I have data the looks like, M END > <PREDICTION_ACCURACY> PROBABLE > <NO_OF_PARENTS> 3 > <CLOGP> -13.373 > <SMILES> OCC(O)C(OC1OC(CO)C(OC2OC(CO)C > <MIMW> 1006.322419888

8. Shell Programming and Scripting

Adding values of a column based on another column

Hello, I have a data such as this: ENSGALG00000000189 329 G A 4 2 0 ENSGALG00000000189 518 T C 5 1 0 ENSGALG00000000189 1104 G A 5 1 0 ENSGALG00000000187 3687 G T 5 1 0 ENSGALG00000000187 4533 A T 4 2 0 ENSGALG00000000233 5811 T C 4 2 0 ENSGALG00000000233 5998 C A 5 1 0 I want to...

9. Shell Programming and Scripting

Adding number in one column

Hello I have something like this a 1 b 1 c 1 d 1 e 1 This is inside 1.dat and this is what I am trying to get a 2 b 2 c 2 d 2 e 2

10. Shell Programming and Scripting

Adding sequential index to duplicate strings

I have a text file in the following format >Homo sapiens KQKCLYNLPFKRNLEGCRERCSLVIQIPRCCKGYFGRDCQACPGGPDAPCNNRGVCLDQY SATGECKCNTGFNGTACEMCWPGRFGPDCLPCGCSDHGQCDDGITGSGQCLCETGWTGPS CDTQAVLPAVCTPPCSAHATCKENNTCECNLDYEGDGITCTVVDFCKQDNGGCAKVARCS...

LEARN ABOUT PHP

db2_field_type

DB2_FIELD_TYPE(3)							 1							 DB2_FIELD_TYPE(3)

db2_field_type - Returns the data type of the indicated column in a result set

SYNOPSIS

       string db2_field_type (resource	$stmt, mixed  $column)

DESCRIPTION

	Returns the data type of the indicated column in a result set.

PARAMETERS

	      o $stmt
		- Specifies a statement resource containing a result set.

	      o $column
		-  Specifies  the  column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
		string containing the name of the column.

RETURN VALUES

	Returns a string containing the defined data type of the specified column. If the specified column does  not  exist  in  the  result  set,
       db2_field_type(3) returns FALSE.

SEE ALSO

       db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_width(3).

PHP Documentation Group 													 DB2_FIELD_TYPE(3)

10 More Discussions You Might Find Interesting

1. Programming

Reading special characters while converting sequential file to line sequential

Discussion started by: Rajeshsu

2. UNIX for Dummies Questions & Answers

Adding a column with the row number using awk

Discussion started by: cosmologist

3. Programming

Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX

Discussion started by: vrghost

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Discussion started by: Vavad