I have string value input=“027” and need to subtract 1 from this input string. So output should come as 026.
I tried assign activity like below but output will come as 26 not like as we expected.
output=(interger.parse(input)-1).tostring
Thanks in advance…
You can convert the string datatype to integer by using CInt Function.
- Assign -> Input = "027"
- Assign -> Output = CInt(Input)-1
Hope it helps!!
input = "027"
output = (Integer.Parse(input) - 1).ToString("D3")
.ToString("D3") -->Converts the result back to a string and ensures it has three digits, adding leading zeros if necessary.
For more conversions, check this:
Hi,
You subtract 1 from a string like “027” using the method you’ve described, it first converts the string to an integer, subtracts 1, and then converts it back to a string. The conversion to an integer removes the leading zero, resulting in “26” instead of “026.”
you can use below expression:
(Int32.Parse(“027”) - 1).ToString(“D3”)
try this
output = If((Cint(input)-1).ToString.Count=2,"0","") + (Cint(input)-1).ToString
or use
Output = (Cint(input)-1).ToString.PadLeft(3, "0"c)
cheers
cheers
Thanks @mkankatala
I tired this way already but it will give only 26 not as we expected.
Okay @Mahesh_Bandi1
For that use can try in this way
- Assign -> Input = "027"
- Assign -> output = (CInt(Input)-1).toString("D3")
In this we mentioned the number of items we have. It will give the result as 026
Hope you understand!!
assign
strr=“027”
Assign
strr1=(CInt(strr)-1).ToString(“D3”)
(CInt(strr)-1).ToString("D3")
WORKS FINALLY… Double quotes I retyped then it works … 
I am very happy for all associate answers…Thanks a lot guys
Please close this topic by marking the appropriate post as solution @Mahesh_Bandi1
Cheers!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
jast1631
ashokkarale
Anil_G
lrtetala
Yoichi
SorenB
anjani_priya
ppr
Raj_esh
marina.dutta