Archives of the TeradataForum

Message Posted: Sun, 11 May 2003 @ 20:36:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Example:

Usual format = 123,456,789.99
European 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.

Thanks,

Jonathan Wakelin

	<Prev	Next>		<<First	<Prev	Next>	Last>>