Hi Some one can help me with this ?
Notice i dont want to use a loop or a CUSTOM Code.
I am using filter expression :
"IIF([Sas] LIKE '%"&Chr(10)&"%', REPLACE([Sas],'"&Chr(10)&"','') , [Sas]) = 'Foreign'"
To explain i have a column Sas that contain Foreign but we have an issue we have a Chr(10) in the column i mean it can be F&Chr(10)&oreign or Foreign&Chr(10) Or sometimes Chr(10)&Foreign or Chr(10) can be in the middle. Any idea ?
Thank you
