Replace empty split output with "N/A"

(0) Share

Report

Posted on by jfish303

Is there is easy way to replace the blank output of a split operate with different text.

For example "ERT Units" is ' ' than insert text "N/A"

I have the same question (0)

All responses (8)

Answers (1)

schwibach Moderator on at

Like (0)

Report

Re: Replace empty split output with "N/A"

sure... use the expression replace('youroldtextgoeshere',' ','N/A')

Was this reply helpful? Yes No
jfish303 29 on at

Like (0)

Report

Re: Replace empty split output with "N/A"

That makes sense but I only want to do that on the output of the compose function "ERT_Units' not on the complete email output

so replace('ERT_Units','','N/A')

Would that work?

Sorry I am super new to this

Was this reply helpful? Yes No
schwibach Moderator on at

Like (0)

Report

Re: Replace empty split output with "N/A"

replace(outputs('ERT_Units'),'','N/A')

This: outputs('ERT_Units') inside an expression will reference a compose action namen ERT Units (The space becomes an underscore

Was this reply helpful? Yes No
jfish303 29 on at

Like (0)

Report

Re: Replace empty split output with "N/A"

Okay

I am getting closer. Here is my expression

replace(outputs('ERT_Units'),'','N/A')

The replace is just blank. The raw output of ERT Units is "".

Any thoughts?

Was this reply helpful? Yes No
schwibach Moderator on at

Like (0)

Report

Re: Replace empty split output with "N/A"

well, you need to get your dynamic input into the compose action named ERT Units and the expression in another Compose action.

I don't know where the content is coming from in your flow so I cannot give you the entire code now.

Was this reply helpful? Yes No
jfish303 29 on at

Like (0)

Report

Re: Replace empty split output with "N/A"

I'll have to work on this.

One last question

Is it possible to do something like

replace(output(ERT_#),'EOJ',(ERT_Units),'N/A'0

Was this reply helpful? Yes No
Verified answer

schwibach Moderator on at

Like (0)

Report

Re: Replace empty split output with "N/A"

Sure, you can use nested expressions..

I suggest you get the first one to work in a compose action,
then you do the next part in the second compose action.
Once that is working you can replace the reference in the second action with the code from the first.

But really, take it one step at a time.

Was this reply helpful? Yes No
jfish303 29 on at

Like (0)

Report

Re: Replace empty split output with "N/A"

Okay I will keep working on this. I have EOJ converted to NA. Now I just need to move it from one place to the other. Thanks for your help

Was this reply helpful? Yes No