Search results for query: *

Hi, I have three files that I want to combine into one XML file. They are in the following format "field 1", "field 2" ..."field N" I need to create XML file based on data in all three file. I know that this is a bit vague but My question is would this be possible with AWK or am I better of...

That's great. Your a legend

One more question. How would I remove the bit that is after the new line. E.g. Input "first", "second" , "no prob" , "forth" "first", "second" , "third addres problem ", "forth field" "first", "second" , "no prob" , "forth" "first", "second" , "no prob" , "forth" output "first"...

That fixed it. Thanks a lot. Could you explain the code in red to me. or point me to a good tutorial/book. Thanks

Sorry the code is : awk -F "," '{gsub("\r",""); print $0 >> output}' input I was missing a semi colon

Thanks for replying The \r carriage return character is after the addres string in the sample data. It is hard to represent this on the web page. When I open the text in excel there are two square boxes. I have got the integer value of these character and it relates to \r. the code is awk...

Hi, I have a file that contains a set of fields. The fields are enclosed with quotes ("") and separated by a comma. The problem is that one of the fields is an address field that contains carriage return characters. AWK treats this as a new line. Any ideas how to handle this. I have tried...

Hi synapsevampire, Thanks for your help. The version of mysql that we are using also dosent support Views. Anyway the sql is working. One more question. When you add the params what syntax do you use. Is if @param or do you use the {&param} syntax used in crystal Thanks

Hi synapsevampire, I cant use stored procedure because the version of mysql dose not support it. could you tell me how to use Add Command. I have looked around and cant find this feature/button. I am new to crystal reports Thanks

Hi lbass, I managed to make it work in a way but not sure the right one. I have two running totals per each group and I calculate the the percentage of each group based on these two variable (one increments if it process passes, the other counts the number of records in that group). This is...

Hi lbass, I managed to make it work in a way but not sure the right one. I have two running totals per each group and I calculate the the percentage of each group based on these two variable (one increments if it process passes, the other counts the number of records in that group). This is...

Hi, We have Five table: tblPlant tblLine, tblproduct, tblProcessStep , tblMoveHistory The relation between the table are tblPlant -tblLine : 1 -* tblLine - tblproduct *-* tblline - tblProcessStep 1 - * tblMoveHistory contains the productID, stepID and lineID, moveTime and the result (which...

Hi Ilbass, thanks for your reply. I want to make things little more clear:I am using Crystall reports 9 with mysql (this may have no importance.). I did try what u suggested, even I started with the run total but I coulnd't manage yet either way. With the fo If I choose "Show as a percentage of...

Using crystal report 9 I have a number of tables e.g. ( factory table, line table, product table, steps table, history). I want to find the percentage of the total number of steps and the total number of passed steps in each group. (I have to group on several; factoryID, lineID, productID...