How can I insert the values of a string intact

[jenn1]

I need to insert the following string into a table:  1517 Electronics, Photonics, and Device Technologies (EPDT). What gets inserted instead is

1517 Electronics

Photonics

and Device Technologies (EPDT).

myString=1517 Electronics, Photonics, and Device Technologies (EPDT).

I'v used #PreserveSingleQuotes(myString)#

Any ideas as to what I'm dong wrong?

[Dan_Bracuk]

Somehow you are treating your string as a comma delimited list.

[craigkaminsky]

Hi, Jenn,

Can you post a bit more of the code related to your issue? As Dan mentioned, the string may well be acting as a list or, and along those same lines, it could be something with your SQL/Insert code but it's kind of tough to tell (for sure) without a little more code/details.

[Guest]

You can just embed the string in quotes and pass to the function in the following link which will return it in Array. You can then insert it to db. Please refer

http://cflib.org/udf/CSVtoArray