Manipulation from excel to excel

Help Studio
, ,
3

@Sonam_N,

If you are exporting data from SAP try to export in text with tab or other format then the current one.

The current data is kind of complex where regex can work but will have to test it properly.

Here is a starter code for Regex approach.

This image depicts a workflow diagram that reads data from an Excel file, processes it using regular expressions, and writes the processed data to a new Excel file. (Captioned by AI)
This image depicts a workflow diagram that reads data from an Excel file, processes it using regular expressions, and writes the processed data to a new Excel file. (Captioned by AI)927×1122 52.7 KB

Sample project:
GetExcelData.zip (68.5 KB)