How to loop through lists and split which has more than 2 or more spaces

Help
, ,
1

hello,Guys

1). first im storing entire pdf data by row wise in a form of List( of string)
2). then i’ve to get each row and split/remove spaces,i’ve got this result when i pass single row outside the loop, when i try it inside the for each im not able to get the result

ERROR:" Unable to cast object of type ‘System.Char’ to type ‘System.String’."

tried different approach and got error like “System.string”

thank you

2

@Pradeep_Shiv,

Just try with this linq query in an Assign activity.

Pass this in the right side of the assign activity and assign it to “yourListString” list(of String) in the left side.

yourListString.[Select](Function(t) System.Text.RegularExpressions.Regex.Replace(t, "\s+", "")).ToList()
3

it’s just displaying the Variable Type

4

ClearSpaceInList.xaml (5.9 KB)

Check this xaml, it is working for me without any issues.

5

i’ve to split only which has more than 2 spaces

6

ClearSpaceInList.xaml (8.1 KB)

Updated workflow as per the need, it has both functionalities, check and comment the unwanted one as per your need.

7

Sequence.xaml (7.4 KB)

see this file i’ve to iterate each row and split the spaces PDF1.pdf (307.9 KB)

1 Like
8

in Assign “Value” i’m getting particular row but i dont want to do that
ive to do in loop

9

any idea how to solve it???

10

@Pradeep_Shiv,

Do you want to split the PDF into each line and check for the double spaces to elimate?

11

yes,Exactly

12

Sequence.xaml (11.5 KB)

Check this one.

13

as you can see i’m getting the entire row which i dont want
if there is single space i want that whole thing as “Demo - slice invoices” after this there are more spaces so i need the next element “order number” and “12345”

14

you are replacing can we just split??

15

only delete the more spaces and iterate through all and get values

16

is it possible??

17

@Pradeep_Shiv

System.Text.RegularExpressions.Regex.split(YourInputString, “\s{2,}”)

1 Like
18

done this , its displaying as “system.string”

19

@Pradeep_Shiv
May I know where did you kept this code

You supposed to kept in for each
And for each arugment value is string in property pannel

20

for each itself…