Hello, I have a text file that I want to upload into Oracle APEX to extract all the information and display it in a tabular format.
However, I'm facing the issue that all the information from a record appears in just one column.
CONTRACTORS REPORT 03.07.2023 09:29
01.06.2023 - 30.06.2023
T/S SHIP_NAME GRT BL_MT EOD POB FLA TLB C/P SHIPPER
---- -------------------- ------ ------ -------- -------- -------- -------- --- ----------------------------------------
160 YUAN NAN HAI 84127 146791 04:12/01 15:30/30 16:48/30 09:00/01 Y PENFIELD MARINE LLC
161 NORDIC TELLUS 80779 135599 20:06/01 14:00/31 15:18/31 00:00/02 Y SEARIVER MARITIME INC.
162 SEACALM 60142 89841 20:48/02 16:48/01 17:54/01 23:45/02 Y CHEVRON TANKER LIMITED
163 NORTH SEA 57164 80099 12:06/03 08:48/02 09:48/02 14:45/03 OMV SUPPLY & TRADING
164 AEGEAN VISION 81349 139168 13:42/04 08:54/03 09:48/03 16:00/04 Y UNIPEC
165 PRUDENT WARRIOR 81287 129978 23:36/05 12:00/04 13:00/04 02:00/06 Y VITOL
166 SEACHARM 60142 79958 01:30/07 23:42/05 00:42/06 04:00/07 SHELL INTERNATIONAL TRADING & SHIPPING
167 WONDER AVIOR 57062 83817 03:06/07 20:24/05 21:30/05 07:15/07 Y REPSOL
168 NORDIC HARRIER 80934 79035 05:12/08 08:48/07 09:42/07 07:30/08 Y VITOL
169 OHIO 57281 77981 09:48/09 08:30/08 09:30/08 12:30/09 OMV SUPPLY & TRADING
170 PROPONTIS 66919 77355 07:42/10 08:36/09 09:30/09 10:15/10 Y SEARIVER MARITIME INC.
171 MINERVA ASTRA 62762 84848 20:36/12 20:36/11 21:30/11 23:30/12 Y KAZMORTRANSFLOT LTD
172 MINERVA GLORIA 61341 84525 22:00/12 16:00/11 17:00/11 00:45/13 PHILLIPS 66
173 JAG LALIT 81396 48700 05:54/13 13:54/12 15:00/12 09:30/13 Y ENI TRADE & BIOFUELS S.P.A.
174 ELLI 62775 90297 05:18/14 18:00/12 18:48/12 09:00/14 Y TRAFIGURA MARITIME LOGISTICS PTE LTD
175 KRITI FUTURE 82987 80849 08:30/14 13:00/13 13:54/13 11:00/14 BAYEGAN DMCC
176 SILVER 60379 89720 01:30/16 20:24/14 21:18/14 04:00/16 UNITED MARITIME LOGISTICS M. E. DMCC
177 YUAN NAN HAI 84127 146664 04:30/16 15:00/14 16:12/14 07:30/16 PENFIELD MARINE LLC
178 ARISTOFANIS 62826 83379 05:36/17 00:06/16 01:12/16 09:00/17 SHELL INTERNATIONAL TRADING & SHIPPING
179 KRITI KING 81209 81152 19:36/17 16:06/16 17:06/16 22:15/17 BGN INTERNATIONAL DMCC
180 GREEN ADVENTURE 64314 89140 13:36/18 14:00/17 14:54/17 16:30/18 VITOL
181 OSLO TS 62557 103557 20:42/19 16:48/18 17:54/18 23:15/19 Y EQUINOR
182 KRITI SAMARIA 56347 79772 19:12/20 08:18/19 09:24/19 22:15/20 UNIPEC U.K. COMPANY LTD.
183 SEACHARM 60142 96577 20:48/20 16:00/19 17:12/19 23:18/20 OILMAR SHIPPING AND CHARTERING DMCC
184 SEAVIOLET 81349 56923 02:42/21 10:06/20 11:06/20 06:48/21 Y ENI TRADE & BIOFUELS S.P.A.
185 MINERVA KYTHNOS 61242 79932 04:06/25 20:30/23 21:24/23 06:30/25 Y ENI BIOFUEL & TRADE
186 IONIC ARIADNE 60435 94591 01:30/27 01:48/26 02:48/26 04:00/27 Y SEARIVER MARITIME INC.
187 ALYARMOUK 61342 91496 21:42/27 08:30/26 09:30/26 00:15/28 Y TRAFIGURA
188 SAFEEN BARONESS 55909 83350 20:18/28 08:48/27 09:54/27 22:30/28 Y ENI TRADE & BIOFUELS S.P.A.
189 WONDER AVIOR 57062 79972 03:18/29 00:45/28 01:54/28 06:00/29 Y REPSOL TRADING S.A.
190 MONIQUE GLORY 63673 98715 20:30/30 06:30/29 07:42/29 23:30/30 Y EXXONMOBIL
191 OSLO TS 62557 81238 22:54/30 21:30/29 22:36/29 02:30/01 Y EQUINOR
- the query that i am using to extract data:
SELECT line_number, col001, col002, col003, col004, col005, col006, col007, col008, col009, col010
FROM apex_application_temp_files F,
TABLE( apex_data_parser.parse(
p_content => F.blob_content,
p_add_headers_row => 'Y',
p_xlsx_sheet_name => '',
p_max_rows => 500000,
p_store_profile_to_collection => 'FILE_PARSER_COLLECTION',
p_file_name => F.filename
)
) P
WHERE F.NAME = :P13010_FILE ;
how i can solve the problem?