ACC Expression Help - String after character

Avatar

Avatar

wesp27904446

Avatar

wesp27904446

wesp27904446

23-10-2019

Can anyone tell me the best way in the expression editor to capture the numbers after a specific character.  For example, if the values is 1234-5678.  I want to keep only the characters after the dash(5678).  I tried some of the built in functions but have not had any luck.  Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

23-10-2019

Hi,

Use these built-in functions:

Substring(@field, Charindex(@field, '-') + 1, Length(@field))

Thanks,

-Jon

Answers (1)

Answers (1)

Avatar

Avatar

wesp27904446

Avatar

wesp27904446

wesp27904446

23-10-2019

This worked perfectly, thank you.  My understanding of the way Substring worked was not correct.