Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

how to remove text encoding using Transformer

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to remove text encoding using Transformer

    Hi, I am new to Mirth and everytime i find new impressive feature.
    I am reading MS SQL server table (Source), coverting source XML into human readble text file using tranformer(Database to filewriter).
    My problem is that the database contains a column with text having RTF file encoding. I want to get rid of this encoding using transformer.

    Exmaple:
    Colum value:
    <reporttext>
    {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl {\f0\fnil\fcharset0 MS Sans Serif;}}
    \viewkind4\uc1\pard\f0\fs24
    \par
    Liver is normal in size, shape and echotexture. No focal lesion seen in liver. Intrahepatic ducts are not dilated. Portal vein appears normal and measures 1.2cm.
    \par Gall bladder is normally distended and shows normal wall thickness. No calculus or pericholecystic fluid seen. CBD appears normal and measures 0.5cm.
    \par Both kidneys are normal in size, shape and echotexture.}
    </reporttext>

    Required format:
    <reporttext>
    Liver is normal in size, shape and echotexture. No focal lesion seen in liver. Intrahepatic ducts are not dilated. Portal vein appears normal and measures 1.2cm.
    Gall bladder is normally distended and shows normal wall thickness. No calculus or pericholecystic fluid seen. CBD appears normal and measures 0.5cm.
    Both kidneys are normal in size, shape and echotexture.
    </reporttext>

  • #2
    Re:how to remove text encoding using Transformer

    Do they all contain the same or similar text as above? If so it can be stripped out with some regular expressions. Let me know if they are and I'll post a regex for you.

    Comment


    • #3
      Re:how to remove text encoding using Transformer

      yes every messeg has the same text. with "\par" for new paragraph and with closing bracket "}". Please help.

      Comment


      • #4
        Re:how to remove text encoding using Transformer

        can you post your channel for me so I can see how you are looping the data and such? That would speed up the process of getting you something usable.

        Comment

        Working...
        X