Split not working

[Negjat Jusaj]

Hello community,

I am trying to map the following use case in an automation, unfortunately without success: I want to "increment" the current value of the Angenummer attribute in asset management, in the first step I try to divide the string Angenummer (2024/1), unfortunately that doesn't work for me (I don't get a result): I have already tried the following functions:

{{lookupObjects.first.Angenummer}} = Angenummer is displayed {{lookupObjects.first.Angenummer.split("/").1.asNumber}} = No result {{lookupObjects.first.Angenummer.split("/").1}} = No result {{lookupObjects.first.Angenummer.split("/")}} = No result Test {{lookupObjects.first.Angenummer.trim().split("/").1}} = No result Result

I've already tried substring - unfortunately without result.... Does anyone have an idea why this doesn't work?

[Bill Sheboy · Accepted solution]

Hi @Negjat Jusaj 

You state you have tried several things, yet the community cannot observe those to compare what you believe happened to what the rule execution shows...

For a question like this, context is important for the community to help.  Please post the following:

• an image of your complete automation rule in one single image file
• images of any relevant actions / conditions / branches
• an image of the audit log details showing the rule execution

Kind regards,
Bill

[Callum Carlile _Automation Consultants_]

@Negjat Jusaj Apologies to respond to a resolved thread, and you may have already found your solution by now...

But I recently have found the same issue with the split function not working with lookupObjects results, and what worked for me was:

• Find the objects using the Lookup Objects action
• Set a variable to {{lookupObjects}} - e.g. called variableOne
• Then use the split function, or any other functions you need, on the variable - using {{variableOne.split("/")[.etc.etc]}}

This worked for me, hopefully will be helpful for others running into the same problem!

[Salih Tuç]

Hi @Negjat Jusaj ,

".1" is not a valid getter for the list type in smart values. You can use following to access the elements:

• first -> To access first element (Element at 0, first part of the split)
• last -> To access the last element
• get(i) -> To access the ith element

So, just change your smart values as {{lookupObjects.first.Angenummer.split("/").get(1)}} in order to get "1" from "2024/1"

[Negjat Jusaj]

Hi,

thanks for your contribution, unfortunately I still don't get any results

[Salih Tuç]

Ok, then new idea:

• Create an attribute -> angenummer => {{lookupObjects.first.Angenummer.toString()}}
• Log that value
• Run the split on this new attribute -> {{angenummer.split("/").get(1)}}
• Log that value

And then, can you share the logs if this doesn't work?

[Negjat Jusaj]

Hi Salih,

thanks for your help. I'm already running the logging, the problem is that I'm not getting any errors with the smart values ​​used, but simply no results are being output.

[Sebastian Krzewiński]

Hi @Negjat Jusaj 

As I remember split() is working on strings. I'm not sure that your script knows that you are working on string.

Please try to add toString() before split()

Also what is see is you are using LookupObjects which is array so definatelly your split() is trying to work on array, not string.

Regards,

Seba

[Salih Tuç]

Hi @Sebastian Krzewiński , the value is "2024/1", so it is probably a string at first place :) I think this is related with ".1" at the end.