Scripting

  • 1.  Be gentle and remember there should be a ""BEGINNIN

    Posted 09-14-2015 12:30
    Be gentle and remember there should be a ""BEGINNING Scripting"" group, as well. Am trying to write a string field that could have carriage returns in it. When you look at the script error, the field looks like ""NotesNotesNotes"" in one spot (there is actually a carriage return after each ""Notes"") but in the other spot it just shows ""Notes and leaves off the rest of it (including the closing double quotation mark). Is this something that can't be done?


  • 2.  RE: Be gentle and remember there should be a ""BEGINNIN

    Posted 09-14-2015 12:35
    If you are creating the string in VBscript with carriage returned in it: Str = ""Note1"" + vbCRLF + ""Note2"" should output: Note1 Note2 vbCRLF (no quotes around it) is the visual basic constant for carriage return/line feed, like chr(10) + chr(13) in Crystal formulas


  • 3.  RE: Be gentle and remember there should be a ""BEGINNIN

    Posted 09-14-2015 12:36
    FYI, chr(10) + chr(13) works in vbscript, too.


  • 4.  RE: Be gentle and remember there should be a ""BEGINNIN

    Posted 09-14-2015 12:37
    I'm actually pulling in a string someone is typing in on the screen


  • 5.  RE: Be gentle and remember there should be a ""BEGINNIN

    Posted 09-14-2015 12:40
    The question is are there actually carriage returns in the data or is it just wrapping on the screen. If you copy and paste from the screen they are typing in into notepad does it wrap?


  • 6.  RE: Be gentle and remember there should be a ""BEGINNIN

    Posted 09-14-2015 12:59
    I tested it myself and it works if I just wrap, but gives me the error if I put actual CRs in there. I suspect I will have to substitute them out and then put them back in using either of the first two notations? ACK!