Storing strings in a 'temporary' workspace

activities
sql
string

#1

I have a translation database set up that is used to translate Spanish words obtained from my application to English. I am currently splitting each multi word description into a CharArray and am using a ForEach to loop through each word so it encompasses the description in its entirety. I am using a Type Into to replace the data once it is ran through my ‘translator’. This is extremely slow and I’m trying to figure out a way to speed it up by doing the translation in some sort of ‘temporary’ workspace where it takes the end result of each word, adds a space between each, and then finally uses a set text to replace with the ‘translated’ results. If anyone could point me in the right direction I would greatly appreciate it!


#2

I was able to set up a SQL query that accomplished this the way I wanted it to