Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Tool required to convert

Discussion in 'Information Technology' started by subha, Jul 28, 2006.

  1. subha

    subha
    Expand Collapse
    Guest

    Hi ,

    Can Someone help me out to Create a tool in Access which Converts
    Unaligned data to aligned data in Access.

    example of unaligned data:

    xyz xyz@something.com
    --->xyz@something.com 05/12/2006 18:25:43 Local

    Output should be:

    xyz xyz@something.com 05/12/2006 18:25:43


    file consist of lotsa data and which are not in order, please do help
    me to get above output in Access.

    thanks in advance,
    subha
     
  2. Loading...

    Similar Threads Forum Date
    Legal Boundless Informant: the NSA's secret tool to track global surveillance data Breaking News Jun 9, 2013
    World The Powers of Manipulation: Islam as a Geopolitical Tool to Control the Middle East Breaking News Jul 2, 2011
    SciTech Tools Suggest Earlier Human Exit From Africa Breaking News Jan 30, 2011
    Politics Dictators, Web Tools, and Change Breaking News Jan 30, 2011
    Is SRM a Rule Book or Tool Book? Questions and Answers Nov 3, 2010

  3. Mr B

    Mr B
    Expand Collapse
    Guest

    What format is the data in now? Is it a delimited text file or what?
    --
    HTH

    Mr B


    "subha" wrote:

    > Hi ,
    >
    > Can Someone help me out to Create a tool in Access which Converts
    > Unaligned data to aligned data in Access.
    >
    > example of unaligned data:
    >
    > xyz xyz@something.com
    > --->xyz@something.com 05/12/2006 18:25:43 Local
    >
    > Output should be:
    >
    > xyz xyz@something.com 05/12/2006 18:25:43
    >
    >
    > file consist of lotsa data and which are not in order, please do help
    > me to get above output in Access.
    >
    > thanks in advance,
    > subha
    >
    >
     
  4. subha

    subha
    Expand Collapse
    Guest

    Its a text file, even if i try to delimit it in Excel i am not getting
    it in one line.

    the input:
    xyz x...@something.com
    --->x...@something.com 05/12/2006 18:25:43 Local

    this input should come in one line like this

    xyz x...@something.com 05/12/2006 18:25:43

    thanks a lot for getting back to me, looking forward to hear from you
     

Share This Page