PowerBuilder Functions Aggregate

PowerBuilder Functions Aggregate

F_RELATIVE_YEAR

F_RELATIVE_MONTH

F_RELATIVE_DATETIME

F_IS_VALID_TIME

F_IS_VALID_DATETIME

F_IS_VALID_DATE

F_IS_WHITE_SPACE

F_IS_PUNCTUATION

F_IS_COMPARISON_OPERATOR

F_PARSE_TO_ARRAY

F_IS_ALPHA_NUM

F_IS_ARITHMETIC_OPERATOR

F_DATAWINDOW_COPY

F_PARSE_DS_OBJ_STRING

F_MAIL_ERROR_TO_STRING

F_GET_TOOLBAR_INDEXES

F_GET_TOKEN

F_CLOSEST_DATE

F_SET_ACTIVE_DIRECTORY

F_GET_ACTIVE_DIRECTORY

F_GET_COMPUTER_NAME

F_PLAY_SOUND

F_GET_USER_NAME

F_GET_WINDOWS_DIRECTORY

F_GET_NAME_AND_PATH_APPLICATION

F_COPY_DATASTORE_TO_EXCEL

F_GET_COLOR_SYSTEM

F_PARSE_TO_ARRAY

F_GLOBAL_REPLACE

F_ARRAYTOSTRING

///////////////////////////////////////////////////////////////////////////////////////////////////////////// //
// Function Name : f_arraytostring
// Argument Name : as_source[], Arg Type : String, Pass By : Value
// as_delimiter, Arg Type : String, Pass By : Value
// as_ref_string, Arg Type : String, Pass By : Reference
// Return Type : Long
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
//
// Description: Create a single string from an array of strings separated by
// the passed delimeter.
// Note: Function will not include on the single string any
// array entries which match an empty string.
//
// Arguments:
// as_source[] The array of string to be moved into a single string.
// as_Delimiter The delimeter string.
// as_ref_string The string to be filled with the array of strings,
// passed by reference.
///////////////////////////////////////////////////////////////////////////////////////////////////////////////

Long ll_count
Long ll_ArrayUpBound

//Get the array size
ll_ArrayUpBound = UpperBound(as_source[])

//Check parameters
If IsNull(as_delimiter) Or (Not ll_ArrayUpBound > 0) Then
Return -1
End If

//Reset the Reference string
as_ref_string = ”

For ll_count = 1 To ll_ArrayUpBound
//Do not include any entries that match an empty string
If as_source[ll_count] <> ” Then
If Len(as_ref_string) = 0 Then
//Initialize string
as_ref_string = as_source[ll_count]
Else
//Concatenate to string
as_ref_string = as_ref_string + as_delimiter + as_source[ll_count]
End If
End If
Next

Return 1

F_DISTINCTVALUES

F_CREATE_SHORTCUT

F_WAIT_TO_RUN

F_CALL_VBSCRIPT

F_CALL_CALCULATOR_AND_SENDKEYS

F_GET_DOMAIN_AND_USERNAME_COMPUTERNAME

F_CALL_NOTEPAD_AND_SENDKEYS

F_SET_ZOOM_DATAWINDOW

F_CREATE_DYNAMIC_DATAWINDOW

F_GET_ALL_COLUMN_NAME

F_GET_DUPLICATE_ROW

F_GET_PRINTER_LIST

F_CONVERT_FILE_TO_BLOB

F_GET_ALL_SELECTED_ROW

F_WORDCAP

F_CONVERT_DECIMAL_TO_STRING

F_WINDOW_CENTER

F_IS_ALPHABET

F_GET_ALPHABET_AND_NUMBER

F_GET_ALPHABET

F_GET_NUMBER

F_EXPORT_TO_EXCEL

F_SET_DEFAULT_PRINTER

Good Luck! collection from internet

Was this article helpful?

Related Articles

Leave A Comment?