Convert multi line string in one line in Ax 2012

(0) Share

Report

Posted on by Naveen Mishra

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 (2)

Answers (1)

Verified answer

Martin Dráb 237,908 Most Valuable Professional on at

Like (1)

Report

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

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