Split char and add

Hi,
I have a list of Alphabets in an excel where it is like A,AB, BF so now i need to split each alphabet and get its ascii value and add it and save it the next column. now how do i split the value from AB

Hi @soumi_soumiya
use Split(“”.ToCharArray)

and check this

Thanks
Ashwin S

Thanks for your reply…
If i use this i am getting the variable type not the value ie i am getting “System.string”. How could i get the values

Hi @soumi_soumiya

try to do with string.join(“”,List3)

or loop the item with for each and check it

Thanks
Ashwin S

Thanks for your reply…
But cant get you

Hi @soumi_soumiya
You have a list of values right
use for each item in ListVar

Check whether you are able to print the item like A,AB,AC
and then try to split based on item

Thanks
AshwinS

I have declared in for each row as I am getting from excel and I am able to print A, AB, Ac but not I need to find the ASCII value for Each for I should split the value Of AB as A B separately I am not able to split i

Hi, you don’t even need to use split here. You can use the ToCharArray method. Note that it returns an array so you have to either loop through it to get the values or indicate the desired value’s position with an index.

var strAsArr = “AB”.ToCharArray
strAsArr(0) will return A in this case.

br,
Topi

1 Like

@soumi_soumiya

Create a variable array of (string ) variable name str_array

alphamix= “A,Ab,cb,DE”

str_array = split (alphamix,“,”)

use For Each item item ____________ Str_array

message box
item.tosting

1 Like