web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Convert multi line str...

Finance | Project Operations, Human Resources, ...

Answered

Convert multi line string in one line in Ax 2012

(0) Share

Report

Report

Posted on by Naveen Mishra

4

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 .

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

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

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Naveen Mishra 4 on at

Like (1)

Report
Copy link

Link copied!

Thanks !! Martin Dráb,

I achive this this by using below line of code .

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

Thanks.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 617

#2

André Arnaud de Cal... 461 Super User 2026 Season 1

#3

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans