Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- NR > 1 {print $METHOD "," $Sub_Type "," $Primary "," $GLOBAL "," $ID "," $UNIQUE "," ""=abc(D2&"" xxxx"",""SECURITY""")" "," ""=xyz(D2&"" xxxx"",""last"",""01/01/1900"",Today(),""Quote"",""P"",""Points=1"",""cols=2;rows=1"")"" "," "," "," ""=xyz(E2&"" xxxx"",""last"",""01/01/1900"",Today(),""Quote"",""P"",""Points=1"",""cols=2;rows=1"")"" "," "," "," ""=xyz(F2&"" buid"",""last"",""01/01/1900"",Today(),""QuoteType"",""P"",""Points=1"",""cols=2;rows=1"")"" "," "," "," ""=abc(D2&"" xxxx"",""source""")" "," ""=abc(D2&"" xxxx"",""CRNCY""")""," ""=abc(D2&"" xxxx"",""CRNCY""")" "," ""=IF(ISBLANK(H2),"""",IF(ISBLANK(K2),"""",IF(H2=K2,""Match"",""No Match""")))" "," ""=IF(ISBLANK(H2),"""",IF(ISBLANK(N2),"""",IF(H2=N2,""Match"",""No Match""")))" "," ""=IF(ISBLANK(K2),"""",IF(ISBLANK(N2),"""",IF(K2=N2,""Match"",""No Match""")))" "," "," "=C2" "," "" "," "=H2" "," "=I2" "," "=Q2" "," "=R2"}' $WORK_DIR/sortedmissing.csv > $WORK_DIR/output1.xls
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement