How to convert Text that contains two numbers To Two different Numbers

[VNSL]

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

 

[jrprajapati]

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

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.

 

[VNSL]

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.

 

[VNSL]

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.

It's working Perfect Thanks!!

 

[jrprajapati]

It's working Perfect Thanks!!

Np.
Hope you can like my solution.