Tool Required to Convert

  • Thread starter Thread starter subha
  • Start date Start date
S

subha

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 (e-mail address removed)
--->[email protected] 05/12/2006 18:25:43 Local


Output should be:


xyz (e-mail address removed) 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
 
How many fields and what are the names that has this data?
Is it something like this ---
ID E-mail1 E-mail2 MyDate
MyTime TypeTime
xyz (e-mail address removed) (e-mail address removed) 05/12/2006 18:25:43 Local
 
its something like

First Name1 Last Name E-mail1
--->E-mail2 Date Time TypeTime
First Name2 Last Name E-mail1
--->E-mail2 Date Time TypeTime


Above this has some unwanted space and symbol like ---> and it has to
be in one line
Output should be:

Name1 E-Mail1 Date Time TypeTime
Name2 E-Mail1 Date Time TypeTime

Data Altogether has some 1000+data
 
Back
Top