Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Loading Numeric data where separators are 'reversed'
 
From:   Jonathan Wakelin

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016