You can translate the question and the replies:


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
18-07-2022 06:39:40 -0400

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]( 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
You must sign in to add an answer. If you do not have an account, you can register here