Text Formatting Issue

[mikec29526]

Hi,

I am wanting Pabbly to update a spreadsheet row with an amount, that should be 10.30
As you can see in workflow history ID IjU3NjIwNTY4MDYzNTA0MzU1MjZkNTUzMDUxMzQ1MTZiNTQzMiI_3D_pc
It is updating my google sheet with $10.30

I even did a text formatter to only use the part after $

That isn't working though. Any suggestions?

 

[Arshita]

Hey @mikec29526

As I can check from your workflow, I noticed that you've included the "Text Formatter by Pabbly: Text Parser" action step to remove the "$" from the amount. In this scenario, I recommend adding the "Text Formatter by Pabbly: Replace Text" action step and then retrying the process.