How to genrate text to excel

Help Activities
, ,
1

text file

Dealer Code : C53 Account No : ABCH0002M CDS No: 062062286 *ABC INTERNET HOLDINGS SDN BHD SBL :

Stock No Stock Name Pledged Purchased Total Market Market Capped Capped Margin Margin
Qty Qty Qty Price Value % Price Value %

0138 MYEG 359,560,432 15,609,000 375,169,432 1.0500 393,927,903.60 90 .9450 354,535,113.24 100.000
Total equity 393,927,903.60 354,535,113.24

Reference Stock Trx Date Due Date Quantity Trade Trx Amount No.of Interest
Number Price Days

                                                           CREDIT ITEMS

Cash 42.21-
Total Credit Items 0 42.21- .00

                                                   CURRENT CONTRACTS (NOT DUE)

Total Current Contracts 0 .00 .00

                                                    DUE OUTSTANDING CONTRACTS

CNB 03019423 MYEG 14/05/2020 18/05/2020 1,270,500 1.2874 1,641,396.07 608 3,709.97
CNB 03019744 MYEG 15/05/2020 19/05/2020 1,000,000 1.2900 1,294,689.20 607 2,926.33
CNB 03021407 MYEG 27/05/2020 29/05/2020 779,100 1.2800 1,000,918.42 595 2,262.37
CNBD03021408 MYEG 27/05/2020 29/05/2020 3,187,900 1.4800 4,726,793.77 595 10,683.86
CNB 03044000 MYEG 4/08/2020 6/08/2020 1,771,500 1.3477 2,395,958.88 526 5,415.52
CNB 03044392 MYEG 5/08/2020 7/08/2020 2,000,000 1.4650 2,940,396.40 525 6,646.09
CNB 03045252 MYEG 6/08/2020 10/08/2020 2,000,000 1.5004 3,011,442.78 524 6,806.69
CNBD03045253 MYEG 6/08/2020 10/08/2020 3,000,000 1.4800 4,448,259.60 524 10,054.33
CNB 03123460 MYEG 2/04/2021 6/04/2021 600,000 1.9900 1,198,355.12 285 2,708.64
Total O/S Contracts 15,609,000 22,658,210.24 51,213.80

                                                           DEBIT BILLS

BLRD00311788 11/09/2017 0/00/0000 0 .0000 48,227,981.24 1,584 109,008.46
BLRO00334423 19/05/2020 0/00/0000 0 .0000 123,150.37 603 352.55
BLRM00334693 2/06/2020 0/00/0000 0 .0000 12,500.00 589 35.75
BLRD00334694 2/06/2020 0/00/0000 0 .0000 5,000,000.00 589 11,301.40
BLRM00334749 3/06/2020 0/00/0000 0 .0000 4,500.00 588 12.87
BLRM00334750 3/06/2020 0/00/0000 0 .0000 11,795.23 588 33.77
BLRM00335917 7/08/2020 0/00/0000 0 .0000 11,100.00 523 31.79
CA 00659884 MYEG-C88 7/10/2020 0/00/0000 0 .0000 1,384,133.60 462 3,962.75
CA 00659928 MYEG-C87 8/10/2020 0/00/0000 0 .0000 206,145.00 461 590.15
BLHC00337578 28/10/2020 0/00/0000 0 .0000 10.00 441 .00
BLSD00337579 28/10/2020 0/00/0000 0 .0000 10.00 441 .00
BLRO00338038 13/11/2020 0/00/0000 0 .0000 186,719.59 425 534.60
BLRO00340076 11/02/2021 0/00/0000 0 .0000 89,816.83 335 257.18
BLRO00342182 12/05/2021 0/00/0000 0 .0000 186,719.59 245 534.60
BLSD00344590 1/09/2021 0/00/0000 0 .0000 10.00 133 .00
BLHC00344591 1/09/2021 0/00/0000 0 .0000 10.00 133 .00
BLIM00345689 30/09/2021 0/00/0000 0 .0000 .00 104 270.58
BLIM00346870 31/10/2021 0/00/0000 0 .0000 397,583.13 73 1,409.81

