Hi, I have following data format: A : ABC Model: v3.5.8 source: C:\data\ABC.raw B : 123 C : 2000-10-28 D : 05:17 E : 2000-11-08 F : 01:15 name: scott tiger Purpose: Production P_id: 213435 Class: Normal G_id: 1828G SS (m): 1008W x 859H SI (m): 16.000 SC (m): 15.000 ST (m): 0.500 NFZ: 4 Vstd: EF098 VC: 0.885 CE: 0.881 Notes: None G H I J K L(1/m) M(n/m/m) N(n) XYZ efg 10.04 0.123 N 0.52 0 0 XYZ hijk 123.15 0.456 N 0.24 0 0 XYZ lmn 1001.50 0.789 N 0.88 0 0 XYZ opq 1102.20 0.147 N 0.35 0 0 .... I need to covert above data as following format which will be recognized by oracle sql*loader. ABC 123 2000-10-28 05:17 2000-11-08 01:15 XYZ efg 10.04 0.123 N 0.52 0 0 ABC 123 2000-10-28 05:17 2000-11-08 01:15 XYZ hijk 123.15 0.456 N 0.24 0 0 ABC 123 2000-10-28 05:17 2000-11-08 01:15 XYZ lmn 1001.50 0.789 N 0.88 0 0 ABC 123 2000-10-28 05:17 2000-11-08 01:15 XYZ opq 1102.20 0.147 N 0.35 0 0 ......... How to write a dos script to do the job? Thanks.

You want a DOS script or a NT/2K/XP Console script? They are two different stories because they are usually very different.

Thanks for your reply. I think it's 2K Console script. Because I use W2K cmd.

wolf60s, Then, I suggest this forum: http://www.computing.net/windows2000/wwwboard/wwwboard.html

Thanks for your reply and I'll try that. -wolf