Concat 1 letter in field

[tsoley9262]

I have a field sm-s-001 and I am trying to create an ID field with just the s in between the dashes any help would be appreciated!!

[sunny_talwar · Accepted solution]

Try this

TextBetween(FieldName, '-', '-') as ID

[tsoley9262]

Sunny Thank's that worked great!!