Delimited Extract (Table Extract Method)
Delimited Extract is one of the Extract Method options for Data Table objects in a Data Model. This method extracts tabular data from a delimited text file, such as a CSV file.
About
A delimited text file is, effectively, a table of information saved to a simple text format. Rows in the table are easy to represent in a text file. Each row is a new line in the file. Columns are little trickier. They are represented by a "delimiter" character. This character is used to define where the table columns are in the text file.
For example, CSV (comma-separated values) files use a comma (,) as a delimiter. When opened in a spreadsheet program, such as Microsoft Excel or Google Sheets, these files look like standard spreadsheets. So, a CSV file with a table with some generic information collected for individuals might look something like the table below.
| First Name | Last Name | SSN | Favorite Animal | |
| Aaron | Aaronson | aaron@example.com | 987-65-4321 | aardvark |
| Billy | Billiamson | 999-88-7777 | billy goat | |
| Cathy | Catherton | cat@example.com | 900-00-1234 | dog |
But as far as the text data goes, the vertical line boundaries between each column would be replaced with the delimiter character (a , for CSV files) and each row would be a new line in the file. So, it would look like the text below.
First Name,Last Name,Email,SSN,Favorite Animal
Aaron,Aaronson,aaron@example.com,987-65-4321,aardvark
Billy,Billiamson,,999-88-7777,billy goat
Cathy,Catherton,cat@example.com,900-00-1234,dog