# Truncate/trimm certain part of text (URL)

**URL:** <https://forum.bubble.io/t/truncate-trimm-certain-part-of-text-url/3040>\
**Category:** Need help\
**Created:** [May 18, 2016, 7:15pm UTC](https://forum.bubble.io/t/truncate-trimm-certain-part-of-text-url/3040 "2016-05-18T19:15:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pat](https://avatars.discourse-cdn.com/v4/letter/p/8491ac/32.png) [@Pat](https://forum.bubble.io/u/Pat)\
**Post date:** [May 18, 2016, 7:15pm UTC](https://forum.bubble.io/t/truncate-trimm-certain-part-of-text-url/3040/1 "2016-05-18T19:15:57Z")

</div>

Hi,

maybe somebody can help here? I have the following problem.

I want the user to enter a specific amazon URL and then I want to populate several fields by the URL. So far I have set up blockspring and it is working fine.

Maybe I havent thought all the options through regarding input from blockspring/amazon API but I wanted to do this as simple as possible.

1. The user enters a URL. For example: [http://www.amazon.com/iPhone-Crave-Strong-Guard-Protection/dp/B019DHTGI2/ref=sr\_1\_7?s=electronics&ie=UTF8&qid=1463598809&sr=1-7&keywords=iphone+6s+case](http://www.amazon.com/iPhone-Crave-Strong-Guard-Protection/dp/B019DHTGI2/ref=sr_1_7?s=electronics&ie=UTF8&qid=1463598809&sr=1-7&keywords=iphone+6s+case)

2. Now I want bubble to trimm/truncate the URL so it throws out everything but the product id, which always comes after /dp/ . In this case this would be /dp/ **B019DHTGI2**

3. Now with this ID all the other groups now what to populate

I could do 2. in excel very easily but I cant figure out how to do this in bubble.

Does anybody know how to do that OR is there even an easier way?

Thank you guys!!

---

<div class="post-metadata">

**Author:** ![Pat](https://avatars.discourse-cdn.com/v4/letter/p/8491ac/32.png) [@Pat](https://forum.bubble.io/u/Pat)\
**Post date:** [May 19, 2016, 7:58am UTC](https://forum.bubble.io/t/truncate-trimm-certain-part-of-text-url/3040/2 "2016-05-19T07:58:49Z")

</div>

Anybody…?
