topic Re: Formatting Data Item in Product Forum

Formatting Data Item

sandeshtope — Sat, 13 Jul 2024 10:04:13 GMT

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?

Re: Formatting Data Item

devneetmohanty07 — Sat, 13 Jul 2024 21:59:58 GMT

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(),"','") & "'"