Split

[Yogita_Gaikwad]

Name1|Name2|Name3|Name4|Name5
abc 1 |abc2|abc3|abc4|abc5
pqr1 |pqr2|par3|pqr4|pqr5
lmn1|lmn2|lmn3|lmn4|lmn5

this my excel data and i want remove | and split data into columns

[Gokul001 (Gokul Balaji)]

Hi @Yogita_Gaikwad

Try with Regex expression

Use Assign activity

StrInput = System.Text.RegularExpressions.Regex.Replace(YourString.Trim,"\|","").Tostring.Trim

Use Generate Data table activity

Input => StrInput
Output → Create a new variable in the Output (DtOutput)

Regards
Gokul

[Yogita_Gaikwad]

StrInput = System.Text.RegularExpressions.Regex.Replace(YourString.Trim,“|”,“”).Tostring.Trim
can u tell mi which string i have to pass in YourString

[Gokul001 (Gokul Balaji)]

You String is nothing but Input string @Yogita_Gaikwad

[Sanjit_Pal]

Hey @Yogita_Gaikwad,

Have a look on the attached xaml.
DataTableManipulation.xaml (15.3 KB)

Thanks,
Sanjit