Need help to remove punctuation

[SCK]

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

[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 😀👍

[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 😀👍

[Qiu]

@SCK 

Here you go

[atcodedog05]

Hi @SCK 

You can have dynamic remove null rows. But that feature only available in the latest releases. So check whether is works.

Hope this helps 🙂

[T_Willins]

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)