Split String basde on a new line

Help Studio
, ,
14

Hi @Karam_Abulawii,

  • I use dummy values with Enviornment.Newline to seperate them and then convert the string (scrapped string in your case) to an array.

  • Build a datatable (OutputDatatable) where I can store the items of the array in a column named GUID.

  • Iterate through the items in the array. Add data rows to OutputDatatable and pass the item of the array in the loop.

  • Output will be your GUIDs in a datatable.

image
image938×764 23.2 KB

Hope this helps clear your doubt. Always try to break the automation into smaller steps and find alternative ways to achieve each of the steps. This will help you reuse smaller chucks of your code in other problems as well.

Here is the sample xaml file: SpiltTextNewLineToDataTable.xaml (9.4 KB)

Goodluck!