# Parse out the last word in a string

**URL:** <https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768>\
**Category:** DQL\
**Tags:** dql, log-processing, dpl\
**Created:** [March 18, 2025, 2:08pm UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768 "2025-03-18T14:08:57Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![pieter\_luttig](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pieter_luttig/32/37241_2.png) [@pieter\_luttig](https://community.dynatrace.com/u/pieter_luttig)\
**Post date:** [March 18, 2025, 2:08pm UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/1 "2025-03-18T14:08:57Z")

</div>

Does anyone know if it is possible to parse out the last word in a string? (The word can differ)

The DPL reference does not mention this anywhere.

Regards

Pieter

---

<div class="post-metadata">

**Author:** ![zaid-bashir](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/zaid-bashir/32/22651_2.png) [@zaid-bashir](https://community.dynatrace.com/u/zaid-bashir)\
**Post date:** [March 19, 2025, 6:03am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/2 "2025-03-19T06:03:27Z")

</div>

Hi&nbsp;[@pieter\_luttig](https://community.dynatrace.com/user/30846)&nbsp;  
We can achieve this using plain DQL as well. Below is the DQL query for the same.

```markup
data record(name = "Hello Dynatrace Community")
| fieldsAdd parsed = splitString(name," ")
| fieldsAdd result = arrayLast(parsed)

```

The above query is dynamic, you can use this for any string text. The working is simple:

1) First take the string data which you have to parse.  
2) Then Split the String using **splitString** &nbsp;function with some pattern like " " (SPACE) here. It will convert String in List.  
3) Finally, use function **arrayLast** to get the last part of the string.

 ![zaidbashir_0-1742364177360.png](https://global.discourse-cdn.com/dynatrace/original/3X/9/9/999ed43b148d1d60bdb5958c6efea71a482e8658.png)

---

<div class="post-metadata">

**Author:** ![pieter\_luttig](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pieter_luttig/32/37241_2.png) [@pieter\_luttig](https://community.dynatrace.com/u/pieter_luttig)\
**Post date:** [March 19, 2025, 7:18am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/3 "2025-03-19T07:18:16Z")

</div>

Hi&nbsp;[@zaid-bashir](https://community.dynatrace.com/user/79156),

Thanks for this, maybe let me give you an example of my data set.

With the below, I need to create an attribute to calculate the number of each currency pair (GBPZAR, USDZAR, etc.) which differs with every quote. The Currency pair is always the last word in the string.

```markup
2025-02-16T09:02:05.706761982+02:00 stdout F 2025-02-16 09:02:05,706 INFO 1dsd456a123-exxx1-4c345-923ws-0c5xxxxxxx4455555 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - TH34fghJUy68Vfgjg12z67 - GBPZAR

```

```markup
2025-02-16T09:02:05.706761982+02:00 stdout F 2025-02-16 09:02:05,706 INFO 1dsd456a123-exxx1-4c345-923ws-0c5xxxxxxx4455555 FXRatesService.MoveNext - Get FX Rate Quote: Treasury One (Pty) Ltd - Tier 1 - 1 - USDZAR

```

Regards

---

<div class="post-metadata">

**Author:** ![PacoPorro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pacoporro/32/36087_2.png) [@PacoPorro](https://community.dynatrace.com/u/PacoPorro)\
**Post date:** [March 19, 2025, 7:44am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/4 "2025-03-19T07:44:05Z")

</div>

Could you please try with

```markup
fetch logs
| fieldsAdd lastWord = arrayLast(splitString(content, " "))

```

May work

 ![PacoPorro_0-1742370234634.png](https://global.discourse-cdn.com/dynatrace/original/2X/3/37e3905ba111f7b10bd931786344baaef04cb915.png)

---

<div class="post-metadata">

**Author:** ![zaid-bashir](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/zaid-bashir/32/22651_2.png) [@zaid-bashir](https://community.dynatrace.com/u/zaid-bashir)\
**Post date:** [March 19, 2025, 7:46am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/5 "2025-03-19T07:46:42Z")

</div>

Thanks for the input&nbsp;[@pieter\_luttig](https://community.dynatrace.com/user/30846)&nbsp;  
Do You Need In This Format

 ![zaidbashir_0-1742370321942.png](https://global.discourse-cdn.com/dynatrace/original/3X/3/6/361557b5312af3c131b6901bccbfe4319f510ee3.png)

Here is a sample dataset I created for You With DQL Query.

```markup
data record(dset1 = "2025-02-16T09:02:05.706761982+02:00 stdout F 2025-02-16 09:02:05,706 INFO 1dsd456a123-exxx1-4c345-923ws-0c5xxxxxxx4455555 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - TH34fghJUy68Vfgjg12z67 - GBPZAR"),
     record(dset1 = "2025-02-16T09:03:10.812345678+02:00 stdout F 2025-02-16 09:03:10,812 INFO 2asd789b456-zyyy2-5d678-456ab-1d5yyyyyyy6677777 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - YU56dfgHJk90Xyzkl34z78 - USDJPY"),
     record(dset1 = "2025-02-16T09:04:15.923456789+02:00 stdout F 2025-02-16 09:04:15,923 INFO 3qwe012c789-abcd3-6e901-567cd-2e6zzzzzzz8899999 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - OP78hjkLMn12Wxyzm56a89 - EURUSD"),
     record(dset1 = "2025-02-16T09:05:20.034567890+02:00 stdout F 2025-02-16 09:05:20,034 INFO 4rty345d012-wxyz4-7f234-678de-3f7aaaaaaa9900000 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - ZX90mnoPQr34Abcde78b01 - AUDCAD"),
     record(dset1 = "2025-02-16T09:06:25.145678901+02:00 stdout F 2025-02-16 09:06:25,145 INFO 5uio678e345-lmno5-8g567-789ef-4g8bbbbbbb0111111 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - CV12qrsTUv56Defgh90c23 - NZDCHF"),
     record(dset1 = "2025-02-16T09:07:30.256789012+02:00 stdout F 2025-02-16 09:07:30,256 INFO 6asd901f678-pqrs6-9h890-890fg-5h9ccccccc1222222 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - BN34uvwXYz78Gijkl12d45 - USDCHF"),
     record(dset1 = "2025-02-16T09:08:35.367890123+02:00 stdout F 2025-02-16 09:08:35,367 INFO 7zxc234g901-qrst7-0i123-901gh-6i0ddddddd2333333 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - KL56mnoPQr90Hijkl34e67 - GBPJPY"),
     record(dset1 = "2025-02-16T09:09:40.478901234+02:00 stdout F 2025-02-16 09:09:40,478 INFO 8vbn567h234-uvwx8-1j456-012hi-7j1eeeeeee3444444 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - OP78hjkLMn12Xyzkl56f89 - EURJPY"),
     record(dset1 = "2025-02-16T09:10:45.589012345+02:00 stdout F 2025-02-16 09:10:45,589 INFO 9mkl890i567-wxyz9-2k789-123ij-8k2fffffff4555555 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - ZX90mnoPQr34Abcde78g01 - CADJPY"),
     record(dset1 = "2025-02-16T09:11:50.690123456+02:00 stdout F 2025-02-16 09:11:50,690 INFO 10qwe123j890-abcd0-3l012-234jk-9l3ggggggg5666666 FXRatesService.MoveNext - Get FX Rate Quote: TFX - Tier 3 - CV12qrsTUv56Defgh90h23 - AUDJPY")

     | fieldsAdd parsed = splitString(dset1,"-")
     | fieldsAdd currency = arrayLast(parsed)
     | dedup currency
     | summarize currencyCount = count(), by:{dset1,currency}

```

---

<div class="post-metadata">

**Author:** ![pieter\_luttig](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pieter_luttig/32/37241_2.png) [@pieter\_luttig](https://community.dynatrace.com/u/pieter_luttig)\
**Post date:** [March 19, 2025, 7:52am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/6 "2025-03-19T07:52:03Z")

</div>

Hi&nbsp;[@PacoPorro](https://community.dynatrace.com/user/40713)&nbsp;, this is exactly what I am looking for, thank you!

---

<div class="post-metadata">

**Author:** ![pieter\_luttig](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pieter_luttig/32/37241_2.png) [@pieter\_luttig](https://community.dynatrace.com/u/pieter_luttig)\
**Post date:** [March 19, 2025, 7:53am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/7 "2025-03-19T07:53:43Z")

</div>

Hi&nbsp;[@zaid-bashir](https://community.dynatrace.com/user/79156)&nbsp;, this will also work for me, thanks for showing!

Regards

---

<div class="post-metadata">

**Author:** ![pieter\_luttig](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pieter_luttig/32/37241_2.png) [@pieter\_luttig](https://community.dynatrace.com/u/pieter_luttig)\
**Post date:** [March 19, 2025, 7:57am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/8 "2025-03-19T07:57:54Z")

</div>

I have to ask, how do I keep the dataset up to date?

---

<div class="post-metadata">

**Author:** ![zaid-bashir](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/zaid-bashir/32/22651_2.png) [@zaid-bashir](https://community.dynatrace.com/u/zaid-bashir)\
**Post date:** [March 19, 2025, 8:00am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/9 "2025-03-19T08:00:35Z")

</div>

Thanks for acknowledging the solution.  
I didn’t understand, Can you explain it a bit.

---

<div class="post-metadata">

**Author:** ![pieter\_luttig](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pieter_luttig/32/37241_2.png) [@pieter\_luttig](https://community.dynatrace.com/u/pieter_luttig)\
**Post date:** [March 19, 2025, 8:07am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/10 "2025-03-19T08:07:13Z")

</div>

Sure,

I need to create a log processing rule to structure the data in such a way as to create an attribute for the currency pairs. This way I can use the attribute in a metric dimension to split by each currency pair count.

Regards

---

<div class="post-metadata">

**Author:** ![pieter\_luttig](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pieter_luttig/32/37241_2.png) [@pieter\_luttig](https://community.dynatrace.com/u/pieter_luttig)\
**Post date:** [March 19, 2025, 8:29am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/11 "2025-03-19T08:29:57Z")

</div>

[@PacoPorro](https://community.dynatrace.com/user/40713)&nbsp;Do you know why this does not work with log processing rules? Does it use a different syntax?

 ![pieter_luttig_0-1742372948924.png](https://global.discourse-cdn.com/dynatrace/original/3X/e/3/e376732ef4f1d3c2f2ed8c35e4fcf47f5bed2904.png)

---

<div class="post-metadata">

**Author:** ![zaid-bashir](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/zaid-bashir/32/22651_2.png) [@zaid-bashir](https://community.dynatrace.com/u/zaid-bashir)\
**Post date:** [March 19, 2025, 8:30am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/12 "2025-03-19T08:30:06Z")

</div>

Thanks for the input&nbsp;[@pieter\_luttig](https://community.dynatrace.com/user/30846)&nbsp;  
I created a log processing rule and also a DPL way to extract currency. Have a look at Screenshots attached below.

 ![zaidbashir_0-1742372763363.png](https://global.discourse-cdn.com/dynatrace/original/2X/c/c83a73893bd15c464ff03418755d9d0f39e02285.png)

 ![zaidbashir_1-1742372798192.png](https://global.discourse-cdn.com/dynatrace/original/3X/1/9/19fc8929b585550e8a4c70bb46c13efc0d08b411.png)

And the DPL way to extract Currency is as following:

```markup
PARSE(content,"ld 'Tier' SPACE INT SPACE '-' SPACE ALNUM SPACE '-' SPACE string:value")

```

Now Whenever you fetch logs matching content “ **Get FX Rate** ”, they will contain one field “ **value** ”, where your currency will be stored.

Thanks for posting this question, I also learned a lot.

---

<div class="post-metadata">

**Author:** ![pieter\_luttig](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pieter_luttig/32/37241_2.png) [@pieter\_luttig](https://community.dynatrace.com/u/pieter_luttig)\
**Post date:** [March 19, 2025, 8:48am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/13 "2025-03-19T08:48:18Z")

</div>

Hi&nbsp;[@zaid-bashir](https://community.dynatrace.com/user/79156)&nbsp;, you nailed it, this is working perfectly!

I made the mistake of thinking that DQL and DPL have some degree of compatibility between them.

Apologies for not explaining it better from the beginning.

Regards

Pieter

---

<div class="post-metadata">

**Author:** ![zaid-bashir](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/zaid-bashir/32/22651_2.png) [@zaid-bashir](https://community.dynatrace.com/u/zaid-bashir)\
**Post date:** [March 19, 2025, 9:46am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/14 "2025-03-19T09:46:24Z")

</div>

Hi&nbsp;[@pieter\_luttig](https://community.dynatrace.com/user/30846)&nbsp;  
Glad to hear that you are satisfied with the Solution.

---

<div class="post-metadata">

**Author:** ![zaid-bashir](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/zaid-bashir/32/22651_2.png) [@zaid-bashir](https://community.dynatrace.com/u/zaid-bashir)\
**Post date:** [March 19, 2025, 9:51am UTC](https://community.dynatrace.com/t/parse-out-the-last-word-in-a-string/50768/15 "2025-03-19T09:51:36Z")

</div>

Hi&nbsp;[@pieter\_luttig](https://community.dynatrace.com/user/30846)&nbsp;  
For better understanding, go to the example link shown above…
