Skip to Content
avatar image
Former Member

Replace(Previous(Self)) - Has anyone used this structure succesfully?

Example:

I have a character string from a prompt:

[PromptString]: "a;b;c;d"

I have [DataValues]: a;b;c

I want to identify values on the [PromptString] that does not have corresponding [DataValues].

So, I am creating a [Variable]. I initialize the [Variable] with the [PromptString] (a;b;c;d) and I am trying to replace the found [DataValues](a;b;c) on the [Variable] by empty spaces (which removes them from the [Variable]) in order to identify non found values that will remain (d). Like:

Replace(Previous(Self);[DataValues];"")

So:

[Variable] initial value: a;b;c;d

Table

[DataValues] [Variable]

a_________ ;b;c;d

b_________ ;;c;d

c_________ ;;;d

That will identify d as a prompt entry that does not have corresponding [DataValues]

But I am receiving the error "The expression or sub-expression at Position 51 in the 'Replace' function uses an invalid data Type"

[DataValues] and [Variable] are both character strings.

Anyone has an example of Replace(Previous(self)) that works?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers