Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

How to handle string field containing HTML code and quotes


Alejandro Osorio

Recommended Posts

I'm trying to generate csv filein which one of the columns contains html code and quotes. After generating the file, format is wrong andI see more columns than the expected. Is there a way to handle HTML as text and scape html entities. So far I could not find a function / connector to achive this.

Thanks,

Alejandro.

Link to comment
Share on other sites

  • 2 weeks later...

HiAlejandro,

Assuming you are using Scribe Online Classic or TCI Connect with a target text connector to generate your csv files for your use case:

 

- Have you tried the Replace() function or Strip() scribe formula / function to remove ascii control characters or extended characters to remove any possible CRLF(CRand/or LF)ascii characters which could make it difficult to parse/read the csv text formatted line and fileas intended.

- Also using the csv-delimiter with quotation ","or use an alternative delimiter character:

See text qualifier setting here : https://help.scribesoft.com/scribe/en/index.htm#sol/conn/text_target_ent...

 

Also make sure other settings are correct such as file encoding matching the data encoding in the html content.

 

I would try with a small example with one record first to see how it works before sending more bigger volume of data thru.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...