Dynamic Length - pick last 7 characters of a string

More

7 years 11 months ago #13864 by gia

Dynamic Length - pick last 7 characters of a string was created by gia

From an input field we want to pick last 7 characters, the length of string can vary, please suggest which transformation can be used.

Please Log in or Create an account to join the conversation.

More

7 years 11 months ago #13866 by Peter.Jonson

Replied by Peter.Jonson on topic Dynamic Length - pick last 7 characters of a string

Right,

Peter Jonson
ETL Developer

The following user(s) said Thank You: gia

Please Log in or Create an account to join the conversation.

More

7 years 11 months ago #13869 by gia

Replied by gia on topic Dynamic Length - pick last 7 characters of a string

thanks! strange that our version(installed a couple of months ago) of the tool is sending null as output

when using right transformation

Please Log in or Create an account to join the conversation.

More

7 years 11 months ago #13870 by Peter.Jonson

Replied by Peter.Jonson on topic Dynamic Length - pick last 7 characters of a string

Trim the data first, may be you have some leading spaces which you can't see :dry:

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.