Search Results

Based on some assumptions:
awk -F, -v C=6 '
NR == 1 {
for ( i = 1; i <= NF; i++ )
{
if ( i <= C )
...

There's a reason I used % as a delimiter in my list file; some of those items have spaces in them, $2 won't be the entire type.

Oh ok. I got it.

Create a comma separated list file instead:
$ cat listfile
ID,string
Key,string
KeyCreateDate,date("YYYY-MM-DD")
EmailAddress,string
DepDate,date("YYYY-MM-DD")...

Here is what I get by adding a testfield in the input file:
$ ./anduzzi.awk
record
string(',') ID;
string(',') Key;
date("YYYY-MM-DD")(',') KeyCreateDate;
string(',') EmailAddress;...

Here is another approach:

Input file with list of datatype:
$ cat listfile
ID string
Key string
KeyCreateDate date("YYYY-MM-DD")
EmailAddress string
DepDate ...

Least complex to you, because you know the rules and I don't... "mostly" decimal is guaranteed to guess wrong if I guess all decimal.

Does it go by name? I hope it goes by name. You can make a...

Do you mean like this:
grep "'"'"${ETL_VW_SCHEMA}"'"'\.PROJ$" infile
it is a bit of a puzzle :). Perhaps you rather just do this:
grep '${ETL_VW_SCHEMA}.*\.PROJ$' infile