topic Re: String Functions in Application Development and Automation Discussions

String Functions

Former Member — Thu, 14 Jun 2007 11:10:10 GMT

Hi,

How to remove a space in a string ?

st = ' hai'.

I want to remove front and back spaces .

If there any function ?

Bye,

Satya.

Re: String Functions

Former Member — Thu, 14 Jun 2007 11:11:49 GMT

use CONDENSE command

condence str.

will remove the spaces

Reward points for useful Answers

Regards

Anji

Re: String Functions

Former Member — Thu, 14 Jun 2007 11:13:01 GMT

use <b>condense</b>

Re: String Functions

Former Member — Thu, 14 Jun 2007 11:14:08 GMT

Hi,

Try this code,

SHIFT st RIGHT DELETING TRAILING SPACE

Thanks.

Reward If Helpful.

Re: String Functions

Former Member — Thu, 14 Jun 2007 11:15:40 GMT

Hi,

The CONDENSE statement deletes redundant spaces from a string:

CONDENSE <c> [NO-GAPS].

This statement removes any leading blanks in the field <c> and replaces other sequences of

blanks by exactly one blank. The result is a left-justified sequence of words, each separated by

one blank. If the addition NO-GAPS is specified, all blanks are removed.

DATA: STRING(25) VALUE ' one two three four',

LEN TYPE I.

LEN = STRLEN( STRING ).

WRITE: STRING, '!'.

WRITE: / 'Length: ', LEN.

CONDENSE STRING.

LEN = STRLEN( STRING ).

WRITE: STRING, '!'.

WRITE: / 'Length: ', LEN.

CONDENSE STRING NO-GAPS.

LEN = STRLEN( STRING ).

WRITE: STRING, '!'.

WRITE: / 'Length: ', LEN.

Output:

one two three four !

Length: 25

one two three four !

Length: 18

onetwothreefour !

Length: 15

Note that the total length of the field STRING remains unchanged, but that the

deleted blanks appear again on the right.

Regards,

Bhaskar

Re: String Functions

Former Member — Thu, 14 Jun 2007 11:20:57 GMT

Hi ,

My problem is We are taking values from java program . They are sending in String Format for the Quantity field. We have to take the values and we have to update in our database. In our database quntatiy field is with packed decimal with 3 digits in after decimals.

How we can convert it ?

Bye,

Satya.

Re: String Functions

Former Member — Thu, 14 Jun 2007 11:21:48 GMT

CONDENSE <string name> NO-GAPS.