I have an Application field that has either one or more than one Application name. I use a replace to get ride of any spaces. The App names are separated by a comma. My code is as follows:
if(isNull(Application),'NIL', if(Application like '*,*',
Replace(Subfield("Application",','),' ', ''), Replace(Application, ' ', '')))
The problem is with a value like "App A, App B - XXX, App C - XXX"
The desired result would be like so:
However I am getting only AppA
Any ideas on how I can achieve this splitting?
Update: Am able to split the Application names correctly, it is when linked with another table that only the first Application name appears in the straight table.
can you share your mock source data?
also u can try like this (it should work if your application value within double quote)
load *, SubField(Application,',') as Application_Revised;
load * Inline [
Using mock data both fields is correct
if(Application like '*,*',
Subfield(Replace(Application, ' ', ''), ','),
Application) as App,
subfield(trim(Application),',') as test,
Application as testApplication,
Subfield(Application, ',') as testSF;
Load * inline [
Am thinking when linked with my report table, somehow only the first App name is kept...