Hi all,
I have a question about a formula i want to use in a flow. I have a variable containing multiple numbers like this :
2,34,1,76,432,123,87
everytime this value changes so you never know how long it will be and with which number it is going to start. so the idea i got is to remove one value at the time , i used this formula for it : TRIM( SUBSTITUTE({!filterID}, {!LosseID}+",", "") )
it works but.. when it clears the value , it also takes the one from another value and that is messing up my outcomes. Anyone got any ideas?
thanks in advance
12 réponses
Forum Ambassador
Eric Praud (Activ8 Solar Energies)Makes sense, but it sounds liek I'm right, it's always the first number you want to remove.
If so, just go with this:
TRIM(MID({!filterID},FIND(",",{!filterID})+1,255))
