Split String basde on a new line

Help Studio
, ,
1

Hello All
i’m Trying To Split a String based on a new Line
i Got These Generated Codes

Guid
Guid1920×1080 46 KB

i want To split one item For Every new line
Then i want to add it To a column already Created in a datatable

For Each Row in my Datatable should Have One Code
How Can I Do that ?

2

Hi @Karam_Abulawii

  1. Need to get the generated codes - use Screen scraping. or try to use Flowchart to get the codes.
  2. Use Assign Activity to split the codes (Site_List; Screen scraping variable)
    Variable Type: Array of String
    Split(Site_List,Environment.NewLine)

Hope it will work

Regards
Gokul

3

Thanks For the Reply
But in The assign
what in (to) Should be ?
array variable or What ?

4

@Karam_Abulawii

Yes, it should be of type Array of String.

1 Like
5

Thank You
but Theni want To add it to a column in my Data table
i got Column (GUID)
i want to store each index in that array in each Row in my Datatable
Can You Show what to Do or an Example ?
Thanks in Advance

6

Hi @Karam_Abulawii

Could you share me a screen shot of your workflow?

Regards

7

GuidCodeGenerator.xaml (17.1 KB)
Here is the Workflow Can you Do it For Me ?

8

Assignment_Generate JWT_Dispatcher.zip (1.0 MB)
and here’s my Dispatcher File so you Can See the Whole Proccess
and Feel Free To Modify it

9

Hi @Karam_Abulawii

Refer to the xaml modified xaml below!

GuidCodeGenerator.xaml (22.2 KB)

Regards

10

Thank you @pravin_calvin
But is splitting the generated codes with you ?

11

It’s not splitting the Generated Codes with me and it’s not writing anything in the Excel File

12

Hi @Karam_Abulawii

Check with your read datatable and write datatable excel path are same
So that it can update it accordingly in same file!

Get the Scraped value in write text file and Share it here!

Regards

13

MessageBox
MessageBox1920×1080 25.4 KB

Here is The Scraped Generated Codes

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!

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.