1
  • How can I manipulate a string in RPG?

    I know this might sound like a "beginner" question but I know most of the time strings in RPG have a fixed length (but more importantly, have a finite length). But I'm pretty much lost on how to write a procedure for string manipulation.How can I write a procedure that takes care of a string of...

    ITKE346,360 pointsBadges:
  • SQL Server date format

    Hello, I have a problem when i am inserting a string date ie 19/9/2010, which is stored in table as 9/19/2010.  i want to insert dd-mon-yyyy format. can i insert dd-mon-yy format,please replay. 

    Shamu75 pointsBadges:
  • Excel Macro to extract substrings from a comma-separated string.

    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.

    Sdsdsd15 pointsBadges:
  • ORA-06502: Character string buffer too small

    Hi guys, Here's my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN...

    Kruti123456789shah15 pointsBadges:
  • Reversing a String in RPG

    Hello Sir, I am new in as400 programming area, In an interview I was asked How to reverse a String in rpg. I wrote the fixed lenght string program but don't know how to write it for Variable length string. I an declaring an array in RPG as:  DStringR          s             15A  ...

    Neeti5 pointsBadges:
  • Parameter Date Conversion in SQL 2000

    my code is : string sql="insert into dummy(date)values(@date)"; sqlcommand cmd=new sqlcommand(sql,con); cmd.parameters.add("@date",sqldbtype.datetime).values=maskedtextbox1.text text; cmd.executenonquery(); the problem is it's throw and error like  conversion of varchar to date; Note :- my demand...

    Maheshwag260 pointsBadges:
  • c++ reading data from txt files in tokens

    I have tried a lot to manipulating strings. I want such code witch read the data from input file. I want to get data in tokens (to store in variables) of type char or int of specific location in input file.  I want to store string parts in variables for   further use. eof() helps but I am reading...

    Programming786250 pointsBadges:
  • How to convert a “Numeric-String” with ‘-’ sign and decimal places into pure “Numeric”?

    Dear AS/400 Lovers! I need to convert a string containing Numeric-value with two-decimal places into a "Numeric". Alternatively the string may contain a minus-sign('-') in the beginning of the numeric-string(e.g. '-4321007.86'). The result should be pure numeric i.e. -4321007.86 The string's total...

    svankipu620 pointsBadges:
  • Mapping multipart external Identifiers into internal identifier

    What is the good way of mapping multipart external Identifiers(which is different for different external parties) to an internal Identifier. for example suppose we have two parties whose identifiers to represent their single product is different. party1 - ID set (p11, p12, p13) party2 - Id set...

    TejVerma5 pointsBadges:
  • convert string to double in Access 2003

    Hi - I'm trying to convert a string into a double using this expression in Access Expression builder: Field1: CDbl(string) It's not working. does anyone know why? thanks...

    Contactesa5 pointsBadges:
  • Adding Leading Zeros to a string

    I have a field with a mixture of 9 and 8 character strings... I need to make them all 9 characters in length..so how do I add a leading zero to those records with only 8 characters while leaving those records with 9 characters alone?

    Yahudee5 pointsBadges:
  • String Field Comparisons

    I am attempting to create a formula in Crystal Reports That will compare two string fields and print out an ID number. It seems as though it should be quite simple. Please help.

    DonnaBailey10 pointsBadges:
  • CUT SUBSTRINGS USING SYNCSORT

    HPW IS ONE ABLE TO CUT A SUBSTRING FROM THE NAME OF A FILE AND ALSO APPEND IT AS A RECORD IN THE DATABASE??

    Lostinheaven20 pointsBadges:
  • String manipulation in COBOL/400

    I want to replacing 1 character in a String with 1 or more Characters in COBOL/400. How can i perform this??

    C.naveen09140 pointsBadges:
  • VBA – selecting middle portion of a string

    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 what...

    McNitro255 pointsBadges:
  • Convert numbers to text with VBA (ie 10 to be Ten)

    I want to conver number to word ie. if 10 it to be Ten, if 540 it to be five hundred forty so on

    AnandaDebnath280 pointsBadges:
  • How to output a text file and separate the data into different fields using VB 2005

    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 3 =...

    Aeiou1235 pointsBadges:
  • Search for text within a string in CL/400

    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-

    Estebanguevara5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following