01-02-2020 05:50 PM
hi guys i have a problem which i get a only 2 numbers after converting string to number
Solved! Go to Solution.
01-02-2020 06:16 PM
I don't understand how your subject line relates to the image you show.
You say the string contains two commas, but it looks like two periods. What is "55.16.1" supposed to mean?
The Time array shows them with a single comma.
Are you in a country that uses a comma as a decimal point? If so, read the detailed help of that function carefully. You might be better off using Scan From String which has more control in the format string on how to handle unusual decimal point requirements.
01-02-2020 06:32 PM
"55.16.1" its mean experience number 55 and 16,1 means time the probleme i can reached to second part, i just want to separate 55 and 16,1 ,sory for my bad englich
01-02-2020 06:56 PM - edited 01-02-2020 07:13 PM
If the problem is converting the string "12.34.56" into the number 34.56 then I'd suggest splitting your string at the first "." then converting the second part of the string.
There are numerous search functions that might be useful if you wished to do this in two steps, together with String Subset.
To do this in a single string operation and then the conversion, you could use something like a Regular Expression match and the submatch system.
01-02-2020 07:05 PM
You definitely should use the Scan From String. You could use "%.;%d.%f" for your format string to get your two values.
01-02-2020 07:23 PM
@AYM8NE wrote:
"55.16.1" its mean experience number 55 and 16,1 means time the probleme i can reached to second part, i just want to separate 55 and 16,1 ,sory for my bad englich
Even what you say here doesn't match what you have. "16.1" is in your string and you say it is "16,1". Be consistent in your description as to whether you have commas or periods!
What generated this string? Do you have control over it? If you want to separte 55 from 16.1, whatever created it should have been outputting 55,16.1 So that you have a comma to separate the values (otherwise know as CSV, comma separated value), and a decimal point used in 16.1.
01-02-2020 07:34 PM
THANKS A LOT THATS WORK FOR MY SITUATION
01-02-2020 08:44 PM
Check your CAPS LOCK key. It seems to be stuck on.