Remove excel files from column

[rupaliqlik]

Hi All,

I have on e column which contain QVW application with path ,qvd with path and excel files with path.I want to remove excel files from column .Can you help me on this?

load * inline
[
Path
\\pwil0699qvfs01\qlikview\bd2 to bd1 1qtc product ref.xlsx
\\pwil0699qvfs01\qlikview\\contract data\bd2 to bd1 tradeorg xref.xlsx
\\pwil0699qvfs01\qlikview\\bd_oasis\mps\mka product xref.xlsx
\\pwil0699qvfs01\qlikview\MDS_Dashboard.qvw
\\pwil0699qvfs01\qlikview\BDI.qvd
\\pwil0699qvfs01\qlikview\A&P.qvw

];

Remove xlsx files from column

[Claudiu_Anghelescu]

WHERE Not Match(Path, '*xlsx*')

[Vegar]

load * inline
[
Path
\\pwil0699qvfs01\qlikview\bd2 to bd1 1qtc product ref.xlsx
\\pwil0699qvfs01\qlikview\\contract data\bd2 to bd1 tradeorg xref.xlsx
\\pwil0699qvfs01\qlikview\\bd_oasis\mps\mka product xref.xlsx
\\pwil0699qvfs01\qlikview\MDS_Dashboard.qvw
\\pwil0699qvfs01\qlikview\BDI.qvd
\\pwil0699qvfs01\qlikview\A&P.qvw
]
Where right(Path,5) <> '.xlsx'
;