HPW IS ONE ABLE TO CUT A SUBSTRING FROM THE NAME OF A FILE AND ALSO APPEND IT AS A RECORD IN THE DATABASE??
How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.
Microsoft Excel macros, Microsoft Excel, Microsoft Excel formulas
I want to replacing 1 character in a String with 1 or more Characters in COBOL/400. How can i perform this??
I want to conver number to word ie. if 10 it to be Ten, if 540 it to be five hundred forty so on
I'm having trouble pulling the middle portion out of a dynamic string. Ex: Orginal String 1 = John Doe, Age 35 (asd) Original String 2 = Tom Thompson, Age 100 (jkl) I need the code to produce... New String 1 = 35 New String 2 = 100 I've tried to research this, but am new to VBA and a lot of...
i am new at this. This is an example of the data (in notepad) it looks like this.. 1,ABC,12/12/2008 2,DEF,13/12/2008 3,GHI,14/12/2008 4,JKL,15/12/2008 i would like to read only the first line and have each field dim as varchar. The output should be in this form: Field 1 = 1 Field 2 = ABC Field...
Wath function can I use to find a text into other? I mean how caon I find the Position for -B- in the text -AABAA-


