trim+ms dynamic navision 5.0

Hi all,

i have created a dataport in navision to import data from excel.

the problem that i have faced is there is spaces at the end of the string i want to remove it when i read it from excel, so i am trying to use string := DELCHR(string,'<>',' '); but also some of spaces at the end of string still exit.

I read from the internet maybe this type of spaces is unicode characaters or non printing characteres

how i can solve this problem.

thanks a lot,

regards,
MKItaniAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
Try these in order:

DELCHR(string,'>');

CHAR10 := 10;
CHAR13 := 13;
CHAR160 := 160;
DELCHR(string,'=',FORMAT(CHAR10));
DELCHR(string,'=',FORMAT(CHAR13));
DELCHR(string,'=',FORMAT(CHAR160));

Kevin
0
 
SteveCommented:
Have you tried:
string := DELCHR(string,'<>'); 

Open in new window

0
 
MKItaniAuthor Commented:
Thanks for your reply,

it is doesn't work ...

regards,
0
 
MKItaniAuthor Commented:
thanks i will check it.
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.