"Replace" is not working?

Questions and Help
1

tb
tb880×403 42.2 KB

Hi, Im trying to replace all the numbers, "-" and spaces before a text (clipboard).
Examples:
(Input)
147-Matt Swift
203-Todd Markhan
241-Scott McClellaen

Output expected:
Matt Swift
Todd Markhan
Scott McClellaen

Actually results:
147-Matt Swift
203-Todd Markhan
241-Scott McClellaen

Formula I´m using: (Please look jpg
{=replace( {clipboard},"^\d+-\s*", "")}

Thank you very much

2

Hi Martin,

You will want to use a regular expression for that with the replaceregex function. Something like the following should work:

Input: {formtext: name=input; default=123-John Smith}
Cleaned: {= replaceregex(input, "^[\d-]+", "")}