Archives of the TeradataForum
Message Posted: Sun, 11 May 2003 @ 20:36:00 GMT
I need to load some data where numeric values that have been supplied in character fields where the 'separators' are reversed.
By this I mean that the thousands and hundreds are separated by the equivalent of a decimal point and the decimal point itself is represented by a comma.
This method of displaying numbers is commonly used in Europe but not in the UK.
Usual format = 123,456,789.99
Apart from the obvious choices of:
a) Fastloading the data into a character field and then using Index Substring Function to attempt to reformat once on Teradata
b) Re-defining the input field as separate parts with fillers between each and then concatenating the fields in a Multiload
.neither of which are very satisfactory as I have almost a hundred of these fields to load, does anyone know if there is a way that a 'format' can be applied in the 'Insert' statement of the Fastload, in order to tell Teradata that the points are commas and the comma is a point!!! By the way, I am loading the data from an IBM Mainframe environment.
Any suggestions (apart from the UK joining the Euro - only joking!) would be gratefully accepted.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|