How can I compare 2 numeric variables and find double values

Hi Leon

If you have two variables you first need to split them into two sperate ones. To do that use the "split" command and use your divider "|".

Then use the "if" command to to compare them. In the command set the comparison to "if equal". That way you will be able to create a deletion step for the duplication and the rest of the data you want will "go" trough another step.

Problem is that there can be more than 2 values in each variable...:(

Hi Leon

In case you have a string with more than one value in the variable you can use the advanced command "Replace" with regex as follow: (see pics)

Regex line- (w+)s*|s*(?=.*1)

You can see that after running the command on the variable the duplications were erased.

I attached a LWIZ file for your use.

Great tip, haven't tried that looks promising...

I'll let you know if this is the solution for my problem..