1 Reply Latest reply: May 15, 2014 9:58 AM by Bruce _ RSS

    Original format of text is lost when converted to Memo

    kfschaefer _

      I am looking for the best approach to force my data to keep the existing format.  when I select my data for the memo field the existing format is lost - WHY?  I would like to keep this format due to easier to read.

       

      Incoming data:

      DEDUCTIBLE-                                   

         INDIVIDUAL-                                

           IN NETWORK: N/A                          

           OUT OF NETWORK: $250                     

         FAMILY: $750                                                                               

      COPAY-                                        

         IN NETWORK: $10                            

      OUT OF NETWORK: N/A                           

                                                      

      COINSURANCE-                                  

         IN NETWORK: PBC 100% of the allowed amount 

      MBR:  0% of the allowed amount                

         OUT OF NETWORK: PBC60% of the allowed amount

      MBR40% of the allowed amount                  

                                                      

      ANNUAL OUT OF POCKET: Does not apply to oop   

                                                      

      LIMITS: 12 visits per member per calendar year

       

      Outgoing Data:

       

      DEDUCTIBLE-    INDIVIDUAL-      IN NETWORK: N/A      OUT OF NETWORK: $250    FAMILY: $750   COPAY-    IN NETWORK: $10 OUT OF NETWORK: N/A  COINSURANCE-    IN NETWORK: PBC 100% of the allowed amount MBR:  0% of the allowed amount    OUT OF NETWORK: PBC60% of the allowed amount MBR40% of the allowed amount  ANNUAL OUT OF POCKET: Does not apply to oop  LIMITS: 12 visits per member per calendar year  ***QUOTE LANGUAGE-  Services must be medically necessaryto relieve pain, induce surgical anesthesia, or to treat a covered illness, injury or condition.

       

      How do I keep the spaces and line feeds as is?

       

      Karen

        • Original format of text is lost when converted to Memo
          Bruce _

          Karen

           

          Have you tried the textline function? This will return each line as required. I believe that the memo fields strips out charage returns & line feeds.

           

          Also you could try trapping out the fields normally, instead of a memo field. This way you could manipulate them (sorting, filtering etc)

           

          Let us know how you make out.

            smile.gif[/img]