I have a workflow that reads a MS Access file and splits two attributes into two separate values each by means of two AttributeSplitter transformers. I then use the AttributeManager transformer to place the 4 new values into 4 new char attributes. I need to strip the leading zeros from two of these fields and was wondering if this could be done in AttributeManager? If not how could it best be done before the AttributeManager (the next step is to use AttributeManager to concatenate these values.
Page 1 / 1
The AttributeTrimmer can strip leading 0s.
The AttributeManager can be used with the @TrimLeft(string, 0) function.
Hi @chris_m, yes you can do that using the @TrimLeft function. e.g.
@TrimLeft(@Value(_attr),0)
See here to learn more about FME String Functions.