Question

How do I extract a clean URL and remove attributes?

  • 2 February 2023
  • 3 replies
  • 237 views

I need to convert video files to MP3 to run them through a transcription action.

Using CloudConvert, it adds extra parameters to the end of the URL, which then causes a failed run on the transcription. I believe it’s looking for a clean .mp3 ending.

So how am I able to extract just the url up to .mp3 and delete the rest so I have a clean URL? Thanks!

 


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

3 replies

Userlevel 7
Badge +14

Hi @C47Joe 

Good question.

Looks like you have an array of line items, meaning there could be 1+ mp3s.

 

You may need to use the Looping app to handle each line item separately: https://zapier.com/apps/looping/help

 

You can use a Formatter > Text > Split (split by .mp3 and keep the first segment) step, then when you map the variable, add a static .mp3 to the end to create the full clean url.

Thanks, but it only returns one output/file. 

I’ll try the text split 

Userlevel 7
Badge +14

@C47Joe 

The 1 and 2 to the very left indicate an array of line items.

Based on the screenshots we can’t see how many total line items, nor what data is part of the second line item.