How to avoid Special char in NAV?

chandrurec · 2010-09-20

Hi all,

When I copy the values from excel to a text bos in NAV, the expty spaces is coming in the form of boxes, is there any property or coding to avoid this .

Thanks in advance.

Regards,
Chandru.

Savatage · 2010-09-20

Same question here:
viewtopic.php?f=23&t=32805

klavin · 2010-09-20

One way would be to strip out the Carriage Return and Line Feed (Char 10 and 13) from the text. Can be done globally for Text fields in the Application Management (CU1) MakeText function I would assume. Beware, this function is called whenever text is entered into a text field.

This is where you get the standard functionality of using a ? to get the Standard Text pop-up.

Otherwise, you would have to make your own function and call it onvalidate of fields, which would be a lot of repetitive code.

rhpnt · 2010-09-20

Are we talking copy/paste or import?

chandrurec · 2010-09-20

Hi,

I am copying a cell from excel and pasting it in NAV Text field at that time I am getting 2 boxess getting appended to this string.

Kindly tell me how to avoid this.

Regards,
Chandru.

rhpnt · 2010-09-20

By copying only the text not the whole cell or by deleting them manually in NAV...

Savatage · 2010-09-20

did you read the posts above?

Several solutions posted here:
viewtopic.php?f=23&t=32805

chandrurec · 2010-09-20

Hi Savatage,

I have given the coding like this in the Posting No field On Validate trigger

CHAR10 := 10;
CHAR13 := 13;
POS := STRPOS("Posting No.", FORMAT(CHAR10));
IF POS <> 0 THEN ERROR('Pasting Canceled Carrage Return Exists');
POS := STRPOS("Posting No.", FORMAT(CHAR13));
IF POS <> 0 THEN ERROR('Pasting Canceled Line Feed Exists');

is CHAR 10 and CHAR 13 are integer datatype ?

but still when i copy the cell from excel to nav the boxes are getting appended to the string .

Kindly give me a soluion to avoid this

Thanks & Regards,
Chandru

FDickschat · 2010-09-20

Yes, there is a solution. Use the Search, Luke!

http://lmsmfy.com/?q=Carriage%20Return and read the forum entry "Hidden Characters (Carriage Return and Line Feed)"

Savatage · 2010-09-20

Yes that code just tells you there are "special chars" and doesn't let you enter them.
It's more of a notification to the user to go & edit the string by removing these chars before continuing.

The post also has a solution you put in CU1.

You can also try copying the value from the function bar Fx instead of the cell.
Ps why would you be pasting into the "Posting No." field to begin with?

klavin · 2010-09-20

Savatage wrote:

did you read the posts above?

Several solutions posted here:
viewtopic.php?f=23&t=32805

Haha, sorry Harry, thought you were mentioning that it was a double post... I saw it was then came into this one and replied a suggestion lol.

-Kevin

Savatage · 2010-09-20

No sorry needed , I was actually replying to the 5 or 6th post where it was asked again how to do it.

chandrurec · 2010-09-21

Hi Savatage,

I got the output. Thank you so much.

Regards,
Chandru.

How to avoid Special char in NAV?

Comments

Categories