Hi All ,
I am getting a line break .How can I resolve this
Use the below syntex
Variable = Variable.toString().Replace(Environment.NewLine,"")
Hope it helps!!
Try this
Variable.Replace(Environment.NewLine, “”)
Variable.Replace(Environment.NewLine, String.Empty)
Variable…Replace(vbCr, “”).Replace(vbLf, “”)
@lrtetala
in_Config(“OutputFilePath”).ToString+now.Date.ToString(“dd-MMM-yyyy”)+“"+in_TransactionItem(“SubscriptionID”).ToString+”".Replace(vbCr, “”).Replace(vbLf, “”) something like this
First you have to store the
in_TransactionItem(“SubscriptionID”).ToString.Replace(vbCr, “”).Replace(vbLf, “”)
in variable then use
in_Config(“OutputFilePath”).ToString+"\"+Now.Date.ToString(“dd-MMM-yyyy”)+“\”+in_TransactionItem(“SubscriptionID”).ToString.ReplaceLineEndings("")+"\"+in_Config(“NetsuiteExtractedFilename”).ToString+“.xlsx”
or
in_Config(“OutputFilePath”).ToString+"\"+Now.Date.ToString(“dd-MMM-yyyy”)+“\”+in_TransactionItem(“SubscriptionID”).ToString.ReplaceLineEndings("")+"\"+in_Config(“NetsuiteExtractedFilename”).ToString
Hope it helps!!
Please try this
System.Text.RegularExpressions.Regex.Replace(Path.Combine(in_Config("OutputFilePath").ToString.Trim,now.ToString("dd-MMM-yyyy"),in_TransactionItem("SubscriptionID").ToString.Trim),"\r?\n","")
Cheers
Try this
Path.Combine(in_Config(“OutputFilePath”).ToString,Now.Date.ToString(“dd-MMM-yyyy”),in_TransactionItem(“SubscriptionID”).ToString.ReplaceLineEndings(“”),in_Config(“NetsuiteExtractedFilename”).ToString)