Variable column widths, string lengths in printf-style functions

I have been programming in C for quite some time, but until recently I was not aware that you could specify column widths and string limits using variables. I have neither seen this functionality used in any projects until I started working with OpenSER.

Specify a variable column width:

printf("%*d", width, number);

Specify a variable number of characters from a string:

printf("%.*s", width, string);

Proper UDF - Capitalize String as Proper Names

The ufn_Proper() UDF for SQL Server is similar to the VFP Proper() function. It additionally allows to specify a set of delimiters.

Strextract UDF - Retrieves String Between Two Delimiters

The ufn_StrExtract() UDF for SQL Server is similar to the VFP StrExtract() function.

Alines UDF - String Split

The ufn_Alines() UDF for SQL Server is similar to the VFP Alines() function but w/o additional parameters.

Syndicate content