Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Is there a general rule to specify what part of all strings should be removed?
You can use multiple such functions like, Subfield, String functions.