DSXchange

Hi Everybody,

I want to cut up a string displayed in 38 characters into three parts
8,10 and 10
what i can use as transformations to do this

Thank you very much.

Welcome aboard.
8 + 10 + 10 is only 28; what do you want to do with the other ten characters?
You can use the Left(string,n) function to get the leftmost n characters from a string, the Right(string,n) function to get the rightmost n characters from a string, and Substrings(string,start,length) or - equivalently - string[start,length] to extract an arbitrary substring.

Sorry 8,10,10 and 10 characters
I try the syntax string [ [ start, ] length ]
but i receive an error:

Compiling: Source = 'RT_BP15/JOB.427335405.DT.1452632587.TRANS1', Object = 'RT_BP15.O/JOB.427335405.DT.1452632587.TRANS1'
**********************************************************************************************************************
WARNING: Variable 'substring' never assigned a value.

Compilation Complete.
(Simulation1.Transformer_4)

Check your syntax:

ziedkhouja wrote: I try the syntax string [ [ start, ] length ]

The name of the function is Substrings (with a final "s"). You left this off, so DataStage is looking for a variable called Substring.