How to remove everything before Hyphen along with -

[danny4202001]

Hello Team,

Please let me know how to remove everything before - Hyphen along with hyphen bold in below 

92961-2011- KG 400 CUDDLEBED W/R-TECH STAIN TREATMENT

When I use this below script results seems right but Hyphen is still there

results ' - KG 400 CUDDLEBED W/R-TECH STAIN TREATMENT'

right(Filed, len(field)-Index(Field, ' '))

Thanks,

D

[kaushiknsolanki · Accepted solution]

Try this.

Mid('92961-2011- KG 400 CUDDLEBED W/R-TECH STAIN TREATMENT', Index('92961-2011- KG 400 CUDDLEBED W/R-TECH STAIN TREATMENT','-',2),Len('92961-2011- KG 400 CUDDLEBED W/R-TECH STAIN TREATMENT')-
Index('92961-2011- KG 400 CUDDLEBED W/R-TECH STAIN TREATMENT','-',2))

Replace Value in Quote with your Field Name

[MarcoWedel]

Is there a general rule to specify what part of all strings should be removed?

[kaushiknsolanki]

You can use multiple such functions like, Subfield, String functions.