Skip to main content
Question

Extracting a string value after a specific character

A
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Ash1807
  • Do Gooder (Customer)
  • 3 replies

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
  • COVJAMIEB
  • Hero (Partner)
  • 202 replies
  • April 25, 2024

Hi @Ash1807 please try this,

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

Thanks,

Jamie

Opinions are my own and not the views of my employer or IFS. Feel free to connect with me - https://www.linkedin.com/in/jamie-baird-29615591/
A
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Ash1807
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • April 29, 2024

Hey Jamie,

Worked a treat. Thank you so much!

/ash

Reply


Terms & ConditionsCookie settings

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