I’ve got a Zap connecting Docparser to Xero, the Zap uses all the data from an Invoice/Receipt that was sent to Docparser to create a Bill in Xero. There are Line-Items in my original ‘Invoice/Receipt’ and I’d like to use the first 2-words of each Line-Item as the ‘Bill Reference’ inside Xero.
Here’s the issue I need to solve: Sometimes the first 2 words of the various Line-Items are identical and end up repeating the same data in the ‘Bill Reference’. Is it possible to format this identical data to replace: ‘Item N, Item N, Item N, Item O’ and format it as: ‘3x Item N, Item O’?
Has anyone got a technique for this?