Small and medium business | Business Central, N...

How to delete special charatcters while importing txt file

(0) Share

Report

Posted on by Community Member

I am trying to import txt file and iam getting an error

And I tried to delete this character in the XML port and iam getting different error

trigger OnOpenPage()

var

String: Text;

Where: Text;

Which: Text;

NewString: Text;

Text000: label 'Achtung';

Text001: Label '>%1< is transformed to >%2<';

begin

String := Text000;

Where := '<>';

Which := '';

NewString := DelChr(String, Where, Which);

Message(Text001, String, NewString);

end;

How can i remove this 2 '' character while importing XML file any help will be great, Thanks in Advance.

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Please share your complete code.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is my code I have written and I have my XML ,table, page, Iam trying to test this code on open page if it works there then i will add it on the XML port on after get record,

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

but this string Text000: label 'Achtung'; does not have '', how you can remove that?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In the code I have written this when copied the code it shows as blank.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Yes its blank as a string, you can not remove blank if you wan to remove try this

keepTxtChars := ‘1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz’;

newstring := DELCHR(string,’=’,DELCHR(string,’=’,keepTxtChars));

Was this reply helpful? Yes No
Suggested answer

pankaj.k 994 on at

Like (0)

Report

Hi sainudheen,

Please check the below link that will help you to How to work All String Function.....

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/text/text-delchr-method

https://learn.microsoft.com/en-us/dynamics-nav/delchr-function--code--text-

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks the quick response Nitin Verma Yes, I tried This on XML port on trigger after get record but still the error pops up

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Try this.

keepTxtChars := '''';

DELCHR(string,'=',keepTxtChars)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Its working on open page

but during the import its still the same error

i have added in on trigger OnAfterGetRecord()

but here no record is getting so its not working is there any other alternative solutions for it.

Was this reply helpful? Yes No