Replace Characters Help

Hey community,

I'm working through invoice detail to build out a cohort analysis but need some help. Our system includes the month on the end of each service in our invoice descriptions, for example "Recurring Service - January 2023" and then "Recurring Service - February 2023".

However, the month is only included in the invoice description for recurring services and not for one-time services such as repairs.

How can I easily remove " - January 2023" and other respective months when included in the invoice description, but keep the original invoice description if the month isn't present.

Unfortunately hyphens are not unique only to these instances so I can't leverage text to columns.

Thanks!

Best Practices

Accepted answers

ShankerV

Hi @tmorrison

One way of doing this.

Have checked the workflow with different test cases and shared the output for your reference.

Let me know if you have more questions related to the same.

Output after run:

Many thanks

Shanker V

Replace Characters Help.yxmd

ShankerV

Hi @tmorrison

One more tweak to the previous solution.

Have tried to eliminate the special characters also if has any along with trailing white spaces issue too.

Input:

Output after run:

Many thanks

Shanker V

Modified latest Replace Characters Help.yxmd

All comments

binu_acs

@tmorrison One question the Recurring Service - January 2023 - is generating at the end of January, the same as Recurring Service - February 2023 is at end of Feb?