Splitting string doesn't work as expected

[Dev_Dav (David Silva)]

Hello there, I want to split a String, the string is the following:

ExtractedText = “82 Habitaciones privadas”
totalCuartos = ExtractedText.Split(" "c).First

I know that totalCuartos gives only the number. But when debugging it throws an error, because it doesn’t split the space between the number and the string, just the last one. I tried this in the immediate panel

I copied, pasted the symbol at position 2, but now doesn’t split last space
As you can see, this doesn’t make any sense, unless the spaces are different, but I don’t know such thing. How could I split all the string?

Thanks in advance!!

[Yoichi]

Hi

There might be some whitespace except character code 0x20.
Can you try the following expression?

System.Text.RegularExpressions.Regex.Split(yourString,"\s+").First()

Regards,

[prasath17 (Guru)]

@Dev_Dav - if you have notepad++ you can check the HEX value of that character to make sure where it is x20 …

[Dev_Dav (David Silva)]

Hi there!
That actually worked, but using RegEx Wizard with the (\s)+ expression. I don’t know how to execute that code in the actual workflow, but many thanks!!

[Dev_Dav (David Silva)]

I do have notepad++ but I don’t know how to do that sorry

[Yoichi]

Hi,

@Dev_Dav

I don’t know how to execute that code in the actual workflow

We can use it with Assign activity as the following, FYI.

Regards,