Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with all articles in it. Due to historical reason parts start with a letter, consumables with a digit.
I now want too filter for further calculations with a button all parts, so articles starting with a letter out of this table.
I have for the moment no clue how to do this, in Excel I would simply write "> a"
OK
Data:
LOAD * INLINE [
Article, Qty
A0001, 1
A0002, 2
C3333, 4
44444, 5
Z0002, 6
D22255, 7
12345, 8
]where IsText(left(Article,1));
add where IsText(left(Article,1))
output :
can you share a sample Data with the expected output ?
I added a screenshot of a sample table how it looks and how it would need to look after filtering.
OK
Data:
LOAD * INLINE [
Article, Qty
A0001, 1
A0002, 2
C3333, 4
44444, 5
Z0002, 6
D22255, 7
12345, 8
]where IsText(left(Article,1));
add where IsText(left(Article,1))
output :
One more solution.
tab1:
LOAD * INLINE [
Article, Qty
A0001, 1
A0002, 2
C3333, 4
44444, 5
Z0002, 6
D22255, 7
12345, 8
]
Where Not IsNum(Left(Article,1));
One more version.
tab1:
LOAD * INLINE [
Article, Qty
A0001, 1
A0002, 2
C3333, 4
44444, 5
Z0002, 6
D22255, 7
12345, 8
]
Where Lower(Left(Article,1))<>Upper(Left(Article,1));