Generate An Data Table Using Text String

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Hi Team,

I have an string/Text coming from an variable.

String/Text(Input)---- TMO_19736368711High Usage Data National62(167105583153 >= (46 * (1024 * (1024 * 1024))))2024-01-23TMO_19736368711High Usage Data National52(156006170005 >= (46 * (1024 * (1024 * 1024))))2024-01-23TMO_18032877407High Usage Data National9(49822174738 >= (46 * (1024 * (1024 * 1024))))2024-01-23TMO_18032877407High Usage Data National9(49771120609 >= (46 * (1024 * (1024 * 1024))))2024-01-23TMO_12175507896High Usage Data National5(55262413859 >= (46 * (1024 * (1024 * 1024))))2024-01-23

Output To be –

Note - Headers are already fixed in excel

Please help if anyone knows logic ( i tried with generate datatable activity but im missing something)

Thanks
Happy Automation
Rishi

[ppr (Peter Preuss)]

In such scenario can the following strategy work:

• using Regex for setting column delimiters
• using Generate DataTable for parsing masked text into a DataTable

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Remove Headers From Text… In Excel ill make the headers constant fix

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

@Putta_Sri_Sai_Rishik_Chow

Remove Headers From Text

Forgot about headers…ill make them constant in excel…!!

Values i need to populate to excel

[ppr (Peter Preuss)]

we can handle eg. by removing the first line before

@ppr

• using Regex for setting column delimiters
• using Generate DataTable for parsing masked text into a DataTable

[vrdabberu (Varunraj Dabberu)]

Hi @Putta_Sri_Sai_Rishik_Chow

I have used the split function and splitted the string into string array. later I have used the for each and regex expressions and build data table activities to acheive the output

Workflow:
Main.xaml (23.9 KB)

Excel Output:
TestForum.xlsx (8.6 KB)

Regards