Need help to remove punctuation

Hi All. I need help to remove the sign '-' but only from places where it isn't a part of a number sign. Below is the input and output. Please let me know if anyone can help.

Input:

Data
-120
-159
-
-
180
-
-
-
-

Output

Data

-120

-159

180

Accepted answers

All comments

atcodedog05

Hi @SCK

You can use filter tool to filter out '-'

Data does not equal to '-'

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

filter.yxmd

Qiu

@SCK
use Equal as the criteria to filter.

Qiu

@atcodedog05
you are fast...😁

SCK

Apologies here goes the revised data.

Input:

Data	Data
-120	790
-159	-95
-	90
-	175
180	-
-	50
-	-
-	-60
-	-40

Output

Data	Data
-120	790
-159	-95
	90
	175
180
	50
	-60
	-40

atcodedog05

Hi @SCK

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Here you go

You can also do this through a single Multi-Field Formula tool using a REGEX_Replace formula (the "-$" finds a dash with nothing after it)

Regex Replace.jpg

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335