BLRO00347211 5/11/2021 0/00/0000 0 .0000 189,715.48 68 543.18
BLIM00348210 30/11/2021 0/00/0000 0 .0000 495,790.08 43 1,419.44
BLIM00350085 31/12/2021 0/00/0000 0 .0000 513,573.40 12 668.35
Total Debit Bills 0 57,041,263.54 130,967.23

Total Outstanding 15,609,000 79,699,473.78 182,181.03

                                                              SUMMARY

Equity (Market Value) : 393,927,903.60 Equity Ratio (Market): 493.13 Approved Credit Limit: 80,000,000.00
Equity (Capped Value) : 354,535,113.24 Equity Ratio (Capped): 443.82 Commencement Date : 6/09/2017
Other Coll (Face value) : .00 Approved Equity Ratio: 250.00 Renewal Date : 3/02/2022
Other Coll (Capped) : .00 Accumulated Interest : 182,181.03 Account status :OK
Outstanding Balance Due : 79,699,473.78
Cash Available : 42.21-
Total Outstanding Balance: 79,881,654.81 Available Trading Limit: 118,345.19
Cash Surplus : 42.21CRShare Surplus : 154,831,018.42CR Forcesell : .00
(CR) / Shortfall (CR) / Shortfall

Dealer Code : C53 Account No : AJA0001M CDS No: 070967948 *MR CHIAU HONG YEW SBL :

Stock No Stock Name Pledged Purchased Total Market Market Capped Capped Margin Margin
Qty Qty Qty Price Value % Price Value %

Borrower’s Account: AJA0001M
3395 BJCORP 5,400 69,994,600 70,000,000 .2450 17,150,000.00 90 .2205 15,435,000.00 40.824
Total equity 17,150,000.00 15,435,000.00
Pledgor’s Account: BVT0004P
3239 BJASSET 15,000,000 0 15,000,000 .2600 3,900,000.00 90 .2340 3,510,000.00 9.284
Total equity 3,900,000.00 3,510,000.00
Pledgor’s Account: PRH0003P
3239 BJASSET 21,000,000 0 21,000,000 .2600 5,460,000.00 90 .2340 4,914,000.00 12.997
3395 BJCORP 15,000,000 0 15,000,000 .2450 3,675,000.00 90 .2205 3,307,500.00 8.748
5196 BJFOOD 5,500,000 0 5,500,000 2.1500 11,825,000.00 90 1.9350 10,642,500.00 28.148
Total equity 20,960,000.00 18,864,000.00
Total equity (Borrower + Pledgor) 42,010,000.00 37,809,000.00

Reference Stock Trx Date Due Date Quantity Trade Trx Amount No.of Interest
Number Price Days

                                                           CREDIT ITEMS

Pledgor’s Account: PRH0003P
Cash 163,963.65-
Total Credit Items 0 163,963.65- .00
Total Credit Items (Borrower + Pledgor) 0 163,963.65- .00

                                                   CURRENT CONTRACTS (NOT DUE)

Total Current Contracts 0 .00 .00

                                                    DUE OUTSTANDING CONTRACTS

CNBM03120846 BJCORP 24/03/2021 26/03/2021 69,994,600 .2800 19,630,810.26 294 44,371.87
Total O/S Contracts 69,994,600 19,630,810.26 44,371.87

                                                           DEBIT BILLS

BLRO00349303 17/12/2021 0/00/0000 0 .0000 .00 26 76.62
Total Debit Bills 0 .00 76.62

Total Outstanding 69,994,600 19,630,810.26 44,448.49

                                                              SUMMARY

Equity (Market Value) : 42,010,000.00 Equity Ratio (Market): 214.35 Approved Credit Limit: 20,000,000.00
Equity (Capped Value) : 37,809,000.00 Equity Ratio (Capped): 192.99 Commencement Date :24/03/2021
Other Coll (Face value) : .00 Approved Equity Ratio: 200.00 Renewal Date :17/03/2022
Other Coll (Capped) : .00 Accumulated Interest : 44,448.49 Account status :MGN BR
Outstanding Balance Due : 19,630,810.26
Cash Available : 163,963.65-

