Split the data in to an array

[sreejith.ss]

Hi Community
Can anybody help me to split the data into an array
the sample data is in the Text file
random.txt (883 Bytes)

sample output is {“African”,"Allbanian…}
Thanks and Regards
Sreejith

[Gokul001 (Gokul Balaji)]

Hi @sreejith.ss

Try below code
arrvalue=strValue.Split(Environment.NewLine.ToArray, StringSplitOptions.RemoveEmptyEntries)

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Output @sreejith.ss

Use Read Text File activity and pass the output variable as strValue

Regards
Gokul

[Sanjit_Pal]

Hey @sreejith.ss,

Try the below code and let me know if it’s working for you.

stringVar.Split(Environment.NewLine.ToCharArray()).Where(function(x)  not string.IsNullOrWhiteSpace(x)).ToList()

Thanks,
Sanjit

[muthuraj.c (Muthuraj)]

Hi @sreejith.ss ,

Try This:
Str_text.Split(Environment.NewLine.ToCharArray).AsEnumerable().Where(Function(x) Not String.IsNullOrEmpty(x.ToString.Trim)).ToArray()

Xaml is attached

Str_to_Array.xaml (4.9 KB)

Thanks,
Muthuraj