I have a .cvs file that I have re-formatted for loading that sometimes has multiple data rows on the same row with common values. I have managed to get all the rows where I want except a few and want to evaluate if the combined ending value matches 1Q-02BBL1 since I am combining 1Q-02B and BL1 if the last and first value match omit one of them. I know that it is showing up in my substr(word1,1,6) in my final else... I just don't know what statement to put in front of it in the else if .. to compensate before I finalize it ....
awk script
{FS=",";
n=split($1,a,"/")
q=split(a[1],r,"L1")
word1=a[1]
word2=a[2]
split(a[1],r,"L1"); split($1,a,"/"); split($6,b,"/"); split($7,c,"/"); for (i=1; i<=n; i++)
if ( n == 1 )
printf ("%-25s%-36s%-9s%-9s%-9s%-15s%-15s\n",$1,$2,$3,$4,$5,$6,$7)
else
if ( substr(word1,1,3) == substr(word2,1,3) )
printf ("%-25s%-36s%-9s%-9s%-9s%-15s%-15s\n",a[i],$2,$3,$4,$5,b[i],c[i])
else
if ( i == 1 )
printf ("%-25s%-36s%-9s%-9s%-9s%-15s%-15s\n",a[i],$2,$3,$4,$5,b[i],c[i])
else
if (i >= 2 && r[1] > 1 )
printf ("%-25s%-36s%-9s%-9s%-9s%-15s%-15s\n",r[1]a[i],$2,$3,$4,$5,b[i],c[i])
else
printf ("%-25s%-36s%-9s%-9s%-9s%-15s%-15s\n",substr(word1,1,6)a[i],$2,$3,$4,$5,b[i],c[i])
}
sample data:
1F-01A,CTD Extension Rotary/CTD Combo,05/23/05,N/A,06/11/05,Not Tracking,Not Tracking
15-08CL1,CTD Multilateral,02/23/05,02/25/05,03/03/05,10016,12317
1B-15AL1/L2,CTD Multilateral,09/22/05,09/25/05,10/14/05,8340/8289,9731/10992
1D-34L1,CTD Multilateral,09/07/05,09/10/05,09/22/05,15724 ,18350
1D-36L1/L2,CTD Multilateral,07/16/05,07/19/05,08/01/05,11410/11360,13548/13302
1D-42L1,CTD Multilateral,07/02/05,07/05/05,07/16/05,8415,10918
1J-03L1/L2,CTD Multilateral,08/15/05,08/17/05,09/06/05,11597/11574,13035/13586
1L-25A/L1-01/L1-02 ,CTD Multilateral,11/27/05,12/01/05,12/28/05,8838/8938/9380,11929/9855/10374
1Q-04L1/L1-02/L1-01/L1-03,CTD Multilateral,10/14/05,10/17/05,11/05/05,9076/10061/9198/10099,10895/10934/11270/10597
3H-14BL1 (P&A'd)/L2/L3,CTD Multilateral,12/29/05,12/31/05,,8025/8305/null,9200/null/null
02-17B,CTD Sidetrack,09/03/05,09/07/05,09/15/05,11606,13576
1D-37L1/L2,CTD Sidetrack,06/11/05,06/14/05,07/02/05,10741/10594,12472/13087
1Q-02B/BL1,CTD Sidetrack,11/06/05,11/08/05,11/27/05,8540/9602,11501/12050
S-213A/S-213AL1/S-213AL1-01/S-213L2/S-213L3,Multilateral,11/19/04,11/25/04,2/3/05,2870/6397/7581/6108/5985,12190/12160/12043/1210
0/12054
last record is wrapped ... but is one line
Output Issue: in the whole file only two evalute to this problem ...
1Q-02B CTD Sidetrack 11/06/05 11/08/05 11/27/05 8540 11501
1Q-02BBL1 CTD Sidetrack 11/06/05 11/08/05 11/27/05 9602 12050
The problem is the "BB" value ... if the ending character of the value matches the beginning values of a [i]then I want to omit one of them ... is it possible? to write something that evaluates the last value with the first values and does it ... something like [AA - ZZ]?
1Q-02B ....
1Q-02BL1...
Thanks to anyone who wants to help