[JKB1497 Contributions: 0Level 1☆]

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.

[JKB1497 Contributions: 0Level 1☆]

[torin@aminian.com Contributions: 0Level 1☆]

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.

[JKB1497 Contributions: 0Level 1☆]

Got it! Thanks!!

[torin@aminian.com Contributions: 0Level 1☆]

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.

[Author]

Posts