Search if a list member exists in a text line item
I got a Invoices Data Load Module that gets its data from a numbered list "Invoices". The line items (invoice number, client, comment, amount, date etc) are the "Invoices" list properties.
We started selling a new product last month, but our ERP doesn't fill the "client" field in the invoice when it has that product code. So, all the new product's invoices got the client property blank in Anaplan.
But in the comments property (text format) it has the client name!! For example: "Invoice 00000, product X, quantity 1, price per unity $30, CLIENT, purchase date, delivery date".
I also have a clients name that contains all our clients names.
Is it possible to create a line item in the Invoices Data Load that finds in the "comment" line item if there is a client from the client list?
Is it possible to make something that works that way?
Thank you very much for your attention!!!