09-10-2010, 12:53 PM
findrx
|
09-10-2010, 01:08 PM
09-10-2010, 01:12 PM
yes as usual they have "," but its perfect that it works with each amount now
thank you very much best regards
09-10-2010, 01:14 PM
that was faster then i was able to post a thank you
so thanks again
09-11-2010, 05:06 PM
Gintaras Wrote:Yes, if price always be with ",". would it be possible to remove all exsisting "," and the ".00" in the same line ? in the code above it would out 937000 i think it needs another replacerx line and thats no problem so far but i cant get the removing of ".00" to work so my best result is 937000.00 thank you
09-11-2010, 05:13 PM
09-11-2010, 05:23 PM
oh wow i didnt know of _s.end
i searched in the help just now and still cant find anything about it !? or am i blind? thanks a lot for all ur help best regards
09-11-2010, 05:37 PM
Ok that works great but i ran into the next problem
Its not always ".00" at the end as it can be ".11" or something else too I have noticed that i have to learn about Regular expressions coz i hate asking u about things that probably well explained in the help Sorry
09-11-2010, 05:44 PM
_s=val(_s)
If need to round up if > .5, use this instead: _s=Round(val(_s 2))
09-11-2010, 05:50 PM
09-11-2010, 05:52 PM
ops we wrote the post at the same time
ill try ur way now thx
09-11-2010, 05:56 PM
Thank you very much it works perfect with _s=val(_s)
have a nice weekend |
« Next Oldest | Next Newest »
|
Users browsing this thread: 1 Guest(s)