[Visual Basic]
Private Function TranslateStringToCRFormula( _ 
   ByVal VBString As String _ 
) As String

Parameter

VBString

Quellcode

[Visual Basic]
    Private Function TranslateStringToCRFormula(ByVal VBString As String) As String 
 
        Dim Returnstring As String = "'" 
 
        'Split the string at every LF  
        For Each SubString As String In VBString.Split(Chr(10)) 
 
            SubString = SubString.Replace("'", "' & Chr(39) & '") 
 
            'Trim all the CR / LF characters  
            SubString = SubString.Trim(vbCrLf.ToCharArray) 
 
            'Form your string to the compatible CR Formula format. Chr(10) &nd Chr(13) should be inserted as a string, not as values!!  
            Returnstring = Returnstring & "' & Chr(10) & Chr(13) & '" & SubString 
 
        Next 
 
        Returnstring = Returnstring & "'" 
 
        Return Returnstring 
 
    End Function

Forderungen

Plattformen: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

Siehe auch

frmcrreporting