Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Convert multi line string in one line in Ax 2012

Posted on by 1,055

Hello Guys ,

From Excel i need to copy and paste values in AX memo type field . when i paste the values in Memo field in a form its pasting in multi line, like this --

PR-NQ20-000311
PR-NQ20-000325
PR-NQ20-000360

I need to convert this string in single line  like this --

PR-NQ20-000311PR-NQ20-000325PR-NQ20-000360

Is there any way or any stranded  function available in ax .

Please suggest how to achieve this .

  • Naveen Mishra Profile Picture
    Naveen Mishra 1,055 on at
    RE: Convert multi line string in one line in Ax 2012

    Thanks !! Martin Dráb,

    I achive this this by using below line of code .

    PRID = strRem(strRem(PRID, "\n"), "\r");

    Thanks.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,235 Most Valuable Professional on at
    RE: Convert multi line string in one line in Ax 2012

    You can replace \r\n (= escape sequences for a new line) with a space.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans