Hi,I have a field(text) “Code” in a view
For example:
AD00456
AF48795
PT48251
0048795
7894523
…
and I would like to get just the first 4 caracters from the right. I used this formula:
@RIGHT(Code;4) to create a new column in my view but got nothing, got as blank column.
Is anyone can tell me why??
Thanks
Subject: @RIGHT formula
When I get unexpected or (in this case) no results from a formula, the first thing I like to do is get something - anything - to display.
First create a column and just map it to the field ie - select field value from the field “code”.
Do the values diplay? If no, then you need to recheck all the fields on the form. Maybe they are for instance ‘computed for display’ only.
If they do display, then add a formula: @Right(code; 4). Do the values in the column disappear? Then the values in the “code” field are not able to be handled by @Right.
As the other folks have said, try changing the values - @Text, @Implode and see if things are changing.
If none of these are working, you need to look very carefully at the data values again - perhaps the properties box or using NotesPeek to see if you can determine what is the data type.
Also, using a @Prompt and showing the value or setting to a temp variable, ie temp1 := @Text(code) and then display the temp1 variable may cause a shift.
Hope something here can help you.
Subject: @RIGHT formula
Eric
Assuming your field is a multi-value field, you might need to convert the list into a string (@right is meant to work on strings according to the help file). Try:
@right(@implode(Code);4)
Dan
Subject: RE: @RIGHT formula
Sorry it doesn’t work
Subject: RE: @RIGHT formula
How doesn’t it work? What is displayed? Can you give details of the field - is it multi-value as I assumed or not? What are the exact values as displayed in the document properties?
Cheers
Dan
Subject: RE: @RIGHT formula
Well,It’s type text and editable,It display nothing.
Subject: Why not answer Dan’s question?
Eric, you didn’t read Dan’s question carefully enough. He and the others who answer your questions in this forum are donating their time and energy – precious commodities that deserve not to be wasted. You might recognize this if you ever started helping other users of this forum – so far your use seems pretty much one-way.I also recommend you study this forum’s FAQ, including how to ask a question. Please see How To Ask Questions The Smart Way .
Subject: @RIGHT formula
Just to be perfectly clear - CODE is the name of a field on the docs listed in the view rather than the title of a column in the view, right?
If it’s a field, your formula looks right to me - try @Text(@Implode(Code);", ") and see if that does anything.
If not, what do you get if you just have CODE as the column value/formula - unless the field is blank or you’re referring to the wrong field/value somehow, that should list something.