Remove Spaces from Cell or Remove Unwanted Characters | Excel Useful Formulas

 =TRIM(A1)

=TRIM(CLEAN(A1))

 

=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))

Conditional Lookup Functionality for List View Search using Automation Script isZombie() Method || IBM Maximo

Recently we had a requirement of conditional lookup for Maximo list view search. We have a custom column called sub-work type which is based on the value selected on the main work type attribute. This functionality on the application was working fine using table domain but it wasn't working on the list view in Maximo.

SO we developed a solution using conditional lookup automation script in Maximo list view search fields. First, we got the where clause of the current APP from memory in wclause variable, and then we got the work type i.e. CM or PM value using the split function. Then by using the zombie() method we set the work type value for a list where clause.

Object	WORKORDER
Type	ATTRIBUTE LAUNCH POINT (Jython)
Attribute	WOSUBTYPE
Name	WOSUBTYPE
Body	from psdi.common.context import UIContext appName = mbo.getThisMboSet().getParentApp() if appName in ('PLUSPWO','PLUSPWOCMP'): #Get Where clause for list view search     wclause = service.webclientsession().getCurrentApp().getResultsBean().getMboSet().getUserAndQbeWhere()   #Search worktype value of list view     if mbo.isZombie():          clause=wclause.split("worktype")[1].split("'")[1]          listWhere="worktype='"+clause+"'"

Find First Empty Column in a Row | Excel

If you want to find first EMPTY column in row, then use this formula into (column I) to find the index of the empty column (see column I). 

#N/A means there is no column , like row 3

 =MATCH(TRUE,INDEX(A3:G3="",0),0)