I am attempting to create a text file based on a table within my database.
One field is a text field, max 30 characters, that contains special characters (e.g. /],+.}_) in addition to text. I need to remove these special characters prior to exporting the data
e.g.
HELLO./WORLD]} needs converting to
HELLO WORLD or HELLO WORLD
The table is refreshed often from external souce so this is not a 'one-off' task, and conversion must take place on exporting the data (not when importing).
Thanks in advance for any assistance.
One field is a text field, max 30 characters, that contains special characters (e.g. /],+.}_) in addition to text. I need to remove these special characters prior to exporting the data
e.g.
HELLO./WORLD]} needs converting to
HELLO WORLD or HELLO WORLD
The table is refreshed often from external souce so this is not a 'one-off' task, and conversion must take place on exporting the data (not when importing).
Thanks in advance for any assistance.