Formatting Data Item

[sandeshtope]

Hi everyone,

I have a data item in Blue Prism that contains multiple codes stored as follows:

12367
18V98
1A876
28767
20877
40767

I need to format this data item so that it appears like this: '12367','18V98','1A876','28767','20877','40767'.

How can I achieve this transformation using Blue Prism?

[devneetmohanty07 · Accepted solution]

Hi @sandeshtope ,

You can use a simple calculation formula to transform the format, where you have single quotes as the starting and ending characters while between that you replace new line characters in your data item with comma separator surrounded with single quote:

"'" & Replace([Test],NewLine(),"','") & "'"