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)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please share your complete code.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 1,020 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try this.

keepTxtChars := '''';

DELCHR(string,'=',keepTxtChars)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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