Total Outstanding Balance: 19,675,258.75 Available Trading Limit: .00
Cash Surplus : 688,776.93 Share Surplus : 1,377,553.85 Forcesell : 1,377,553.85
(CR) / Shortfall (CR) / Shortfall

Dealer Code : C53 Account No : HNM0001M CDS No: 056490105 *HANAMURA CORPORATION BERHAD SBL :

Stock No Stock Name Pledged Purchased Total Market Market Capped Capped Margin Margin
Qty Qty Qty Price Value % Price Value %

Borrower’s Account: BCB0001M
1562 BJTOTO 1,765,009 4,500,000 6,265,009 1.9000 11,903,517.10 100 1.9000 11,903,517.10 13.106
4219 BJLAND 24,308,500-127,516,500 103,208,000 .2200 22,705,760.00 90 .1980 20,435,184.00 25.000
5250 SEM 2,510,000 0 2,510,000 1.4800 3,714,800.00 90 1.3320 3,343,320.00 4.090
Total equity 38,324,077.10 35,682,021.10
Pledgor’s Account: BGB0001P
1562 BJTOTO 1,000,000 0 1,000,000 1.9000 1,900,000.00 100 1.9000 1,900,000.00 2.092
5196 BJFOOD 7,000,000 0 7,000,000 2.1500 15,050,000.00 90 1.9350 13,545,000.00 16.571
Total equity 16,950,000.00 15,445,000.00
Pledgor’s Account: JSS0002P
0032 REDTONE 17,632,692 0 17,632,692 .4500 7,934,711.40 50 .2250 3,967,355.70 8.736
4219 BJLAND 80,522,904 0 80,522,904 .2200 17,715,038.88 90 .1980 15,943,534.99 19.505
Total equity 25,649,750.28 19,910,890.69
Pledgor’s Account: TMS0003P
4219 BJLAND 45,000,000 0 45,000,000 .2200 9,900,000.00 90 .1980 8,910,000.00 10.900
Total equity 9,900,000.00 8,910,000.00
Total equity (Borrower + Pledgor) 90,823,827.38 79,947,911.79

Reference Stock Trx Date Due Date Quantity Trade Trx Amount No.of Interest
Number Price Days

                                                           CREDIT ITEMS

Borrower’s Account: BCB0001M
Cash 3.61-
Total Credit Items 0 3.61- .00
Total Credit Items (Borrower + Pledgor) 0 3.61- .00

                                                   CURRENT CONTRACTS (NOT DUE)

Total Current Contracts 0 .00 .00

                                                    DUE OUTSTANDING CONTRACTS

CNBD02306803 BJLAND 9/09/2013 12/09/2013 15,516,500 .8900 13,831,241.68 3,047 33,517.12
CNBD03119041 BJLAND 19/03/2021 23/03/2021 112,000,000 .1800 20,182,569.60 299 48,659.38
CNBD03119040 BJTOTO 19/03/2021 23/03/2021 4,500,000 2.1500 9,686,455.50 299 23,353.66
Total O/S Contracts 132,016,500 43,700,266.78 105,530.16

                                                           DEBIT BILLS

BLIM00350089 31/12/2021 0/00/0000 0 .0000 .00 12 233.07
Total Debit Bills 0 .00 233.07

Total Outstanding 132,016,500 43,700,266.78 105,763.23

                                                              SUMMARY

Equity (Market Value) : 90,823,827.38 Equity Ratio (Market): 207.33 Approved Credit Limit: 45,000,000.00
Equity (Capped Value) : 79,947,911.79 Equity Ratio (Capped): 182.50 Commencement Date : 1/08/2013
Other Coll (Face value) : .00 Approved Equity Ratio: 200.00 Renewal Date : 1/03/2022
Other Coll (Capped) : .00 Accumulated Interest : 105,763.23 Account status :MGN BR
Outstanding Balance Due : 43,700,266.78
Cash Available : 3.61-
Total Outstanding Balance: 43,806,030.01 Available Trading Limit: .00
Cash Surplus : 3,832,072.31 Share Surplus : 7,664,144.62 Forcesell : 7,664,144.62
(CR) / Shortfall (CR) / Shortfall

