Avoiding last character in a line

[Former Member]

Hi,

I am printing orders as 00123, 00124, 00125, in this i want to remove the last character , besides 00125.

I mean after the end order number comma should not print. I am printing this in an email.

Regards

VEnk@

[Former Member]

Hi..

You can use Replace All Occurences Of.. Pass your requirement to be replced like in ur case '*' or ',' and replace it with ' '.Means Space..

[andreas_mann3]

coul you post a code snip?

A.

try to use commands as FIND [{FIRST OCCURRENCE}| and replace / translate...

[Former Member]

You only have to use

REPLACE ALL OCCURRENCES OF '*' IN V_STRING WITH SPACE .

Where v_string = '00123, 00124, 00125,'.

This will make the value of V_string = '00123, 00124, 00125,'

Edited by: Kapil Sharma @ Steria on Jan 28, 2010 12:46 PM

[Former Member]

If the data looks like you have it posted....

replace ',' with space into <fieldname>....whatever your variable name is

[Former Member]

Hi All,

I have actually want to show last comma as BOLD but everyone is thinking as *, And my issue is to avoid last Comma...So i took a variable and in that took the total count of order records and kept a check inside a loop as if count matches don't append Comma.

There is no point of replace.

Regards

VEnk@