Question

Extracting a string value after a specific character

  • 25 April 2024
  • 2 replies
  • 27 views

Userlevel 1
Badge +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

Userlevel 3
Badge +8

Hi @Ash1807 please try this,

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

Thanks,

Jamie

Userlevel 1
Badge +4

Hey Jamie,

Worked a treat. Thank you so much!

/ash

Reply