Skip to main content
Topics#TestTableau Community Forums Member (Inactive) 的问题
Tableau Community Forums Member (Inactive) (Salesforce) 提问于 #Test
2023年9月7日 16:15

How can I replace a backslash-n in a string?

I have a string that looks like this: #TEST\n\nPost

 

I'm using this regexp:

if regexp_match([Hashtags], "\\n.*") then regexp_replace([Hashtag], "\\n.*", "")

 

What I'm trying to get is #TEST, but when I use the above, it returns the original string instead.

8 个回答
  1. Don Wise
    2023年9月7日 16:23

    You could try:

    IF REGEXP_MATCH([Data],'(#)')
    THEN REGEXP_EXTRACT([Data],'(#\w+)') END

     

    You could try:IF REGEXP_MATCH([Data],'(#)')THEN REGEXP_EXTRACT([Data],'(#\w+)') END Best, Don(Please, don't forget to click Select as Best or Upvote !)

     

    Best, Don

    (Please, don't forget to click Select as Best or Upvote !)

撰写回答...
0/9000