Specifying Tab Delimiter Symbol in DCOUNT()

naserumak · Post by **naserumak** » Tue Feb 20, 2007 1:27 am

Hai EXperts,

i have Tab Delimited Record and i Have To Count No.of Delimiters in that record.I am Using DCOUNT() Function.

But, My Problem Is HOW TO SPECIFY TAB SYMBOL IN the DCOUNT FUNCTION.

kumar_s · Post by **kumar_s** » Tue Feb 20, 2007 1:40 am

Hi,
Welcome Aboard :D !!!
Try with '\t'.

balajisr · Post by **balajisr** » Tue Feb 20, 2007 1:48 am

Also Try with Char(9)

Code: Select all

DCount(Record,Char(9))

naserumak · Post by **naserumak** » Tue Feb 20, 2007 3:10 am

'\t' It's Not Working.

Dcount(Records,Char(9)) Its Working Fine.

Thank U Balaji

Sreedhar · Post by **Sreedhar** » Tue Feb 20, 2007 3:15 am

If your aim is to find the no of fields in a record then we can use.....

awk -F'\t' 'END {print NF}' testfile

Not sure about the DCOUNT()

Regards,

kumar_s · Post by **kumar_s** » Tue Feb 20, 2007 3:22 am

Do you think this topic can be marked as resolved?