Search results for query: *

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...

*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

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

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*

danke

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

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

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.

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

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?

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...

"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...

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...

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...