Hey Team,
Is it possible that we can have an option to remove the formatting from Rich Text area fields(like Answer text which is a Survey field) such as carriage return? I ask this because tools such as Power BI are not very friendly while processing such Data- ultimately causing errors and requiring a manual change of all records which have the extra carriage returns in Text fields.
Hi
Do you mean to remove all the available formatting? This will remove bold, italics also along with image tags, carriage returns. Will this solve the problem here?
Also, is this only for S3 data export or are we looking to use this in actions (load to SFDC, MDA, call external API, etc.) as well
Hey
This is just with respect to S3 imports. The reason I ask for an extra option to remove formatting while exporting to S3 is that tools such as MS Excel( and also some ETL tools) tend to break the file( jumping data into other columns) when it encounters special characters( extra Double quotes, extra commas, HTML tags, etc).
Once we have the option of removing the formatting and just displaying plain text it avoids these kinds of issues. This could be an option just for Rich Text Area fields as we cannot apply formulas on them using rules.
Hey
We are considering this in the shorter term itself
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.