Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need help with the most efficient expression to achieve the following. I have a text field that contains the following example text:
.......
LIMIT PRICE (0.0015) DOES NOT MATCH TICK SIZE
LIMIT PRICE (0.0045) DOES NOT MATCH TICK SIZE
LIMIT PRICE (0.035) DOES NOT MATCH TICK SIZE
LIMIT PRICE (0.101) DOES NOT MATCH TICK SIZE
LIMIT PRICE (0.0001) DOES NOT MATCH TICK SIZE
........
I would like to create an expression: IF text contains the words "LIMIT PRICE" then remove the "(#.###)" from the string so it displays LIMIT PRICE DOES NOT MATCH TICK SIZE.
Thanks in advance
Andrew
Hi Andrew,
Use this, I've named your example Row, so fill in your own field name for Row:
IF(Wildmatch(Row,'*LIMIT PRICE*'),'LIMIT PRICE DOES NOT MATCH TICK SIZE',Row) as Test,
Jordy
Climber
Hi Andrew,
Use this, I've named your example Row, so fill in your own field name for Row:
IF(Wildmatch(Row,'*LIMIT PRICE*'),'LIMIT PRICE DOES NOT MATCH TICK SIZE',Row) as Test,
Jordy
Climber
Try this?
keepchar ( 'field_name','abcdefghijklmnopqrstuvwxyz' )
OR try this ?
keepchar(field_name,'ABCDEFGHIJKLMNOPQRSTUVWXYZ')
But if you do that Sameer, also when there are numbers that should be in the row are now deleted. A thing that he probably doesn't want to happen..
Jordy
Climber
Hey @JordyWegman ,
But according to the problem statement this works fine and it is an efficient solution.So I think it is a better solution.
With Regards,
Sameer
This is exactly what I was after. Thanks very much and appreciate the quick reply.