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
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
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
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?
("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…
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.