[resolved] Error substring : index out of range

[sofiene92]

Hello,
I have a problem concerning substring function.
My project is a Java project, i use TOS 2.3.1 and I have a field (rha.ACTES) in which there is very long string (about 50 characters max, and this field can be nullable), and I want to extract the first eight characters in an other field (ACTE01) thanks to substring.
But I have a problem when I export in an Excel file, I have an error when I run my job...
I think this error comes from tMap.
Thanks for your answers.

Sofiene92

[Anonymous]

Hi banu,
Using String s=string1+string2 in tMap to append 987 to all numbers whose length is less than 6 and put the expression in filter.
I have a simple demo job to make it clear.
input;
number;
123456;
12345;
12;
1;
12345678;
See my screenshots
It is welcome to open a new topic for your issue so that more user will have a chance to give you a hand.
Best regards
Sabrina

[Anonymous]

how can i separate with this by range some thing like 150-153
it should 150,151,152,153 not 150,153

[Anonymous]

how can i separate with this by range some thing like 150-153
it should 150,151,152,153 not 150,153

Using tLoop to do a loop.
Best regards
Shong

[Anonymous]

I want to separate it in tNormalize with a range , it separate but not range .

[Anonymous]

tNormalize is used to normalize the rows by the item separator, for example:
150-153
normalize this row with separator "-'', the result becomes:
150
153
In your case, you need to parse the data and the get the begin value, and end value, use a tLoop to do a loop and output each value.
Best regards
Shong