Conditional Delete of Bolded Words within Excel File

[#1]

Dear all,

I have benefited a lot from reading the discussions within this community.

I am loading a table into my app using Conditional Delete.

However, there are rows in which regions(highlighted in bold) are included in the table.

I would like to remove the bolded entries.

Rather than manually deleting them one by one, are there any methods to specifically delete bolded characters from the table using conditional delete?             

Thanks!                                                                                                                                                                                                                  

[Gysbert_Wassenaar]

The File Wizard cannot use excels text formatting to filter data. You will have to add real data to the excel file instead of formatting to mark the records that should be filtered out.

[marcus_sommer · Accepted solution]

You will need an additionally column in your excel which returned something like 'IsBold' or 'NotBold'. Have a look here how it could be done:

http://www.extendoffice.com/documents/excel/913-excel-filter-bold-cells.html

- Marcus

[#4]

Thanks for the reply.

It was useful.

I had hope to automate the process within QlikView for future file updates, so that future users do not have to manually modify the new excel files. 

Seems that I have no choice but to modify the file.