Skip to main content
Solved

Hi, I'm trying to use the attribute manager to replace all instances of double quote marks " with single quote marks ' for the values of the attribute 'testo' @ReplaceRegularExpression(@Value(testo),",') I can replace letters ok, but not quotes.

  • December 20, 2022
  • 5 replies
  • 248 views

Hi, I'm trying to use the attribute manager to replace all instances of double quote marks " with single quote marks ' for the values of the attribute 'testo' @ReplaceRegularExpression(@Value(testo),",') I can replace letters ok, but not quotes.

Best answer by nielsgerrits

This works for me, in fme 2021.2:

@ReplaceString(@Value(testo),"\"",',caseSensitive=TRUE)

Please note that the field Attribute Value in the AttributeManager turns red, indicating something is off, but it does work fine.

2022-12-20_14h35_47

View original
Did this help you find an answer to your question?

5 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • December 20, 2022

This works for me, in fme 2021.2:

@ReplaceString(@Value(testo),"\"",',caseSensitive=TRUE)

Please note that the field Attribute Value in the AttributeManager turns red, indicating something is off, but it does work fine.

2022-12-20_14h35_47


dustin
Influencer
Forum|alt.badge.img+30
  • Influencer
  • December 20, 2022
nielsgerrits wrote:

This works for me, in fme 2021.2:

@ReplaceString(@Value(testo),"\"",',caseSensitive=TRUE)

Please note that the field Attribute Value in the AttributeManager turns red, indicating something is off, but it does work fine.

2022-12-20_14h35_47

@nielsgerrits​ Just curious, does 2021.2 make the attribute value parameter red with this input? It works in 2022.1 also, but it's red.image


nielsgerrits
VIP
Forum|alt.badge.img+54
dustin wrote:

@nielsgerrits​ Just curious, does 2021.2 make the attribute value parameter red with this input? It works in 2022.1 also, but it's red.image

Aye, it does. Looks like a glitch to me in the value validation. I'll create a ticket.


  • Author
  • December 20, 2022

@nielsgerrits​ thank you so much. i was trying so many different things. i don't think the red flagged parameter was helping my attempts because i was just modifying it each time i saw that.


danminneyatsaf
Safer
Forum|alt.badge.img+12
dustin wrote:

@nielsgerrits​ Just curious, does 2021.2 make the attribute value parameter red with this input? It works in 2022.1 also, but it's red.image

Looks like this is related to the quote (") character being present within a formula. This doesn't have an effect on the functionality of the workspace but we will try to resolve this as soon as possible. The ticket number for this is FMEDESKTOP-13584.

We will update this community post when a fix is released. Thanks all!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings