Can - Text formater : Split based on 2 values? A or B?

[Pabblynaut]

Can the Pabbly text formater be used to split both strings below?

Text to Split: # OR &

apples#bananas
peaches&apples

Wanted result:
bananas
apples

Any help is appreciated!

 

[Pabblymember11]

Hey @Pabblynaut

You can use 2 Text Formatter action steps in your workflow to split the "bananas" and "apples". Please check the following screenshot for your above concern.

1-

2 -

 

[Oleksandr]

Hi everyone,
What would be the correct way of using the text formatter to convert 09:00:00 to 09:00? I tried splitting the ":00", but in this case, it returns 09. If the time is 09:15:00, 09:50:00, 09:30:00, etc - it works, because it takes only the last 2 zeros, but I can't figure our how to get rid of the seconds. I tried using ALL of the available segment text options with :00, but so far, no luck...

 

[Pabblymember11]

Hi everyone,
What would be the correct way of using the text formatter to convert 09:00:00 to 09:00? I tried splitting the ":00", but in this case, it returns 09. If the time is 09:15:00, 09:50:00, 09:30:00, etc - it works, because it takes only the last 2 zeros, but I can't figure our how to get rid of the seconds. I tried using ALL of the available segment text options with :00, but so far, no luck...

Please refer to the following screenshot for your concern.