You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

String function to hide text after a character

Accepted answer
17
Views
4
Comments
edited Nov 20, 2017 7:47AM in Reporting & Analytics for B2C Service 4 comments

Content

Hi all.

Can anyone suggest a string function that will hide part of a string after a certain character? For example:

  • Replace this:  What I need to see - what I don't want to see in this report
  • With this: What I need to see

NB: The number of characters before the "-" is dependent on user, so substr(str, start_pos, [length]) is usable, but not ideal.

Thanks in advance. 

Cheers, Lisa

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!