Skip to main content
  • EN

Hi,

I am looking for a transformer to filter by the amount of characters.

for example I have a set of ID numbers and I need to extract all the Id's that are only 18 characters long.

Help please !

Thanks,

Samuel

Hi @sspag1I would use the StringLenghtCalculator and test the string length attribute in a tester.

Hope this helps

Hi,

Use stringlengthcalculator and tester to filter out

I would use the AttributeValidator transformer and test on the validation rule "Maximum length".

I would use the AttributeValidator transformer and test on the validation rule "Maximum length".

Nice one @erik_jan, didn't consider it, guess I'm stuck thinking the 'old way' sometimes...

 

Hi @sspag1I would use the StringLenghtCalculator and test the string length attribute in a tester.

Hope this helps

No need to calculate string length outside of the tester unless you want to store for later use. It can be done in one tester

 

 

No need to calculate string length outside of the tester unless you want to store for later use. It can be done in one tester

 

 

True and I would personally use the function in the transformer, it's sometimes not that easy to guess the expertise level of a user so I usually tend to provide the easiest solution.

 

 

Hi @sspag1I would use the StringLenghtCalculator and test the string length attribute in a tester.

Hope this helps

Thanks itay

 

I eventually worked it out and did exactly this

 

Thanks for the reply

 

 

Reply


Community Stats

30,126
Posts
114,364
Replies
37,763
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.