Search results for query: *

Without more information on the format and possible entries it is difficult to provide what you need. That said - working on the basis that you only want 4 Character entries you can use the following: if len(trim(extractstring(strreverse({table.field}),'',','))) = 4 then...

You can also utilise extractstring({eventlog.field},'\','connected') if the same string text is always utilised. CR8.5 / CRXI - Discovering the impossible

With any report of this type validate your results by turning the report on its head temporarily and selecting only those records which ought match your spec for the training category. In other words either amend your selection criteria to: {PRGL.GLAcct} in...

I think englandgreen is asking that the user can select a range (e.g. Jan 2012) and the report which is normally based on lastfullmonth can be ran to look at the date range specific instead of just the last full month. Rather than the selection criteria it is the other component parts of the...

When dealing with text descriptors consider case sensitivity as well. You asked if it was possible to suppress based on a specific word in the description as well as by code, yes you can do so. But it is good practise to standardise the input to your formula as much as possible to avoid...

If the aim is simply to remove any such excessive spacing then a basic: replace({table.field},' ','') would solve the issue for any form of slash or other symbol and any number of occurences. This would however not resolve single spaces pre or post such symbols so the answer yourself and LBass...

What result from: replace(Join({?testparam - Productname},","),',','','') compared to: "'"+join(({?testparam - Productname},"','")+"'" Try writing out the question again perhaps giving as much info and examples as possible. 'J CR8.5 / CRXI - Discovering the impossible

Hi Javedi, If you follow the instructions from Madawc you will find that the final record for each group based on date will be shown (check that you have grouped appropriately (e.g. date group sort based on seconds not day)). If two events occur in the same second then expect multiple records...

Either use totext() on the number field OR use tonumber() on the string field. 'J CR8.5 / CRXI - Discovering the impossible

Create 3 formulas and lay them out in any way you prefer. //{@shelf} split({yourfield},".")[2] //{@Slot} split({yourfield},".")[3] //{@port} split({yourfield},".")[4] 'J CR8.5 / CRXI - Discovering the impossible

trimright() is the function you describe. 'J CR8.5 / CRXI - Discovering the impossible

It depends if your blank field is null or just blank. Test for both and as with all null checks the null test comes first. //selection criteria isnull({table.date}) or trim({table.date}) like '' and whatever the rest of your selection criteria is... 'J CR8.5 / CRXI - Discovering the impossible

'J CR8.5 / CRXI - Discovering the impossible

Is that not correct? 50% of $6.00 is $3.00.... What percentage were you expecting? 'J CR8.5 / CRXI - Discovering the impossible

A quick search shows the following relevant posts: http://www.tek-tips.com/viewthread.cfm?qid=1470920 http://www.tek-tips.com/viewthread.cfm?qid=1466511 http://www.tek-tips.com/viewthread.cfm?qid=1423898 It seems that the same answer is popping up quite often. 'J CR8.5 / CRXI - Discovering...

If it is always 'NQ' then Try the following: strreverse(extractstring(strreverse({@string}),'','QN')) This would only work when the NQ is the last entry in the string but will suffice for any length. 'J CR8.5 / CRXI - Discovering the impossible

isnull({field}) or {field} like '* *' 'J CR8.5 / CRXI - Discovering the impossible

If your other formula is already in use for display purposes just point the new formula at it for reference. In the quote above just replace {@Description} with the name of your exisiting formula which contains: 'J CR8.5 / CRXI - Discovering the impossible

The abs would be used on the specific number values: Did you get an error using: Or did it simply not have any output? 'J CR8.5 / CRXI - Discovering the impossible

This may read a little better: 'J CR8.5 / CRXI - Discovering the impossible