Hello, how can I split a string at multiple locations? I dont know the delimiters before. I just know they are numeric (like in the example). What is the best way to split the string correctly? Maybe to iterate through all words and see if they are numeric and then split there? Or maybe with regex? …

Hi @Pathler , As @Shikhar_Tandon was saying, you could use the System.Text.RegularExpressions.Regex.Split method in order to get your output, let me show you an example: [image] Value: System.Text.RegularExpressions.Regex.Split(var_InitText,"(\d{3})").ToList This will split the string every tim…

If you dont mind using the .net split command directly in an Assign Activity, I suppose you could use the .NET Regex.Split Method [image] Regex.Split Method (System.Text.RegularExpressions) Splits an input string into an array of substrings at the positions defined by a regular expressi…

Hey Further to the previous post check out these links. Check here for Regex.Split [image] owl bookmark [CheatSheet] - System.Text.RegularExpressions | RegEx Tutorials This CheatSheet introduces the basic use of regex functions. With further examples also sp…

HI @Pathler Use matches activity to split your string as you expected click configure regular expression button and choose regex drop down as “Advanced” and enter value as (\d+\s+[A-Za-z\s-]+) [image] pass your input string in input tab and create output variable in result tab like Regex_out R…

[image] Pathler: 176 This is a sentence 180 this is another one, 109 - and this also Thanks but it doesnt solve the problem as it just extracts the Numbers, not the text.

HI @Pathler Check the below thread it may be helpful for your case [image] Split String by number Studio Here you go: Regex_Split.zip (5.6 KB) Regards, Nithin Regards Sudharsan

Hi @Pathler , You can do this by using Regex, creating a regex of only matches Digits and then using split with that regex. Thanks

Hey @Shikhar_Tandon , I’ve thought of that method. could you show me how this works with this example please?

Hi @Pathler , Just to clarify, from the sentence, where you want to extract only the digits or only the alphabets? We can achieve this through Regex Expression. To extract only the digits present in the string: \d+ To extract only the alphabets present in the string: \D+ To extract both alphabet…

[image] ignasi.peiris: System.Text.RegularExpressions.Regex.Split(var_InitText,"(\d{3})").ToList Hey @ignasi.peiris , thats almost it. Thanks a lot! im looking for a way to get a list like this: list = “176 This is a sentence”, “180 this is another”, “109 and this also” so how to combine num…

Good afternoon @Pathler ! There are numerous ways to achieve what you want, I’ll show you below one of them which is graphic, and a 2nd one which is more efficient: Disclaimer: Option 1 it’s not the only way, neither the best! In my opinion, is the most visual one to understand the steps. After …

Splitting String at multiple words

Help Something Else

Sudharsan_Ka (Sudharsan Ka) January 20, 2022, 12:36pm 6

HI @Pathler

Check the below thread it may be helpful for your case

Regards
Sudharsan

Topic		Replies	Views
REGEX SPLIT WITH NUMBERS AS THE DELIMITERS Studio activities	14	3939	September 1, 2020
Splitting the string Studio activities , studio	4	717	October 13, 2022
Split a string based on Regex Help activities , regex	49	24729	August 29, 2018
Extract a string using split, with strings as a delimiter Help activities	13	3463	July 1, 2019
Split String to characters and Numbers Help string	10	6946	January 23, 2019

Splitting String at multiple words

Related topics