Search Results

If awk have "value too long error", try this:

while read line
do
# E.g 1-3 is one value, 5th field is another, 16-33 is another and so on
echo ${line:1:3} ${line:5:1} ${line:16:17} .........

You can also write a control file for sqlldr which will do just that.

Check POSITION syntax in sqlldr control files, it should be just what you are looking for.
i would write some example but i'm...

upload input data file , maybe you needn't cut command at all.

if the column split by space or other, we can take them directly by:

awk '{print $2, $5, etc}' your_data.file

First, various *nix flavors of cut are very slow because they read a byte at a time. Try awk with substr. Make sure you use the C locale.
Second, with sqlldr you don't need to create a temp file to...

Try for a chance..

while read LINE
do
SQL=
for i in 1-3 5 18-33 48-63 64-65 66-83 84-115 116-147 259-260 261-292 303-306 307-310 326-327 328-333 334 2126-2127 2206-2219 2220-2225 2226-2237
...