Convert String To DataTable

Help Studio
, ,
1

I need to convert this string
“Year 2023 2024 2025
Financial Statement Audit $ 360 $ 330 $ 345
Single Audit 999 1049.0 1115.0
Total Fees $2935.0 $30,820.00 $3236.0” to datatable i have used generate datatable but the result is not expected that i want i needed like this
New Microsoft Excel Worksheet.xlsx (8.3 KB)
,please help me to do this

2

Hi @alan.prakash

You would have to use regex for this.

3

How to do that can u elaborate

4

Hi @alan.prakash

Here’s the Sample XAML.
Please try this!
Regex.xaml (14.4 KB)

Output File generated:
GeneData.xlsx (6.3 KB)

Thanks
Happy Automation! :smiley:

5

Thank u so much it is working.

6

hello @alan.prakash
You can achieve your goal through linq. linq can optimize your flow and reduce processing time, more importantly it is dynamic, I am attaching the workflow for you and others reference.
Solution_Through_Linq.zip (11.6 KB)

happy automation
Regards,
Dheerendra Vishwakarma

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.