Dealer Code : C53 Account No : BBB0001M CDS No: 070548391 *BAROS BIN BANARUDIN SBL :

Stock No Stock Name Pledged Purchased Total Market Market Capped Capped Margin Margin
Qty Qty Qty Price Value % Price Value %

Borrower’s Account: BNM0001M
5673 IPMUDA 6,243,900 0 6,243,900 1.8100 11,301,459.00 80 1.4480 9,041,167.20 87.402
Total equity 11,301,459.00 9,041,167.20
Pledgor’s Account: NAS0007P
5673 IPMUDA 900,000 0 900,000 1.8100 1,629,000.00 80 1.4480 1,303,200.00 12.598
Total equity 1,629,000.00 1,303,200.00
Total equity (Borrower + Pledgor) 12,930,459.00 10,344,367.20

Reference Stock Trx Date Due Date Quantity Trade Trx Amount No.of Interest
Number Price Days

                                                           CREDIT ITEMS

Total Credit Items (Borrower + Pledgor) 0 .00 .00

                                                   CURRENT CONTRACTS (NOT DUE)

Total Current Contracts 0 .00 .00

                                                    DUE OUTSTANDING CONTRACTS

Total O/S Contracts 0 .00 .00

                                                           DEBIT BILLS

BLMS00340622 5/03/2021 0/00/0000 0 .0000 35,110.00 313 100.54
BLMF00340623 5/03/2021 0/00/0000 0 .0000 70,000.00 313 200.42
BLPS00340776 16/03/2021 0/00/0000 0 .0000 4,245,852.00 302 8,317.21
BLIM00345704 30/09/2021 0/00/0000 0 .0000 23,670.44 104 67.76
BLIM00346885 31/10/2021 0/00/0000 0 .0000 24,640.28 73 70.51
BLIM00348240 30/11/2021 0/00/0000 0 .0000 23,849.15 43 68.31
BLTF00349531 23/12/2021 0/00/0000 0 .0000 10.00 20 .00
BLIM00350100 31/12/2021 0/00/0000 0 .0000 24,832.49 12 32.30
Total Debit Bills 0 4,447,964.36 8,857.05

Total Outstanding 0 4,447,964.36 8,857.05

                                                              SUMMARY

Equity (Market Value) : 12,930,459.00 Equity Ratio (Market): 290.12 Approved Credit Limit: 5,000,000.00
Equity (Capped Value) : 10,344,367.20 Equity Ratio (Capped): 232.10 Commencement Date : 1/03/2021
Other Coll (Face value) : .00 Approved Equity Ratio: 200.00 Renewal Date :22/02/2022
Other Coll (Capped) : .00 Accumulated Interest : 8,857.05 Account status :OK
Outstanding Balance Due : 4,447,964.36
Cash Available : .00
Total Outstanding Balance: 4,456,821.41 Available Trading Limit: 543,178.59
Cash Surplus : .00 Share Surplus : 1,430,724.38CR Forcesell : .00

(CR) / Shortfall (CR) / Shortfall

MIDF AMANAH INVESTMENT BANK SILVERLAKE Universal Broking System 12/01/2022 7:20:57
BRANCH : 1 Margin Client Detail Report PIBRAHIM DSPMBJOBD
SMR00103C As At 11/01/2022 PAGE : 9
Dealer Code : C53 Account No : DVC0001M CDS No: 062763669 *DVD CAPITAL SDN BHD SBL :

Stock No Stock Name Pledged Purchased Total Market Market Capped Capped Margin Margin
Qty Qty Qty Price Value % Price Value %

7206 THHEAVY 0 2,000,000 2,000,000 .0000 .00 .0000 .00 .000
7212 DESTINI 5,345,200 0 5,345,200 .2150 1,149,218.00 80 .1720 919,374.40 100.000
Total equity 1,149,218.00 919,374.40

