Clean up Double Field

Are you able to suggest screenshots at all? If you just need to remove all of your '-' which sounds like it might be the case, then a simple Replace or ReplaceChar function should work.

Something like Replace([yourfieldhere], '-','')

where your third parameter has nothing in quotes, essentially saying taking every instance of a - and replace it with nothing.

Edit: I for some reason was imagining these '-' to be in the middle of numbers as separators and not negative values. I'm now assuming they're just negative values but are you able to confirm which it is?

ZoeM

Screen shot attached. Id assume it was from the source?

I tried the replace and it was throwing an error, I assume because this is a Double field?

character issue.JPG

binu_acs

@ZoeM Can you provide a sample amount field?

ZoeM

Attached a similar workflow

Sample Double Field workflow.yxmd

binu_acs

@ZoeM updated workflow attached

Screenshot 2023-07-19 222012.png

Sample Double Field workflow.yxmd

ZoeM

Your solution works. What about after the select tool? When the field is a double?

So then I need to change the field type first to get it to work.

We really cant do any data cleansing on a Double field type?

binu_acs

@ZoeM Your "Value" field is a string type even after I applied the Regex formula the type did not change, only the formula removes the unwanted field but the fields type still string, and you should use the select tool to change it into double

Screenshot 2023-07-19 224009.png

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335