Problem in output of excel

buddy your csv may be like this
with comma delimiter
abc,def,ghi,jkl
abc,def,ghi,jkl
or
with pipeline delimiter
abc|def|ghi|jkl
abc|def|ghi|jkl

here the delimiter is the separator between two strings buddy
like wise how you csv actually looks like
@priyankavivek

the datas in csv file are having datas like bvc/hjg/7899/567 is that problem?or any other reason as i cannot share that file sorry for that.

1 Like

buddy is that a forward slash like this /
or a pipeline symbol like this |
Cheers @priyankavivek

only these delimiters are supported buddy
image

or we need to use generate data table if it is having a delimiter as forward slash /
once you click on this
image
you will be taken here where you have mention the delimiter buddy.

and with the generated datatable you can compare and the get the output buddy
Cheers @priyankavivek

Did that help you create a datatable buddy @priyankavivek

sorry for late reply,now only iam going to check that!

1 Like

Fine
Try and let know buddy
Cheers @priyankavivek

slash

any issue buddy @priyankavivek

how can i use the generate datatable activity?

this could help you buddy
https://activities.uipath.com/docs/generate-data-table

1 Like

buddy generate datatable is like we need to pass the unstructured string as input and we will be getting an output of type datatable
so here we need to pass the input as string and not as datatable buddy
Cheers @priyankavivek