Extract function removes some unicode

Hi all,

We are on 17.1 cloud installation. I observed one behavior with Exact function. I am not sure whether it's as designed. Following is the detail.

Text string: This is a text with & and some other stuff

Function implementation: extract(
"This is a text with & and some other stuff",
"with",
"some"
)

It returns result as, "& and" instead of "& and".

Is that expected?

Thanks!

  Discussion posts and replies are publicly visible

Parents
  • extract(
      "This is a text with & and some other stuff",
      "with",
      "some"
    )
    
    Returns: "& and" instead of "& and"

    Ummm. So, in the Text string, there is & amp ; instead of just &. That value is somehow removed because of the rich text display. I am adding Text file for the example.

  • Thanks ramanjaneyulut and amanit.

    So just to clarify, if there is an & (that is "&", "amp", and ";" together) in the text, if we use extract, it will change it to "&"?
  • It seems like it's doing HTML replacement. If you try:

     extract( "This is a text with < and some other stuff", "with", "some" )

    , you'll get

    < and

    .

Reply Children