...
| Page Properties | |||||||
|---|---|---|---|---|---|---|---|
| |||||||
|
When we use data that comes from remote services such as Elgin Roadworks or Uniform we have no control over the data that gets sent through. Often this includes badly encoded characters, which look like gobbledegook when displayed as part of iShare. Luckily we can strip out these characters with a regular expression string replacement function in PostgreSQL.
...
| Tip |
|---|
This can be included in an at_sys_create_table or an at_sys_executecmd Stored Stored Procedure Task in iShare Studio. |
Studio (from v6.0.0 these are called wkf_create_table & wkf_executecmd respectively, under the -Workflow- Function filter). |