dcsimg

Search:

Type: Posts; User: LaVolpe

Search: Search took 0.04 seconds.

  1. Re: How to fast split Number integet part and decimal part ?

    Well, I'm not even sure a CSV is even required. The OP may have mentioned that and I missed it. What I did recall was that he was looking for 2 Longs from 1 Double. I'm not even sure he was...
  2. Re: How to fast split Number integet part and decimal part ?

    If you are going to save customized long values (including the DecLen part), why not use a simple UDT and LSET? I know I must be missing something in the problem you are addressing.

    For example:...
  3. Re: How to fast split Number integet part and decimal part ?

    I think the OP has "resolved" this thread but hasn't marked it resolved (see last post of previous page).

    But bottom line, the OP appears to be using doubles when currency is likely a better...
  4. Re: How to fast split Number integet part and decimal part ?

    @Olaf. Change Str$() to CStr$() and see a reduction in time from ~2.5 to ~1.6 seconds.
    Also, writing the UDT members in binary mode (Put vs Print), was actually slower. Just FYI

    As far as...
  5. Re: How to fast split Number integet part and decimal part ?

    This seems to be the problem if this text file is for your use. Why should the format of the data in the file matter? Save it as binary or as a UDT record. If this text file is for use in some other...
  6. Re: How to fast split Number integet part and decimal part ?

    Dex, sounds something like this:

    1. He has his own CStr() routine for Long to String that he says is 2x faster than CStr()

    2. Sounds like he is looking at a way to separate the numbers into...
  7. Re: How to fast split Number integet part and decimal part ?

    Good point. Int() can round up negative numbers. And type-casting will slow things down, no doubt.

    And as you said, we don't really know what the point is. Why the need to separate a fractional...
  8. Re: How to fast split Number integet part and decimal part ?

    You can test this if you like, it should be faster than converting with CDec. However, conversion to Double is used to handle wide range of values and string manipulation used to return unaltered...
Results 1 to 8 of 8



Featured


Click Here to Expand Forum to Full Width