Skip to main content
Question

Extracting a string value after a specific character

  • Apr 25, 2024 1:36 PM UTC
  • 2 replies
  • 90 views

Forum|alt.badge.img+4

I have a Quick report that shows email addresses from a table view.  I would like to only list out the domain ie all characters after the “@” character.

Looked at TRIM, but that seem not to work

2 replies

COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • Apr 25, 2024 1:43 PM UTC

Hi @Ash1807 please try this,

SUBSTR(<ENTERFIELD>, INSTR(<ENTERFIELD>, '@') + 1)

Thanks,

Jamie


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • Apr 29, 2024 6:40 AM UTC

Hey Jamie,

Worked a treat. Thank you so much!

/ash