Collection Manipulation - Filter

[robinjens1]

Hello,

I have a collection (Collection In) I want to filter out blank spaces from. As you can see from the picture with the error message, the filter (Filter) is working as intended, but it won't output to the new collection (Collection Out).
View attachment 1560322152567.png

The Code Stage that is failing is the default one shown in the picture. (Utility - Collection Manipulation - Filter)

Any tips would be greatly appreciated!

EDIT:

The Filter I'm using is the following:
Replace([Fradato.Fradato], " ", "")

 

[Sachin_Kharmale]

Hi Robinjen,

Instead of using collection Manipulation
1) Just Loop your Input collection
2) Use calculation stage to replace the value

Design Flow like bellow
View attachment 1560325629296.png
Use bellow calculation Stage to Replace
View attachment 1560325649393.png

Output will be look like
View attachment 1560325676695.png
Best,
Sachin

 

[robinjens1]

This is my current workflow
View attachment 1560327203051.png

I need to filter the Fradato collection to not include spaces.

 

[robinjens1]

Over-complicating things are fun....

To store in collection as I wanted I had to add a new field in my current Fradato collection and use that as my output for the calculation that I wanted to perform.

View attachment 1560408718684.png

Thanks for trying to help, Sachin.

 

[democko_kamil]

Filter doesn't work with dots or spaces. I made a new object just for working with spaces and dots, but it's quite complicated.

Try looping it to find the string you're looking for, or replace it with calc (and assign back to collection) if you want to get rid of spaces.