Hi all - has anyone worked through a saved search ...
# generala
Andrew C
06/13/2022, 4:29 PMHi all - has anyone worked through a saved search formula that LPADs a number based on the first character being a decimal?
e.g. if result of saved search is .25 --> 0.25.
m
michoel
06/13/2022, 11:58 PMTO_CHAR({field}, 'FM999999999999990.00')a
Andrew C
06/14/2022, 12:28 PMIs there any way that you know of to get rid of the common? e.g. 1,000 without having to use Formula(Text) because FM turns 1,000 --> 1000.
Andrew C
06/14/2022, 12:32 PM1,000 and 1000. are both invalid JSON
m
michoel
06/14/2022, 12:36 PMDid you test this? I'm using it in a script that generates JSON payloads and pretty sure it handles all the scenarios I've thrown at it.
a
Andrew C
06/14/2022, 12:38 PMYeah, I have to use some handlebar templating (e.g. toFixed numberField 2).
Andrew C
06/14/2022, 12:39 PMThis is specifically when I have to send the JSON as an int field to the destination app.
Andrew C
06/14/2022, 12:39 PM.0 is invalid json but ".0" is valid
Andrew C
06/14/2022, 12:40 PMBut I got it to work, and am using fill mode in saved search now. Thanks!
3 Views