• EN
Solved

Right string function in attribute manager

  • 19 March 2024
  • 4 replies
  • 37 views
rrichter
Rank
Badge +1

I have a column of data with a 10-digit alphanumeric value.  I need to keep those values and in a new column return just the last 5 characters of that column

I thought it would be as simple as creating a new column in the attribute manager and then in the attribute column I put in the string function @Right(NODE_NUM, 5)

I have tried at least 4 or 5 different formatting methods, using quotes “ “ or extra parentheses while writing out the string function, but I am lost.  I use this exact same string function in MapInfo all the time and it works like a charm.  But when I put in these values in just inserts “e_num” into each row as e_num are the last from characters of NODE_NUM.

What am I doing wrong?

results in

Thanks in advance

icon

Best answer by liamfez 19 March 2024, 21:00

View original

4 replies

liamfez
Rank
Userlevel 5
Badge +13

I would recommend using the SubstringExtractor, I think that should do what you are looking for. Here is its documentation: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/substringextractor.htm

liamfez
Rank
Userlevel 5
Badge +13

If you were wanting to use the Right string function on the value of an attribute like node_num, then you need to type it differently. You could either double click the attribute from the FME Feature Attributes panel, or type it “@Value(node_num)” instead of “node_num”.

rrichter
Rank
Badge +1

Thanks so much, your second suggestion worked the first time I put it in.  I had actually typed that out exactly as you wrote it but that did not work, but double clicking the attribute inserted it perfectly and in the text editor @Value and the node_num part were in different colours, not sure if that had something to do with it, but double clicking worked, and typing it in manually did not.

Thanks so much!

 

liamfez
Rank
Userlevel 5
Badge +13

Your welcome, yes the @Value and the attributes name should be different colours when it is working correctly.

Reply


Community Stats

28,867
Posts
109,989
Replies
36,678
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.