7 Replies Latest reply: May 15, 2014 10:13 AM by demi _ RSS

    calculated field ?   (monarch pro 9)

    demi _

      Hi,

        I have a field called "SURHARGE" with contains the following 9 examples listed below.

        Once again, I trying to remove unwanted characters. Each of the examples

        represents 1 record (therefore I have 9 records).

        If calculated field is the way to go, then is there a way to have one calulated field to

        remove all unwanted characters without creating multiple calculated fileds.

        How would I  resolve this?  All assistance is appreciated.

      SURCHARGE[/U]

      CVA=$  |    25        (unwanted character "|")

      CVA=$  |  325        (unwanted character "|")

      DNA=$  |    25       (unwanted character "|")

      -


                (unwanted character "-". if first column ="-" then replace 

                                     everything with blanks)

      MWA=$  |   25       (unwanted character "|")     

      CVA=$  | 1000      (unwanted character "|")

      (433)  |______      (unwanted characters everything. if first column ="(" then replace 

                                     everything with blanks)     |

             |                    (unwanted character "|"   then replace with blanks)    

      (48)  |______        (unwanted characters everything. if first column ="(" then replace 

                                     everything with blanks)    

       

      Thank You

      Demi

        • calculated field ?   (monarch pro 9)
          Olly Bond

          Hello Demi,

           

          It sounds to me that you should be doing this in the report window using a trap and a template, rather than trying to build a calculated field in the table window.

           

          If you email me your report file I'll send you a model to get you started.

           

          Best wishes,

           

          Olly

          • calculated field ?   (monarch pro 9)
            demi _

            I'm a beginner. I'll be more than glad to send a sample of the report and the models I created. But, how do I do this within this site.  I don't see an attachment feature.

             

            Demi  

             

             

             

             

            Hi,

              I have a field called "SURHARGE" with contains the following 9 examples listed below.

              Once again, I trying to remove unwanted characters. Each of the examples

              represents 1 record (therefore I have 9 records).

              If calculated field is the way to go, then is there a way to have one calulated field to

              remove all unwanted characters without creating multiple calculated fileds.

              How would I  resolve this?  All assistance is appreciated.

            SURCHARGE[/U]

            CVA=$  |    25        (unwanted character "|")

            CVA=$  |  325        (unwanted character "|")

            DNA=$  |    25       (unwanted character "|")

            -


                      (unwanted character "-". if first column ="-" then replace 

                                           everything with blanks)

            MWA=$  |   25       (unwanted character "|")     

            CVA=$  | 1000      (unwanted character "|")

            (433)  |______      (unwanted characters everything. if first column ="(" then replace 

                                           everything with blanks)     |

                   |                    (unwanted character "|"   then replace with blanks)    

            (48)  |______        (unwanted characters everything. if first column ="(" then replace 

                                           everything with blanks)    

             

            Thank You

            Demi[/QUOTE]