Now I stored dynamic data with each mobile product as sheet name , now I want to get only mobile name and its configuration, I dont want anyither text . Suppose If i use regex it has to work for all the products.
can you pls give me a solution where it has to work for all the mobile products . finally I want name and configuration in seperate columns in excel sheet.
Can you please share the expected output too like what should be stored under Mobile Name and what should be stored under Configuration. Please specify with an example from each sheet.
Regards
Hello Sonu,
Let’s say your initial string is “iPhone 15 Plus (128 GB) - Yellow”. If you split it from the “(” bracket, the output will be two separate strings:
Syntax to split : yourString.Split({"("c}, StringSplitOptions.None)
- "iPhone 15 Plus "
- “128 GB) - Yellow”
And also
If you want to add the “(” bracket before the first part of the string “128 GB) - Yellow”, you can use the following code:
yourString = "(" + yourString
This will add the “(” bracket at the beginning of the string. So the updated string will look like this:
“(128 GB) - Yellow”
And also
The data which you have extracted write into a excel file then read that excel file in for each and for every row you can perform Splitting task easily😊
Let me know if you have any more questions! 
Hope that clarifies it for you! Let me know if you have any more questions.
Happy Automation!!
The output should look like Mobile Name eg: Redmi Configuration - 8gb like that for all the products