Solved

How to trim string length to max. 35 characters?

  • 19 February 2018
  • 5 replies
  • 17 views
E
Badge

Hi all,

I'm looking to trim a string to max. 35 characters.

 

Actually 34 characters and ending with a "." to indicate the string has been shortened.

 

What transformer can I use? Or does this require some RegEx?

Thanks,

Ed

icon

Best answer by david_r 19 February 2018, 10:09

View original

5 replies

david_r
Rank
Userlevel 4

You could create a small custom transformer which could contain a StringLengthCalculator, a Tester (_length > 34), which, if true, would use a SubstringExtractor to get the first 34 characters and then add the point.

redgeographics
Rank
Userlevel 5
Badge +25

I would expect the StringFormatter to be able to handle the trimming, but it doesn't seem to want to do that.

E
Badge

You could create a small custom transformer which could contain a StringLengthCalculator, a Tester (_length > 34), which, if true, would use a SubstringExtractor to get the first 34 characters and then add the point.

I'm almost there but how to I add the "." at the end of the string?

 

 

redgeographics
Rank
Userlevel 5
Badge +25
I'm almost there but how to I add the "." at the end of the string?

 

 

AttributeManager, set the value of that attribute to the original plus a .

 

E
Badge
AttributeManager, set the value of that attribute to the original plus a .

 

Thanks!

 

That's what I like about this forum - you guys are so quick to respond!

 

 

Best,

 

Ed

 

 

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
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.