How to separate values by path??

[saratchandra]

Parameters Path
DCI_SIMPLE_APP_CONTROL_WORD Category 1/Sample App
DCI_SIMPLE_APP_STATUS_WORD Category 1/Sample App
DCI_BLE_TEST_SETTING_1 Category 1
DCI_BLE_TEST_SETTING_A Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_B Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_C Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_D Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_E Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_F Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_2 Category 1
DCI_BLE_TEST_SETTING_3 Category 1
DCI_BLE_TEST_READING_1 Category 2
DCI_BLE_TEST_SETTING_4 Category 2
DCI_BLE_TEST_READING_2 Category 2
DCI_BLE_TEST_READING_3 Category 2
DCI_BLE_TEST_SETTING_5 Category 2
DCI_BLE_TEST_SETTING_6 Category 2
DCI_BLE_TEST_SETTING_7 Category 2



Here i have parameters to be printed based on the path. The path has to look like

"Category 1": {
"Setting 1": {

}
"Group 1": {
"Category A": {
"Setting A": {

}
"Setting B": {

}
"Setting C": {

}
"Setting D": {

}
"Setting E": {

}
"Setting F": {

}
}
}
"Setting 2": {

}
"Setting 3": {

}
"Sample App": {

}
"Category 2": {

"Reading 1": {

}
"Setting 4": {

}
"Setting 5": {

}
"Setting 6": {

}
"Setting 7": {

}
"Reading 2": {

}
"Reading 3": {

}
}

The parameters should be categorized in to categories. I need VBA script to print the same in generated file.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...how-to-separate-values-based-on-category.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[saratchandra]

Hi Fluff,

I didn't get the answer to my question so i posted the question in your forum for answer as i am in emergency in solving the issue.
I am sorry for breaking your rules and I will make sure not to repeat it again.
Please provide the solution to my issue ASAP.

Thanks & Regards,
Sarath.

 

[Joe4]

I didn't get the answer to my question so i posted the question in your forum for answer as i am in emergency in solving the issue.
I am sorry for breaking your rules and I will make sure not to repeat it again.

We are not saying that you cannot Cross-Post. We are simply saying if you do, please sure to mention that you are doing so and provide links to the other places where you have asked the question.

 

[CHill60]

Also at https://www.codeproject.com/Questions/1236732/How-to-separate-values-based-on-category

 

[Joe4]

Also at https://www.codeproject.com/Question...ed-on-category

saratchandra,
Please provide links to ALL of the places where you have posted this question.