Removing duplicate content in text file

Help
1

Hi,

I currently have 3 text files, namely Basket1, Basket2 and TotalBasket.

Basket1:
Apple
Banana

Basket2:
Mango
Pear

TotalBasket:
Apple
Banana
Mango
Pear
Strawberry
Blueberry

I would like to retrieve content for new text file Basket3 with the following:
Strawberry
Blueberry

Basically, Basket3 = TotalBasket - (Basket1 + Basket2).

Please help!

2

Hai @wootberries24… Use Read Text File activity to read each file ,feed the path of file
Use assign activity, in assign use ur basket 3=Totalbasket-(Basket1+ basket 2), then use create file activity give the file type that u need to create… Name it as basket 3… This may helps u

3

Hi,

It’s currently giving me an error of:
"Option Strict On disallows implicit conversions from ‘String’ to ‘Double’ when I assign Basket3=TotalBasket-(Basket1+Basket2)

How should I approach this further?

4

Create separate variabls for each file and fix variable type as “double” try this

5

Now each of my ‘Read Text File’ variable has an error of:
“Option Strict On disallows implicit conversions from ‘Double’ to ‘String’” when I assign their variable type to System.Double.

Are you able to show me an example?

6

Wait fr some time…I’ll send u… @wootberries24

7

Hi @wootberries24 ,

Please refer this,

RemoveDuplicates.zip (1.9 KB)

Thanks!

1 Like
8

Awesome! It works!

Thank you so much!

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.