Ax2012 Street address

(0) Share

Report

Posted on by Community Member

Hi there,

I have a problem with the 2012 address format. I need to create a flat file which I did using the textio class.

When I add the street field (salestable.deliveryAddress().street) to the write list it appears to have a CR LF on the end of it so my flat file wraps over 2 lines instead of being a long single line.

Is there any way I can strip the line feed from the street field?

Many thanks in anticipation

Paulina

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

This may be happening due to '\n' character in street test

you need to remove it before you write it to the text file

you can use method strRem(str1, str2) before you write the street value to the test file

str1 = salestable.deliveryAddress().street

str2 = '\n'

Please verify and let us know if it helps you

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,084 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

CSV typically can contain new line characters if the value is enclosed in double quotes. See section 2.5 in RFC4180. In that case, a single CSV record can take more than one line.

Nevertheless if you don't want it, you can remove line breaks with strRem().

Was this reply helpful? Yes No
Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi Paulina

You can also use the "strRemoveCr" global method, like :

TextIo.Write( strRemoveCr( salestable.deliveryAddress().street );

That's it!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply

Interestingly I had tried this but it didn't do it. I used the statement

str daddress ;

daddress = strRemoveCr(salesTable.deliveryaddress().street);

and then used daddress in the write statement but still had the text wrap to a second line.

As there is no documentation I could find about the StrRemoveCR function I assumed it was for another purpose.

Paulina

Was this reply helpful? Yes No
Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi Paulina

Is very strange that StrRemoveCr doesn't work.

Below the code involve. Is a static method of the Global Class.

I have try on my local env and work fine.

static str strRemoveCr(str s)

{

return strReplace(s, '\n', ' ');

}

Was this reply helpful? Yes No
Martin Dráb 239,084 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I'm confused, because the last issue hasn't been solved but the question is marked as answered.

If you still have the problem, try replacing \r\n instead of \n alone. I think this is the problem.

Was this reply helpful? Yes No