Reference Stock Trx Date Due Date Quantity Trade Trx Amount No.of Interest
Number Price Days

                                                           CREDIT ITEMS

Cash .85-
Total Credit Items 0 .85- .00

                                                   CURRENT CONTRACTS (NOT DUE)

Total Current Contracts 0 .00 .00

                                                    DUE OUTSTANDING CONTRACTS

CNB 03042453 THHEAVY 28/07/2020 30/07/2020 2,000,000 .1350 271,139.60 533 694.54
Total O/S Contracts 2,000,000 271,139.60 694.54

                                                           DEBIT BILLS

CA 00652496 PLS 16/03/2020 0/00/0000 0 .0000 6,024.47 667 17.27
CA 00652495 DESTINI 16/03/2020 0/00/0000 0 .0000 74,718.97 667 213.95
BLIM00344484 31/08/2021 0/00/0000 0 .0000 2,667.86 134 7.59
BLIM00345676 30/09/2021 0/00/0000 0 .0000 2,541.36 104 7.26
BLIM00346857 31/10/2021 0/00/0000 0 .0000 2,646.85 73 7.59
BLRO00347162 2/11/2021 0/00/0000 0 .0000 677.85 71 1.98
BLIM00348226 30/11/2021 0/00/0000 0 .0000 2,584.95 43 7.37
BLIM00350072 31/12/2021 0/00/0000 0 .0000 2,694.53 12 3.50
Total Debit Bills 0 94,556.84 266.51

Total Outstanding 2,000,000 365,696.44 961.05

                                                              SUMMARY

Equity (Market Value) : 1,149,218.00 Equity Ratio (Market): 313.43 Approved Credit Limit: 10,000,000.00
Equity (Capped Value) : 919,374.40 Equity Ratio (Capped): 250.74 Commencement Date :28/02/2018
Other Coll (Face value) : .00 Approved Equity Ratio: 250.00 Renewal Date :31/01/2022
Other Coll (Capped) : .00 Accumulated Interest : 961.05 Account status :OK
Outstanding Balance Due : 365,696.44
Cash Available : .85-
Total Outstanding Balance: 366,657.49 Available Trading Limit: 1,821.01
Cash Surplus : .85CRShare Surplus : 2,731.52CR Forcesell : .00
(CR) / Shortfall (CR) / Shortfall

                                                       ** End of Listing**
2

Hi @Space_Lover,

Try Generate datatable from text activity.

https://docs.uipath.com/activities/other/latest/user-guide/generate-data-table

Hope it helps.

3

thanks brother

4

i did until generate datatable activity after this what need to do please reply ,and lot of people telling different method please tell me the direct way harshith

5

@shreeabhi586 ,
Suppose if the input text is in the Text file then you will read the text using “Read text file” Activity and the output will be stored in an “String” Variable.
Then in order to convert this string variable to data table you have to use “Genarate Data Table” Activity.
Inside the “generate Dat Table Activity” You can do the required configuration Example :

image
image886Ă—633 30.1 KB

From the data table you can use "Write range " Activity to write the data table in the Excel.

Regards,

1 Like
6

thank you so much i have done it but i have one question is this question do we need to use the notepad++ because i scare in interview they will ask such question and wait i will send something to you sir please explain sir

7

This test will require you to perform Http Request using UiPath Request Builder Wizard followed by Deserialization of the Json data you have extracted from the web portal.
Your main objective is to extract the player’s profile (basic data) from the website NBA Players & Team Rosters | NBA.com.
Note that you are not restricted to extracting the data via json. There are many options you can opt for.

image
image1600Ă—850 91.8 KB

thisquestion is about web portal automation is it>? sorry sir in interview they will ask question like what i understand from this and what i need to do…
My answer will be like below:

Hi sir this question is about http request (its a api web automation) i need to make bot to extract the data from the web portal do correct me if am wrong … and for this i need to use json for each activity

8

Ok both i need to insert newline ok sir