Splitting A2 Cell Data into Columns and Rows

Help Studio
, , , , , , , , ,
1

Hi All,

Im getting all data into A2 cell from webpage. I just want split data into mutiple columns and rows using Collon(“:”). how can i create a workflow. below is the sample data.

Column-0
“DESC. 3:
REDEMPTION DATE: JANUARY 01, 2023
REDEMPTION PRICE: 1000.00000 INTEREST: 0.00000000:
MATURITY DATE: MAY 01, 2041 CODE:2:
COUPON: 3.500000 (APPLICABLE, NOT AVAILABLE)
DATED DATE: JULY 28, 2016
TYPE OF CALL: PARTIAL
PUBLICATION DATE: NOVEMBER 30, 2022 CALL AMOUNT: 56.00:
DEPO. 1: UTRUST,
DEPO. 2:
DEPO. 3: TEL. **”“”

ExpectedOutput
Column-0 Column-1 Column-2 Column-3
“DESC. 3
REDEMPTION DATE JANUARY 01, 2023
REDEMPTION PRICE 1000 INTEREST 0
MATURITY DATE MAY 01, 2041 CODE 2
COUPON 3.500000 (APPLICABLE, NOT AVAILABLE)
DATED DATE JULY 28, 2016
TYPE OF CALL PARTIAL
PUBLICATION DATE NOVEMBER 30, 2022 CALL AMOUNT 56
DEPO. 1 UTRUST,
DEPO. 2
DEPO. 3 TEL. **”“”

Thanks in Advance,
Niranjan

2

Hi @niranjan.kummara ,

Could you let us know how would you want this data to be represented in the Excel sheet ? If you could provide us with an Expected output format required we can work towards preparing the solution.

3

@supermanPunch In Excel A2 cell Im getting UiPath end output. same output in excel, I want to save final output into multiple Cells and Rows.

4

Hi @niranjan.kummara

Please provide and expected output from your input, based on that we would be able to make a solution

Regards!

5

@fernando_zuluaga Plese find the expected output

6

Give a try with

BlankProcess4 (2).zip (12.0 KB)

7

@niranjan.kummara

Please read the cell data into a variable str and then try using generate datatable activity…

You can copy the text and preview as well…configure your column separator as colon and row separator as new line character…

That should get the data into differnet columns and rows…please uncheck first row is not the headers…

https://docs.uipath.com/activities/docs/generate-data-table

Hope this helps

Cheers

1 Like
8

@fernando_zuluaga Add Data Row: Input array is longer than the number of columns in this table. Can you suggest me

9

@Anil_G Sure, I wil try

1 Like
10

@fernando_zuluaga Thank you, It is working

1 Like
11

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