Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Uploading Data from a TXT File into a Tabular Format

zoulfikar fahsJan 4 2024

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.

  • the file .txt

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 ; 
  • the result:

how i can solve the problem?

This post has been answered by zoulfikar fahs on Jan 4 2024
Jump to Answer
Comments
Post Details
Added on Jan 4 2024
3 comments
89 views