Workaround find/replace in FM GO

[TBaker]

  So, here's the problem I'm running into - I have a mobile file that has a field with checkbox input, which of course separates multiple selections with a carriage return.  This causes visual issues when the report layout is run, and in desktop I got around that by using find/replace to replace the carriage return with a comma.

  Unfortunately, this isn't supported in ios.  Anybody have any ideas on how to get around this?  Thanks so much!

[Matthew F]

Unfortunately, this isn't supported in ios.

What exactly is not supported in iOS?  As far as I know, the 'substitute( )' function works fine in FM Go.  

[bruceR]

In addition to Matthew's comments: it isn't clear what you're doing. The very same field - where the use entered checkbox values - is being overwritten with the find/replace? So the user can no longer see what they have selected? 

 

For a single record the substitute command can work, as Matthew suggested. For multiple records, the replace command can do the job but since it operates across the found set you need to be sure you know what you're doing.

 

Can you say more about the report? Could you use a different, calc field to display the reformatted checkbox selections?