This topic contains 4 replies, has 0 voices, and was last updated by torin@aminian.com 7 years, 11 months ago.

  • Author
    Posts
  • #23026

    JKB1497

    When I run a saved meeting search and view the results it looks perfectly fine. However, when I export the data in ANY format, it contains junk characters. What's up?
    This is a cached copy. Click here to see the original post.

  • #23027

    JKB1497
  • #23028

    torin@aminian.com

    I think I may know the work around to this issue. It looks like the message field is the one that is having these unwanted characters. Try fixing this by going into the results tab and using a formula for this column: REGEXP_REPLACE({messages.message},'<[^<>]*>',''). Make sure to choose the correct internal ID for message.

    Check out Suite Answer 34378 if you'd like more info on this fix. Let me know if this works.

  • #23029

    JKB1497

    Got it! Thanks!!

  • #23030

    torin@aminian.com

    When you choose the formula on the results tab, go to the formula column and click the arrow to the right and a pop up window will show. In this box there will be a field drop down. In this drop down find 'message' and select it. The id that shows up should be the one to use (replace message.message with this id). Let me know if this makes sense.

You must be logged in to reply to this topic.