How can we split

Hi
abcdeggh . sdfghjktufygh . sdfghjyughkj
I want to divide this line into three columns
(abcdeggh) this part is to be written in column A and
sdfghjktufygh this part in column B and
sdfghjyughkj and this part is to be written in column C
i want to split with dot how can i do it

HI @Sweety_Nagar

You can try this

Var1=abcdeggh . sdfghjktufygh . sdfghjyughkj

Now use add data row in array of row you give like this

{Split(Var1,“.”)(0).Tostring,Split(Var1,“.”)(1).Tostring,Split(Var1,“.”)(2).Tostring}

Regards
Gokul

Hi @Sweety_Nagar
let me share you a sample with your input itself

Sequence1.zip (1.2 KB)

hope this helps

Hi
Thanks for reply
I get value in get text activity and one by one value comes in for each row I have to use assign activity to split this value and later write the same variable name in add data row
But the method you have mentioned is not working.

Okay so can share the SS of the input

Keep message box after the get text and pass the get text var to the message box share the SS

Regards
Gokul

image


it showing this error.
I have written the function of split in assign activity with this method for three values
And this is the variable name I have written in add data row but error is coming

HI @Sweety_Nagar

Can to share the input for secLine variable

Regards
Gokul

Hi
image
This is the output of sec line variable name

So if you see your output you have a space in between

So use like this and let me know if get any values

{Split(Var1," . “)(0).Tostring,Split(Var1,” . “)(1).Tostring,Split(Var1,” . ")(2).Tostring}

Regards
Gokul

Hi
Can we write this method in different different assign activity for three values and sec line variable name is to be written in that assign activity
Because I tried what you told but error is coming.

Yes Sure You can also assign in different variable and use them in add data row

Hi @Sweety_Nagar ,

Is this what you were looking for?

SplitExercise.xaml (7.4 KB)

Kind Regards,
Ashwin A.K

Hi
I am using all methods , but this is not working.
it is showing error again and again.

Hi @Sweety_Nagar ,

You wanted to add the items to a DataTable, correct?

image

image

image

("abcdeggh . sdfghjktufygh . sdfghjyughkj").Split({" . "},StringSplitOptions.RemoveEmptyEntries).ToList()
lst_checkValues.ToArray()

I was able to perform the operation, could you please have a look at the xaml shared above?

Kind Regards,
Ashwin A.K

not sure if the screenshot is from the webpage/app…

grafik
we do see a splitting char similar to a dot but in the middle level of the line. Also, we do see a dot on the end. This looks like the split char is different to a dot.

You can check within the immediate panel with Asc(yourstring(indexToTheChar)) the char code for this. The found char code we can later use for the split method

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

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