Quickly Remove Dashes From Fields

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I want to remove the hyphens with a formula . Can you please tell me how this can be done?

0-54642-00104-8

https://www.screencast.com/t/kGSX4UpVdcGd
Photo of Sam Krausz

Sam Krausz

  • 470 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
List("",
Part([UPC],1,"-"),
Part([UPC],2,"-"),
Part([UPC],3,"-"),
Part([UPC],4,"-"),
Part([UPC],5,"-"))

You do as many PARTS as you think there could possibly be hyphens.   Extra PARTS won't hurt.
Photo of Sam Krausz

Sam Krausz

  • 470 Points 250 badge 2x thumb
Thanks Mark 

You are so good, I wish I have your knowledge