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

    Advice on XML + AWK

    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...
    • lookers
    • Thread
    • Replies: 1
    • Forum: AWK
  2. lookers

    Processing File with return character "\r" in field using AWK

    That's great. Your a legend
  3. lookers

    Processing File with return character "\r" in field using AWK

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

    Processing File with return character "\r" in field using AWK

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

    Processing File with return character "\r" in field using AWK

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

    Processing File with return character "\r" in field using AWK

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

    Processing File with return character "\r" in field using 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...
    • lookers
    • Thread
    • Replies: 9
    • Forum: AWK
  8. lookers

    multiple counts (different values) - subreports?

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

    multiple counts (different values) - subreports?

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

    multiple counts (different values) - subreports?

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

    multiple counts (different values) - subreports?

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

    multiple counts (different values) - subreports?

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

    multiple counts (different values) - subreports?

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

    multiple counts (different values) - subreports?

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

Part and Inventory Search

Back
Top