from a a mdb access database to a text file. The
access table had one column. The data in the text file
is also displayed in one column. I want to do
something to move the data horizontally. I know where
a new row should be starting. I'll give you an example
to better understand what I'm trying to do and
hopefully it will make sense.
The data in the text file looks like this:
10099
PS2/162
253
U
BAY19
SCAR
01/01/1980
0
43525
NCA150347
0
N
05/01/1993
24
Y
[EMAIL PROTECTED]
10098
EQ5/553
208
U
BAY19
SCAR
01/01/1980
0
43525
NCA150348
0
N
01/01/1980
12
[EMAIL PROTECTED]
The identifer separating one row from the other is
separtor "[EMAIL PROTECTED]". So I want to move everything after
"[EMAIL PROTECTED]" and before the next "[EMAIL PROTECTED]" into one row. In the
sample above you can see there are few rows that have
no data, I still want new columns to be created with
or without and data.
Can somebody please show me how to do this. I have to
first read the file with cffile, make the changes and
then write back the changes to the text file. I can't
tell you how thankful I will be to you if you could
help me find the solution to this problem I am in
Many thanks
cfcoder
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
