SQLLDR导数据
请问一下大家如何用SQLLDR到如如下数据格式
其中有几个空行,我要跳过这几个空行
数据如下:
Name: Colemanite Ca2B6O11 * 5H2O
Type: Mineral
Class: Borate
Subclass: None
Particle Size: Unsieved coarse powder
Sample No.: None
Owner: USGS
Wavelength range: 0.40 - 14.05 um
Origin: Boron, California
Description: Colemanite powder from Boron, California
Measurement: Directional Hemispherical Reflectance
First Column: X
Second Column: Y
X Units: Wavelength (micrometers)
Y Units: Reflectance (percent)
First X Value: 14.05105
Last X Value: 0.40000
Number of X Values: 2756
Additional Information: None
|