
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sense - using match function
Team
What have I done wrong here please...
[handles], | |
if(match([knockers], 'slimline_urn','Slim'), |
if(match([knockers], 'urn','Standard'),
if(match([knockers], 'urn_with_spyhole','Standard (V)'),
if(match([knockers], 'slimline_urn_with_spyhole','Slim (V)'),
if(match([knockers], 'ingot','Ingot'),
if(match([knockers], 'horsetail','Horsetail'),
if(match([knockers], 'no_knocker','None','None')))))))),
[letterplates] |
Thanks in advance
Bing
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you misplaced the brackets
if(match([knockers], 'slimline_urn'),'Slim', |
if(match([knockers], 'urn'),'Standard',
if(match([knockers], 'urn_with_spyhole'),'Standard (V)',
if(match([knockers], 'slimline_urn_with_spyhole'),'Slim (V)',
if(match([knockers], 'ingot'),'Ingot',
if(match([knockers], 'horsetail'),'Horsetail',
if(match([knockers], 'no_knocker','None'),'None')))))))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you misplaced the brackets
if(match([knockers], 'slimline_urn'),'Slim', |
if(match([knockers], 'urn'),'Standard',
if(match([knockers], 'urn_with_spyhole'),'Standard (V)',
if(match([knockers], 'slimline_urn_with_spyhole'),'Slim (V)',
if(match([knockers], 'ingot'),'Ingot',
if(match([knockers], 'horsetail'),'Horsetail',
if(match([knockers], 'no_knocker','None'),'None')))))))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sussed it myself people
[handles], | |
if([knockers] = 'slimline_urn','Slim', |
if([knockers] = 'urn','Standard',
if([knockers] = 'urn_with_spyhole','Standard (V)',
if([knockers] = 'slimline_urn_with_spyhole','Slim (V)',
if([knockers] = 'ingot','Ingot',
if([knockers] = 'horsetail','Horsetail',
if([knockers] = 'no_knocker','None','None'))))))) as [knockers],
[letterplates], |

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cheers, just uploaded another way that works too
