Remove periods and replace with nulls

[hudg16]

Hopefully a softball for you guys 

ECF_AMT

.

.

128.13

Null values are currently periods. How can I make these actually null without losing the decimal in my not null records?
cheers

[JagdeeshN · Accepted solution]

Hi @hudg16 ,

Please find attached a sample workflow that does this.

The workflow uses the below formula to achieve what you have described:-

if Length([ECF_AMT])=1 and [ECF_AMT]='.' then null()
else [ECF_AMT]
endif

Do let me know if this resolves your query.

Best,

Jagdeesh Narayanan

[hudg16]

@JagdeeshN 

I do not seem to have the same luck (disregard subsidy). I made sure the string type was exactly the same, any ideas?

[JagdeeshN]

Hi @hudg16 ,

Can you please share a sample workflow of what you have developed?

Best,

Jagdeesh

[christine_assaad]

Hi @hudg16 

It seems that your data has trailing spaces. Could you please try the below? You can then use Select to make sure everything is coming thru as number. Hope it helps. Cheers!

[hudg16]

@christine_assaad 
Duh !! thanks!