Make a string type appear as a monetary number without changing datatype

Gina2021

Hello Community!

This is my first time uploading a workflow question; so please lmk if I could do it better.

Example: column YTD contains string values of 1982577, 886172, 11% that I'm trying to make appear as $1,982,577, $886,172, 11%. I'll need to convert columns 1-11 like this as well.

I've been trying out combinations of Right() and RegEx, but need to learn these skills. Any advice?

Thanks so much for your help!

Gina

HELPregex.yxmd

Regex

Parse

Accepted answers

L_T

@Gina2021,

I have slightly modified the formula in the attached - let me know if this works!

HELPregex.yxmd

T_Willins

Hi @Gina2021,

The issue with the Nulls is your sample data has the null cells as text [NULL] and are not truly null values. If this is consistent with your actual data set, you can update the Multi-Field tool formula to:

IF IsNull([_CurrentField_]) OR [_CurrentField_] = "[Null]" THEN "" ELSEIF Contains(ToString([_CurrentField_]),"%") THEN [_CurrentField_] ELSE "$"+ToString(ToNumber([_CurrentField_]),0,1) ENDIF

All comments

L_T

Hi Gina,

could you please have a look at the attached workflow?

HELPregex.yxmd

Gina2021

Thanks so much, @L_T ! It is soooo close! I've tried playing with it to keep the [Null] rows [Null] instead of changing them to $0, but just made it worse. Do you have any tweak ideas by chance? Thanks again for your help!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335