How to convert a text to Entity identifier

Hi,

I have value of type Text and I would like to convert to an Entity Identifier (Order Identifier).

How to do this?Any help appreciated?

Use TextToIdentifier() function

Fabian wrote:

Hi,

Thanks for the reply.But wanted to cast to an Identifier which is of type Order Identifier where Order is an entity.

TextToIdentifier just converts in to Text Identifier not to OrderIdentifier

Cheers

RajHasti

No. TextToIdentifier converts it to a numeric identifier not a text identifier. I am assuming your order identifier is a numeric identifier. a numeric identifier is basically a long integer. 

e.g. let's say you have a text "1234" and want to store it in a variable OrderId of type Order Identifier

in your assign action you assign TextToIdentifier("1234") to OrderId

Fabian wrote:

Bump,

Ran into the same issue today, TextToIdentifier just changes it to numeric, but the requirement here is to convert it into the EntityIdentifier type. Using TextToIdentifier is not solving the issue.

Anurag,

you need to convert TexttoLongInteger() or TexttoInteger() and after that LongIntegerToIdentifier() ou IntegertoIdentifier()

E.g  IntegertoIdentifier(TexttoInteger("1234")) or LongIntegertoIdentifier(TexttoLongInteger("1234"))

Use accordingly your Order Identifier ( LongInteger or Integer)

Fábio Fantato wrote:

Hi, I've a issue similar. I've a ID and I want to compare (with like) with a text variable.

When I try use IdentifyToText I have a warning, but if I convert first IdentifierToInteger and after IntegerToText I don't have any issue. Why Fabio? Can you explain me?

Regards,
Nuno Verdasca

Hi Nuno,

What exactly are you trying to convert to what? Is the identifier an Integer, Long Integer or Text? If Integer or Long Integer, why are you trying to compare it to a Text variable?

Hi Kilian, so I understand this is an warning that is happening in version 11 and in previous ones never happened, to do the direct conversion of an Identifier to a text. The warning that appears is that like only works with two texts, and the id although it is text in the query is with identifier.

Hi Nuno,

Since you didn't directly answer my questions, a last attempt to get this clear: can you provide a screen shot of both the Expression and the error message, so I can see what goes on?

Nuno Miguel Verdasca wrote:

Bump

Hi Nuno,

I'm running into the same problem. Did you ever find the answer? I'm trying to change an identifier to text. With the local variable being an entity identifier I'm trying to use IdentifierToText. As in the database the text for each identifier is active and archived that of which I need to show on screen.

Hi Jaret,

What is your problem exactly? Can you show what comparison you do, and what warning message you get?