Remove Special Character from returned SQL data field

[MG_Metro]

when I got my data fetched from SQL db, one of the field contains some special character and ruining my automation, I try to filter it, but the append to string is not excepting the expiration I'm putting there, Idk how to do this, please advice.

this field contains invalid character, and I had used the expression as below

and the expression is replace(items('Apply_to_each_3')?['value']?['ParameterValue'],'"','') 

but it's giving me error, please help, thanks. 

[DamoBird365]

Hi @MG_Metro 

What's the error?

Could the correct expression be replace(item()?['value']?['ParameterValue'],'"','')

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[MG_Metro]

Oh, sorry forgot to include the error, here is it

[DamoBird365]

@MG_Metro 

Your screenshot suggests that your original expression evaluates to null. Can you try the amended expression I supplied above?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[MG_Metro]

tried to update it, but still same error, thx

[DamoBird365 · Accepted solution]

Hi @MG_Metro 

quite simply item()?['value']?['ParameterValue'] doesn’t exist. Are you able to look at the history output for the fetch sql action and copy the json here? It will help construct an expression for the value you are looking for.

last guess:

item()?['ParameterValue']

then a copy of your json and I’ll try to help.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[MG_Metro]

as you seen on first image, if I just put the SQL item, it works, but the double quote on the table value is breaking the script. 

[DamoBird365]

If you hover your mouse over the dynamic value ParameterValue, you will see the expression and then you can copy this into the replace expression. The other way to see the expression is to click on the ellipses of the append to variable action and inspect code. This will help you see the correct expression for ParameterValue.

[MG_Metro]

oh, thx for that info, I see, really useful, looks like the last expression works, let me try with the problematic one, and update you soon.