Read X12 EDI 835 remittance files as tables, losslessly, with the findings as a table
Maintainer(s):
javillegasna
Installing and Loading
INSTALL oxedi FROM community;
LOAD oxedi;
Example
INSTALL oxedi FROM community;
LOAD oxedi;
-- Claims of one file, of several files, or of a glob
FROM read_835('remittance.835');
FROM read_835(['a.835', 'b.835'], filename := true);
FROM read_835('remits/*.835', table_name := 'services');
-- Findings of the parse (also for files that are not valid 835)
FROM read_835('remits/*.835', table_name := 'diagnostics', ignore_errors := true);
-- Text columns are VARCHAR; binary := true keeps the raw bytes
FROM read_835('remittance.835', binary := true);
-- Export to Parquet
COPY (SELECT * FROM read_835('remits/*.835', table_name := 'claims'))
TO 'claims.parquet';
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| read_835 | table | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.