Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RaoulZa

    Data that just wont sort

    its ok i found it - for some reason the data was sorted as you specified, but it was producing that sort of output. so where i was expecting 11010A to be before 11010B, sometimes the letters at the end seemed to be appearing randomly - as above where there are several with B on the end followed...
  2. RaoulZa

    Data that just wont sort

    *pulls hair out* ok this has left me with mostly the sort that I want, except that it has given me for example 11010A 11010A 11010A 11010A 11010B 11010B 11010B 11010A does this constitute a sort on an individual column after the main sort on the field, if so hows it done? thanks
  3. RaoulZa

    Data that just wont sort

    bah it was +5 as " is the delimiter, not ',' thanks again
  4. RaoulZa

    Data that just wont sort

    sort -n -t\" +3 m3a.txt > m3b thats not doing it for me ( so to speak ) *sobs helplessly as he cant quite figure it out*
  5. RaoulZa

    Data that just wont sort

    danke
  6. RaoulZa

    Data that just wont sort

    that was brilliant if i wanted to sort on the third field do i substitute a 3 for the 1? Za
  7. RaoulZa

    Data that just wont sort

    "10790","F3","F","","00:00","23:59", "10800A","F3","F","","00:00","23:59" "10800","F2","F","","00:00","23:59&quot...
  8. RaoulZa

    Adding " to each end of a field in an awk print statement

    Thanks very much both of you. Before i got the answers along I decided to do it the long winded way, and output tilders around the fields, converting them to quotes using sed "s /\~/\"/g". But my thanks again for your help.
  9. RaoulZa

    Adding " to each end of a field in an awk print statement

    Can anybody tell me the correct character to use so that i can change data from non quotes to quotes please? For example 12345,abcde,12346 to "12345","abcde","12346" i thought it would be \" but its telling me its not correctly parsed thanks very much
    • RaoulZa
    • Thread
    • Replies: 3
    • Forum: AWK
  10. RaoulZa

    Formula for unmatched data

    Thanks for that - I am on the way there, but i now have three columns of data. Is there any way to suppress the unwanted data (i.e. the matching stuff ) so that only the fields that do not match are shown?
  11. RaoulZa

    Formula for unmatched data

    Hi I am developing a report using two tables from two seperate audit reports. I need to find out the expressions to be used in a formula that will compare the identity field of one table against the identity field of the other table to see if there are any mismatches. For example - M12345 is...
  12. RaoulZa

    Comparing Two files using awk and a while loop

    "M14609",,"GATLIFF ROAD",,"NPO MGMENT","129.1.14.150","DCHP",,5/9/02 0:00:00,"In Test Room for PFW UAT.","T2-Type",,,0 this is the type of data i am using - comma delimited, this is...
  13. RaoulZa

    Comparing Two files using awk and a while loop

    tried it - no joy. i know diff -e gives me a version i can use directly for output, but it also includes gibberish from the file. i think my problem lies in the fact that i cant do a join on more than one field at a time - i basically have an audit file where a pc has the same id ( primary...
  14. RaoulZa

    Comparing Two files using awk and a while loop

    Hi I'm fairly new to UNIX, and I was after a bit of help. I have two files identical but for some field changes on certain lines. What I want to do is create a while loop that feeds in the two fields i am checking on, and puts them into an awk as variables that i can use to compare to the...

Part and Inventory Search

Back
Top