Expression function to cut the first words of a description text

[Just4Link]

Support guidelines

• I've read the support guidelines

I've found a bug and checked that ...

• ... the documentation does not mention anything about my problem
• ... there are no open or closed issues that are related to my problem

Description

I import my data via GoCardless from the ING bank in germany. So far so good. My problem is the same as in #5403

So i have in every description in front "mandatereference:,creditorid:,remittanceinformation:"

I read about the expression function where you can shorten text via rule at the end of text.
Is there a expression function to cut a text at the beginning to get rid of this rubbish?

Debug information

no debug

Expected behaviour

No response

Steps to reproduce

No response

Additional info

No response

[JC5]

Hey, thanks for starting this discussion.

Yes, that can also be done with substring. If the string length you wish to remove is always the same, use the following:

=substr(description, 52)

If you combine this with a trigger that says "if description starts with mandatereference:,creditorid:,remittanceinformation:" it should work as expected.

Cheers,
James

[Just4Link]

Thanks for your fast answer. I realized there are some numbers in between that makes the string not predictible in length.

Is there a way to modify what the importer get from GoCardless? So i can maybe do some changes there or i have really go with api commands?

[JC5]

This is also something you can take to GoCardless, because they are supposed to clean up the data they receive.

[Just4Link]

Ok, thanks for your help.