Solved Add ; to end of every line

[rpaccount]

Hi all,

I need to add ; to the end of every line. E.g. XXX00000048844;
Is there a way to do it without looping?
I changed it from collection into a string

View attachment 1537427602968.png

Thanks!

 

[VJR]

Hi rpaccount,

Without looping use this expression in your Calc stage.

Replace([Input], NewLine(), ";" & NewLine())
where [Input] is your Text data item that contains the input string.


If there was no new line character in the input string then your output will end up as below
View attachment 1537260400826.png
Notice that there is no semi colon for the last record.
I do not know if you need this or not. But if you need it then add another Calc stage (or use Multi Calc stage) with the expression as below and store the result in the same Input data item.

[Input] & ";"