How to segregate the data line by line

[BNK (nirmal)]

I have below mention data

Ex:

Bala
4,satha st,
gobi
erode .
tamilnadu
robotic process automation-UiPath

I want to segregate the above data line by line and need to excel.

[postwick (Paul Ostwick)]

Split(yourVar,VbCrLf)

This will give you an array with one element for each line.

[rlgandu (Rajyalakshmi Gandu)]

@BNK

Hello ,

linesArray = inputText.Split({Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)

[lrtetala (Lakshman Reddy)]

@BNK

Bala
4,satha st,
gobi
erode .
tamilnadu
robotic process automation-UiPath

Hi @BNK

Can you try this

Final.xlsx (6.2 KB)

Cheers!!

[BNK (nirmal)]

I want to write column by column

[lrtetala (Lakshman Reddy)]

@BNK

Can you please provide output what you want

[vrdabberu (Varunraj Dabberu)]

Hi @BNK

→ Read Text File

Output-> str_Text
→ Build DataTable

Output-> dt_Output
→ use below syntax in Assign:

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

dt_Output datatype System.Data.DataTable
→ Write Range Workbook

Sequence11.xaml (9.7 KB)

Regards

[BNK (nirmal)]

Expected output

[BNK (nirmal)]

expected output

[vrdabberu (Varunraj Dabberu)]

Hi @BNK
→ Read Text File

Output->str_text
→ Use the below syntax in Assign:

lines= str_Text.Split({Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)

lines is of Array(System.String)
→ Use below syntax in assign:

Output= String.Join("/",lines)

Output is of DataType System.String
→ Generate DataTable from Text

→ Write Range Workbook

Sequence11.xaml (11.2 KB)

Regards

[lrtetala (Lakshman Reddy)]

@BNK

How about the following?

Input.Split({vbCrLf, vbLf}, StringSplitOptions.RemoveEmptyEntries)

Final.xlsx (6.1 KB)

Sequence1.xaml (12.9 KB)

Cheers!!

[BNK (nirmal)]

I have all the input data in excel.
Pleas check the attached
Output - Copy.xlsx (7.9 KB)
excel

expected output