I want to split the description as below.
“Video Conference-Non stock” item.
I am not sure as to how do I split this or get data to the left of ‘-’
I did try using the Instr and Strrev function to no avail.
Can I please receive some suggestions on this.
Best answer by nhatnghetinh
Please use InStr( str, findStr ) and Left( str, length ) combined with IIF function.
For example:
= IIf( InStr( [InventoryItem.Descr], '-' ) > 0
, Left( [InventoryItem.Descr], InStr( [InventoryItem.Descr], '-' ) )
, [InventoryItem.Descr] )
Best Regards,
NNT
+11Please use InStr( str, findStr ) and Left( str, length ) combined with IIF function.
For example:
= IIf( InStr( [InventoryItem.Descr], '-' ) > 0
, Left( [InventoryItem.Descr], InStr( [InventoryItem.Descr], '-' ) )
, [InventoryItem.Descr] )
Best Regards,
NNT
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
