What are "formula characters" and where would I see them?

MWBusch

What are "formula characters" and where would I see them?

In the post below, it mentions "...formula characters are prefixed with the escape character...".  

https://docs.oracle.com/en/cloud/saas/otbi/otbi-notable/index.html#GUID-69D70740-2CFC-44C5-B595-6B5C1086F27C

Thanks!

Mark

Nathan CCC

In 24A and later releases, when you export analyses results to a CSV or tab delimited file, Microsoft Excel treats the data in the exported CSV file as text. The formula characters are prefixed with the escape character (which is the apostrophe (‘)). If you don’t want to export data to CSV or tab delimited files as text, you as the administrator can disable the Export Data to CSV Files as Text property in the administration page for analyses and dashboards. If your current system processes CSV or tab delimited files, Oracle recommends you to review workflows and update logic to handle the apostrophe (‘) escape character prefixed to formula characters in the files exported in the text format.

MWBusch

@Nathan CCC Thanks, Nathan. But what I was looking for was a definition of the term 'formula characters' and an example or two showing where and how these might appear in the exported results of an analysis or dashboard.