Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys! I have a question with wildcard match and I prepared a example data.
let's say there is basically 4 projects
Drilling / Painting / Sanding / Leveling. but as you can see from below example Drilling and Painting are logged all differently whereas Sanding and Leveling are logged fine.
1. I want to have all the rows that have "drill" in them show up as "Drilling" and all the rows that have "paint" and "Painting"
2. Sanding and Leveling should come up as it is.
what I am doing at the moment is using a wildcard search.
if(wildmatch([Project Name], '*drill*' )>0, 'Drilling','') as [Project Name],
this worked but only partially. anything that does not have "drill" in them.. so all the other projects where dropped...
and I could not use two wild matches at the same time. for example,
if(wildmatch([Project Name], '*drill*' )>0, 'Drilling','') as [Project Name],
if(wildmatch([Project Name], '*paint*' )>0, 'Painting','') as [Project Name],
QV won't let me do this.
is there anyway i can do multiple wildmatches and at the same time bring all the rest that does not match the match rule for wildmatch?
Thank you in advance!!!
Project Name |
drilling project |
Drilling Project |
Drill Project |
Drill project A |
drill Project B |
Painting job |
Paint job |
Paing blue job |
Paint red |
Sanding |
Sanding |
Sanding |
Leveling |
Leveling |
Leveling |
Are you trying to do this:
If(WildMatch([Project Name], '*drill*'), 'Drilling',
If(WildMatch([Project Name], '*paint*'), 'Painting','') as [Project Name],
Source:
load
*,
Pick(WildMatch([Project Name], '*drill*', '*pain*', '*'), 'Drilling', 'Painting', [Project Name])
as [New Project Name]
inline [
Project Name
drilling project
Drilling Project
Drill Project
Drill project A
drill Project B
Painting job
Paint job
Paing blue job
Paint red
Sanding
Sanding
Sanding
Leveling
Leveling
Leveling
];