335748_en-US

liliconcom

Truncate or Split

I have a large dataset and I would like to split with the first 7 characters in a new column. I am trying to use the left function, but I am getting an error.

 

 

 

 

 

 

Advanced Statistical ModelingData Blending and CleanupQuality and Process EngineeringRe: Truncate or Split

or

for a 16 digit number this formula would give you the 7 left digits, where you can also use trunc instead of round ...

Round( :event_time / 1000000000 )

Re: Truncate or Split

try

left( char( :event_time ), 7 )

I am guessing that your event_time column is numeric