split by first space

[MaxF]

Hallo, 

I have a String which looks like this: 16 Streetname 23

The number at the beginning can be random. So it can be 3, 5, 8, 22.....

So I just want to extract the part: Streetname 23

thanks for any kind of help

[tom_riha · Accepted solution]

Hello @MaxF ,

you could split it by the space, then skip the first object, and join the rest again using spaces.

join(skip(split(<string>, ' '),1), ' ')

[miguelcas]

Hi @MaxF 

Here is a way using expressions to get the string that you are looking for: 

substring(variables('StringToSplit'),add(indexOf(variables('StringToSplit'),' '),1), sub(length(variables('StringToSplit')),add(indexOf(variables('StringToSplit'),' '),1)))

I would recommend you to put this expressions into a compose action in order to get the string. This function will eliminate all characters before the first blank space from a string. in the function you need to replace the variables('StringToSplit') with your string as a variable, text or dynamic content. 

If you want to learn more about expressions and functions here are some MS Docs to consider. 

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Microsoft Flow - Expressions and how to use them - Power Platform Community

Thank you for using Microsoft Power Platform Communities.
Community Support Team - Miguel Castro.
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

[MaxF]

Hallo Tom,

thanks, your solution works for me because of that i accept your answer. 

The problem what have now, there was probably a display error in sharepoint where I want to store it,

Because when I look in details the string looks like this: 16Streetname 3
Because now it always returns me only the 3, which is correct according to your solution.
Do you have a solution for this(16Streetname 3) scenario too?
I still want only the string: Streetname 3
The numbers can still be random. 1,2,10, 22...

[tom_riha]

Hello @MaxF ,

since Power Automate doesn't support regular expression, I don't think it's doable. You could go character by character and check if it's a number, but that would be a terrible solution. Therefore, I don't have a solution for situations when there's no space.