Split function

hey all - happy friday. i need your help here - how does split function should be applied in my case, can someone please help me out?

i get a value from Monday.com which contains multiple values. i need to split them to an individual ones because i will use it to filter out later on since in my case it means that these values shouldn’t be deleted.

Hi. Are mean you have a array with bandles? Show us what type of data you are working.

Thanks, Helio!
If you have questions reach out :wink:

Screenshot 2023-02-24 at 18.11.47
i need to split this guy into individual substrings. thanks for getting back to me!

Hi @vstnv

Please use split() function as shown below:

If you need assistance, don’t hesitate to contact me.

Mohamed Jahar

1 Like

i need haha! values will be different each time because it’s a deliverable that each client chooses - what should i do in this case? much appreciated!

Hi @vstnv

This was just an example. Instead of values, please map the text variable.:grinning:

1 Like

i replied and thought about it later, thanks! should i consider ‘.’ in advance and replace it with text parser? or it shouldn’t been an issue?

1 Like

Hi, how could you then reference what part of the created array, for example, i split some text into 3 parts, i then want to reference just the first array, how would i do that.

if i have HWBO12345 / Complete / Check.

i split with split(audit name; / ), so what do i wrap around that to just use the first array, hope that makes sense

Hi @Dean_Robinson,

You can simply use first, last or get function to access the array element.

  1. first will result in the first item in the array
  2. last will return last item in the array
  3. get, to use this you will need to specify the index/position of the item you want to get, 1 being the first element, for eg,

get(split(HWBO12345 / Complete / Check;/);2)

This will return, Complete, if you use 1, it will return HWBO12345.

More info about these functions here.

1 Like

Ah perfect, thank you