Skip to main content

I have 2 variables with numeric values devided by | . I want to find (remove) doubles and combine the variable in one..

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..


Reply