How to extract specific part from a string using specific separator and add those string in an array/collection and loop through it

Learning Hub Academy Feedback
1

Hi Team,

I have a string like this :- ‘18-25’!C11 + ‘18-25’!C57 - ‘18-25’!C86
The specific part of the string is separated by + or - … Here we can have any number of separators here which is + or -.

I have to extract the string on the basis or + or - and add that part in an array and collection and will loop through array
for ex:- for string ‘18-25’!C11+‘18-25’!C57-‘18-25’!C86
I get 3 extracted strings which is :- ‘18-25’!C11 , ‘18-25’!C57 and 18-25’!C86

Now I have to add these strings in an array or collection.so that the first item will be to loop through is ‘18-25’!C11 , second will be ‘18-25’!C57 and the third will be 18-25’!C86.
Here the main string will be of any length, here in this case I get 3 sub - strings but it can be more also.

Please help

2

Would the + or - you want to split the string on, always be before a single quote ( ’ )?

3

Hi ,

Can you try using these statements in Assign activity

Str var = “‘18-25’!C11+‘18-25’!C57-‘18-25’!C86”
Array = str.Split(new String(){“+'”,“-'”}, StringSplitOptions.None)

4

I want to split on the basis on of + or - not necessary that it will be before (')

5

In your sample string: ‘18-25’!C11+‘18-25’!C57-‘18-25’!C86, how would you differentiate between the ‘-’ in ‘18-25’ and ‘C57-‘18’ ?

6

Hi , I have implemented it . It is not giving me the desired result

7

Please change that Quotes . The Copy paste may be different.
Also share the output you are getting.

8

Yes I noticed the same too, this is the challenge here

9

@Karan28
as an alternate you can give a try to RegEx:
grafik
'\d+[-,+]{1}\d+'![A-Z,\d]+

grafik

find starter help here:
Sequence2.xaml (5.6 KB)

10

Thankyou so much for this solution

11

Hey I have checked it and its working absolutely fine , but in my case the main string can change a little bit so if you can give me solution on that then it will be a dynamic solution for me.
Like my string can be like this too :- schedule!C11+CFS!C57-karan!C86+verse!C86
I mean the say the string before “!” can change which is schedule in this case schedule!C11
and was ‘18-25’ in earlier case - ‘18-25’!C11+‘18-25’!C57-‘18-25’!C86

your solution works absolutely fine in this case but can you make it more dynamic s0 that it should work in second case too

12

maybe following will work

grafik
grafik729×146 4.18 KB

(+|-)?([A-Z,a-z,\d,',-]+![A-Z\d]+)

you will refer to group 2
grafik

for working with groups have a look here:

1 Like
13

Hey I am getting this error for this ,
Screenshot (87)

14

@Karan28
It passed the tests at my end. Have a look here:
Karan_TestMatches.xaml (6.5 KB)

grafik

15

Hey , This solution works and this solution is so magnificent and you are so technically strong man. Bravo!!

1 Like
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.