Regular expression global modifier

[rkapoor]

I have a string which is comma and space separated. I want to pick all the text between ,\s token.

Regular expression I used is ([,\s])+

I then check if end of string is reached and keep iterating through loop ( to set global modifier). Issue is that as I am picking before match string, the last value never get saved in the output array.

String to parse:

Index 0 -> 100, 200, 300, 400, 500, 600, 1, 4, 23, 45

Index 1 -> 6000

Output needed is 1D array of string (11 elements) starting from 100 till 6000

The other solution I see if using spreadsheet string to array function but am looking to get this done using regular expressions.

[JLZam]

Hi rkapoor,

The reason why you are not seeing the last element at the output array is because you are only adding the "Before Match" strings. So when the program gets to the last colon ',' at 23,45 it will add the 23 to the array, but in the next iteration it will not find another colon so there is no text to show.

You can solve this in an easy “informal” way by simply adding a colon at the end of the string, or by finding a way to load the last number (like in the attached image)

Hope this helps. Good luck!!

[ben64]

---

@rkapoor wrote:

I have a string which is comma and space separated. I want to pick all the text between ,\s token.

Regular expression I used is ([,\s])+

I then check if end of string is reached and keep iterating through loop ( to set global modifier). Issue is that as I am picking before match string, the last value never get saved in the output array.

String to parse:

Index 0 -> 100, 200, 300, 400, 500, 600, 1, 4, 23, 45

Index 1 -> 6000

Output needed is 1D array of string (11 elements) starting from 100 till 6000

The other solution I see if using spreadsheet string to array function but am looking to get this done using regular expressions.

---

If "Index 0 -> " is part of your string your code will not eliminate it. What is the purpose of the convertion to capital letters when you want to match numbers? You should post your code instead of a picture of it, it will be easyer for people to help. Supposing the numbers you want are either always immediatly followed by a comma, before an end of line or at the end of the string the following code should do what you want.

Ben64

[rkapoor]

Sorry here is more information:

Index 0 is not part of string. Although I stated just the numbers, incoming strings are not always numbers but common across is that they are either ,\s delimited or just one string.

Another possible strings combination is XXXX-Y0100-354, 100, TTTT-M0123-846

so need tokenize using ,\s

[ben64]

---

rkapoor a écrit :

Sorry here is more information:

Index 0 is not part of string. Although I stated just the numbers, incoming strings are not always numbers but common across is that they are either ,\s delimited or just one string.

Another possible strings combination is XXXX-Y0100-354, 100, TTTT-M0123-846

so need tokenize using ,\s

---

Try using replacing the regex by the folling one in my code:

[^\s,]+

Ben64

[RavensFan]

JLZam

That's comma.   Not a colon which is :

[dpnsw]

These might be useful.

Excellent tutorial and cheat sheet

Regex builder put your expression in and test it out live on your text

[JLZam]

You're right. Thank you! 🙂