I have a data item as text and contains two numbers between coma. I want to split them into two different numbers and add them How can I do this. Thanks
Thanks I will Try.You can get the index of comma using Instr command.
Then use "Len" function to get the total length of the string.
After that, use Right and Left function to get the number in the left and right side of the comma and save them in different Number data type.
Thanks I will Try.
It's working Perfect Thanks!!You can get the index of comma using Instr command.
Then use "Len" function to get the total length of the string.
After that, use Right and Left function to get the number in the left and right side of the comma and save them in different Number data type.