I've got a CSV file where a line can look like this:

2008-10-28 100 99.5 102 98 99.5 -0.5 -0.5 99.24 3239600.00 321484650.00

Setting *Scl to 2 gives me this after import:

2008-10-28 100 9950 102 98 9950 -50 -50 9924 323960000 32148465000

For consistency I need every integer to get two extra zeros, the 98
needs to become 9800 for instance, is there an easier way of doing
this than having to explicitly check for the absence of a dot and
having to handle the initial date separately? I'm looking for some
kind of automatic facility here similar to the *Scl mechanism but
which adds to all numbers, not just the ones recognized as fixed
points.

/Henrik
-- 
UNSUBSCRIBE: mailto:[EMAIL PROTECTED]

Reply via email to