how to trim characters

[selasi]

good day.

i have certain characters that i want to trim so that i can post my data to another database. however i have been trying this:

define var dset as char init 10-D-102350000.

trim dset "-".

end.

may anyone assis me with how to trim the character - on the number 10-D-1023500.

regards

 

[skunal]

Hi,
I guess trim only removes ur leading and trailing spaces. if you wna to trim "-" then u have to use some string functions like entry,lookup,substring to programitically remove it.

 

[RealHeavyDude]

For one you could try the REPLACE function.

cVariable = REPLACE ( cVariable, "-", "" ).

Heavy Regards, RealHeavyDude.

 

[selasi]

thank you guys. however its not one that i want to trim.. so would the replace function still work?

 

[RealHeavyDude]

The REPLACE function replaces all occurrences.

 

[MaximMonin]

yes
You should call it few times.
cVariable = REPLACE ( cVariable, "-", "" ).
cVariable = REPLACE ( cVariable, "/", "" ).
cVariable = REPLACE ( cVariable, " ", "" ).