Different representation of the data of a string

[juergenh1975]

Hi,

how can I move this data to the clipboard, but not separated with the " | " but one below the other as a string (new line by line):

this is the code for the string:
strAllSDs = String.Join(“|”, dtFiltered.AsEnumerable.Select(Function (x) x(YourColNameOrIndex).toString.Trim))

it should then be inserted into SAP. There is a button where you can take over data from the clipboard.

[ppr (Peter)]

@juergenh1975

strAllSDs = String.Join(“|”, dtFiltered.AsEnumerable.Select(Function (x) x(YourColNameOrIndex).toString.Trim))

Give a try on

strAllSDs = String.Join(Environment.NewLine, dtFiltered.AsEnumerable.Select(Function (x) x(YourColNameOrIndex).toString.Trim))

[Che]

Hi @juergenh1975

Use @ppr’s answer, then use the Set To Clipboard activity. Set your input text for the text to be copied.

Kind Regards

[juergenh1975]

@ppr

String.Join(Environment.NewLine, dtFiltered.AsEnumerable.Select(Function (x) x(YourColNameOrIndex).toString.Trim))

perfect ! that’s it !
thx for all your support
BR