About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces Zapier Canvas Zapier Chatbots

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Replace/Remove Text After specific character in line item

  • 24 May 2024
  • 2 replies
  • 24 views
J

I am processing orders from Woocommerce and sending to Xero. I have some products with similar SKUs which I want to simplify. (Woo won’t allow duplicate SKUs). I have entered the SKUs to have common details, followed by a hyphen and then the bits I want removed. 
 

How can I replace (with nothing) all text after a given character in a line item?

As an example below are some SKUs I have and what I want them to be. Replace would do it, but I can only get it to replace a whole known string not a string with wildcard. 

Input              Required out

650Hi             650Hi

650Hi-Eco      650Hi

659Hi-Paint    650Hi

 

I had thought doing Find/Replace -* with [nothing] was the kind of thing I was looking for. 

Any thoughts gratefully received  

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @JasonAndre 

You can use a Zap Code step: https://zapier.com/apps/code/help

Code step also has AI: https://help.zapier.com/hc/en-us/articles/15666688064013-Generate-a-Code-step-using-AI-Beta

 

CODE

// Extract SKU from line item and remove text after hyphen
const lineItem = inputData.line_item; // Assuming 'line_item' is the variable containing the SKU
const hyphenIndex = lineItem.indexOf('-'); // Find the index of the hyphen
const simplifiedSKU = hyphenIndex !== -1 ? lineItem.substring(0, hyphenIndex) : lineItem;

// Assign the simplified SKU to the output field
output = { simplified_sku: simplifiedSKU };

 

Feedback from ChatGPT

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@JasonAndre 

Another approach using Formatter > Text > Split (which handles line items)

 

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions