Generate a datatable from a string

[Tanmay_V_Chetule]

Sample Input String :
• Ronaldo
• Messi
• Bavuma
• Pique

I need to generate a datatable with one column and 4 rows without the bullet point.

[Anil_G (Anil Gorthi)]

@Tanmay_V_Chetule

Use a replace first to replace dots and then use a generate datatable with cav prsing

Cheers

[Vinit_Kawle]

Hi @Tanmay_V_Chetule ,

Thanks for reaching out UiPath Community.

You can follow below steps:

1. Replace Dots with empty strings.
   
2. Split the String with Space and Store it in an Array of strings.
   
3. Use Build Data Table.
   
4. Use For Each Activity to iterate and Use add data row to add a row in the data table.
   
   
5. After completion you can use Outputdatable to Get Output.
   

Hope This works for you.

Happy Automation,
@Vinit_Kawle

[Parvathy (PS Parvathy)]

Hi @Tanmay_V_Chetule
=> Use the below in Assign activity:

inputString= "• Ronaldo 
              • Messi 
              • Bavuma 
              • Pique"

=> Use the below code in Invoke Code activity:

inputString = inputString.Replace("• ", "")
YourDataTable = New System.Data.DataTable("PlayerData")
YourDataTable.Columns.Add("PlayerName", GetType(String))

For Each player In inputString.Split(Environment.NewLine.ToCharArray, StringSplitOptions.RemoveEmptyEntries)
    YourDataTable.Rows.Add({player.Trim()})
Next

=> In the Edit Arguments option give in the below way:

=> Use Output Data Table activity and pass the datatable and store the output
=> Print it in Message Box

Attached the workflow for better understanding:
Sequence1.xaml (9.1 KB)

Hope it helps!!

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Tanmay_V_Chetule ,
You can replace line breaks to spaces
my input/output

we need change only default to

hope it help
my source
ExcelActivity.zip (9.1 KB)

regards,

[ppr (Peter Preuss)]

As An alternate (one of many other options)

• we split the string
• use collection to datatable activity
  Activities - Collection to Data Table
• rename columnname
  Assign activity | yourDTVar.Columns(0).TableName = “NewName”

OR

• use generate Datatable