Generate Data Table from Text works in preview but not when running bot

Help StudioX
,
1

I have Pipe Delimited Data exported from ERP to Clipboard. When i pull it in, using ‘get from clipboard’, and use the ‘Generate Data Table From Text’ activity to delimitate by piple to create a DataTable i’m running into the following issue.

Im using this activity

image
image1224×476 42.5 KB

Below are the settings. The Test Preview Panel is exactly what im looking for in the output of the data.

image
image1255×807 88.4 KB

However the problem happens when i run the bot. for some unknown reason UI path changings the pipe to comma and does not deliminate. No idea why

image
image775×382 37.9 KB

any idea why the preview is not what is actually outputting?

2

Hello @Waterfowl_Waterfowl_hunte ,
Write the Copied data from the Clipboard to the Text file. Based on the delimiter, you can change the Properties of activity. Otherwise, try changing the Region settings. Refer to this thread, it may help you

3

Please try and write the datatable to a file for final output. The preview in the Generate DT table activity should be correct. When you run in debug mode and view a variable from the Locals panel UiPath displays the object as best it can - for datatables it will always show values separated by commas although when you write it to a file it will retain the specified delimiter.

4

Im sorry lewis, i hope this isnt a stupid question. What type of file should i write the data table to? Note? Could you recommend an activity to use please?

5

Hey, no problem - try and write it to whatever file type would be most convenient for your scenario. This could be a .csv so you can open in a text editor or Excel, or .xlsx if Excel format is preferred.