String manipulation of string to data table

[RACHEL_PAUL]

Hi, i am extracting a text from an application using get text activity in the form of string in the below format
example:
EGM
Whole Structure
Load Model
Primary load

I need to convert this string into a data table. The text will vary every time.

Can you help me achieve this?

[rlgandu (Rajyalakshmi Gandu)]

@RACHEL_PAUL

Use generate datatable from text activity

[Parvathy (PS Parvathy)]

Hi @RACHEL_PAUL

Try this:

dtExtractedText = (From line In YourStringVariable.Split({Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)
                   Select dtExtractedText.Rows.Add(line)).CopyToDataTable()

Hope it helps!!

[lrtetala (Lakshman Reddy)]

@RACHEL_PAUL

EGM
Whole Structure
Load Model
Primary load

Hi @RACHEL_PAUL

Try this

Regards,

[pravallikapaluri]

Hi @RACHEL_PAUL

Use Generate datatable from text activity .
Use the Seperator as newline

[RACHEL_PAUL]

Got it the output.

Thanks so much!