in the above data all the columns are numbers only. But From the source file we are receiving data in the sixth column in exponential format (which is out of control from us) now I need to convert this into number and load into table (Because my Table column data type is number).
If this is a table in a database, what's the name and version of the database engine? (Oracle 10g? MySQL 5.1? Something else?)
In general, I'd search the database documentation for functions like TO_NUMBER(), CONVERT() or CAST(). Without knowing the name of the database engine, it is hard to be more specific.
> Sure from nowonwards I will try to assign the points aswell.
Thanks. You can go back (using your profile) and find those threads where you didn't assign points and evaluate those too.
The value to assigning points is two-fold: (1) to say "thanks"; and (2) to flag the discussion and its contributions for future viewers to find what solved *your* problem and therefore what might be helpful to them.
Assuming you don't have any fractions, you can also use this awk: awk ' BEGIN { OFMT="%.0f" } { for (i=1; i < NF; ++i) printf "%.0f ", $i print $NF } ' file
