Kuroshi Posted November 30, 2020 Report Share Posted November 30, 2020 Hi, I am trying to concatenate my two number fields with a string and it is giving me different result. Field A value: 201479652315 Field B value: 201454784878 Here's what I'm trying to do: Field A + Field B + '.docx' And I am getting dis result: 201479652315 2.014547e+4878.docx Here's the formula i am using: CAST([@field:FieldA] as VARCHAR) + CAST([@field:FieldB] as VARCHAR) + '.docx' Can you help? Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted November 30, 2020 Report Share Posted November 30, 2020 Hello @Batchini, If it is on the Table level, can you try to use the formula below for converting a number to a string instead?: LTRIM(STR([@field:FieldA], 25, 0)) + LTRIM(STR([@field:FieldB], 25, 0)) + '.docx' It seems like the main reason why it is displaying the incorrect result is that the value you're trying to convert exceeds the max size value. I hope this helps. - Barbie Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted January 1, 2021 Report Share Posted January 1, 2021 In addition, you can refer to this article for more informtion about formula: https://howto.caspio.com/function-reference/ - Barbie Quote Link to comment Share on other sites More sharing options...
Question
Kuroshi
Hi,
I am trying to concatenate my two number fields with a string and it is giving me different result.
Field A value: 201479652315
Field B value: 201454784878
Here's what I'm trying to do:
Field A + Field B + '.docx'
And I am getting dis result: 201479652315 2.014547e+4878.docx
Here's the formula i am using:
CAST([@field:FieldA] as VARCHAR) + CAST([@field:FieldB] as VARCHAR) + '.docx'
Can you help?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.