Text Formatting Issue

Status: Closed · Asked by mikec29526 on · 0 views

mikec29526 — Question ·

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 — Reply ·

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.

Back to all forum threads · Log in to reply