Generate DataTable from String

Help Studio
1

Hello all,

I get a TSring from a software via get visible text, whose content I need as a datatable.

The problem is that I can’t get the string formatted.

The text is the content of the heading I need for the respective column, but it is not always separated by a special character. The data for the DataTable are separated by spaces, which I tried to separate with a comma using Replace String, but the result was as follows.

How can I manipulate the string so that I can process the data via generate datatbale?

String

“KundennummerArtikelnummer,Lieferscheinnummer,Lieferscheinposition,AnzahlReferenznummer,523778,40”

Uipath
Uipath695×104 17.7 KB

2

Hi @NHoe
Can you post the desired output?

3

Hi @Emira

Hi, here is the issue. I have already tried using System.Text.RegularExpressions.Regex.Replace(str_Text, “s\s+/g”, “,”) to remove the spaces and replace the commas, but I am missing the paragraph as a new line.

KundennummerArtikelnummer Lieferscheinnummer Lieferscheinposition,AnzahlReferenznummer,Column1,Column2\r\n523778 40-46-8251 702203 01,1,6211\r\n523778 40-46-5743 702203 03,4,6211\r\n523778 40-40-1206 702203 02,1,6211\r\n"

4

Please share an example of an input text and the output datatable.

5

HI @NHoe

Have you tried with Generated DataTable activity? Can you share us the sample input and expected output