You can translate the question and the replies:

Questions

how to write regular expression to extract header and tuples of a delimited file having (for eg) 3 coloumns. id - job - department 1- engineer - technical 2- manager - sales
user
18-07-2022 06:39:40 -0400
code

1 Answer

Hello, When I created a Delimited File Source, if I choose **Use tuple pattern**, I could use regular expressions for **Tuple pattern**, **Header pattern** to extract the information. If the given sample data is enough for representing the source data, I would choose **Use column delimiter** and specify** Column delimiter -**, then it was enough for retrieving the data. I would use a regular expression for a complex structure and the regular expression could depend on the data that I wanted to specify the format of the row. The document [Examples of How to Define a Tuple Pattern](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources#examples-of-how-to-define-a-tuple-pattern) shows examples for tuple patterns. I would use these documents as a useful reference. Hope this helps!
Denodo Team
19-07-2022 12:11:45 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here