Re: Text import annoyance



Doug Kanter wrote:

> Hmm....I'd always checked string length with a CASE loop and padded
> accordingly. Never used the fill() function. Back to the books.

assume you want "00012345" from "12345"

[] = FILL("0",8-LEN([])) + []


--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox
---------------------------------------------------
Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Trading Cards and other Sports Memorabilia
---------------------------------------------------


.



Relevant Pages

  • Re: Sharing a 4.0 or 7 DB file
    ... then you must make sure the shared path to the data ... Diamond Software Group ... Paradox Support & Sales - Corel CTech Paradox ... Diamond Sports Gems ...
    (comp.databases.paradox)
  • Re: Number of Records
    ... > At 600,000 records is it time to move to an SQL backend and run these types ... Diamond Software Group ... Paradox Support & Sales - Corel CTech Paradox ... Diamond Sports Gems ...
    (comp.databases.paradox)
  • Re: Paradox.SOR
    ... then access should open *any* table w/o incident.. ... Diamond Software Group ... Paradox Support & Sales - Corel CTech Paradox ... Diamond Sports Gems ...
    (comp.databases.paradox)
  • Re: Lesspace not doing the trick
    ... everything is set to "Auto", except for Extended memory, which is set ... Diamond Software Group ... Paradox Support & Sales - Corel CTech Paradox ... Diamond Sports Gems ...
    (comp.databases.paradox)
  • Re: Testing for blank field in PdoxDOS?
    ... the large, blinking, red warning lights.. ... Diamond Software Group ... Paradox Support & Sales - Corel CTech Paradox ... Diamond Sports Gems ...
    (comp.databases.paradox)