text to number format or preceeding 0

I need text to number format preceeding with zeros or text to be right
justified or preceed with zeros. I am importing a raw txt file into a dbase
but there is one field I need changed to right justified. After I make a few
other changes I need to export back to a TXT file with the following change.

Example A. # or txt 1 changed to 0001
EXample B. #1 right justified

I actually need to convert this TXT record ,
001|12|0007154700100|1|0007154700100|3.0|JL SLINKY-BOXED|
To this TXT record
001120007154700100 100071547001003.0 JL SLINKY-BOXED

Hope someone understands this mess I tried to explain
Thanks

.

Relevant Pages

  • Re: Import number data with leading zeros as text without losing l
    ... Sorry I was not more clear- basically - I have 70 tables- all identically set ... types are TEXT then the leading zeros are stripped off. ... me are ignored when importing text, I tried csv, setting minimim data lengths ... right data type than an arbitray strip of the leding zeros. ...
    (microsoft.public.access.externaldata)
  • Re: text to number format or preceeding 0
    ... justified or preceed with zeros. ... I am importing a raw txt file into a dbase ...
    (microsoft.public.access.queries)
  • RE: Importing Text File
    ... I download the data from a mainframe, changing the format to a text format. ... Importing the data worked great using Access v2.0, ... >> When I import a text file some of the fields with zeros do not import. ...
    (microsoft.public.access.externaldata)
  • RE: Importing Text File
    ... file, but Excel, for example, has a habit you have to check for. ... > I download the data from a mainframe, changing the format to a text format. ... > Importing the data worked great using Access v2.0, ... >>> When I import a text file some of the fields with zeros do not import. ...
    (microsoft.public.access.externaldata)
  • Re: importing data from Excel
    ... The only other side I can imagine is the Excel side. ... >I am importing data from Excel and even if I change the datatype in Excel ... > the leading zeros off the data which I need. ... > Excel spreadsheet that is created automatically by a download process from ...
    (microsoft.public.access.tablesdbdesign)