Line break in string

Hi All ,

I am getting a line break .How can I resolve this

Hi @marina.dutta

Use Trim function

Hope it helps!!

HI @marina.dutta

Try this:
originalText.Replace(Environment.NewLine, “”)

Hi @marina.dutta

Use the below syntex

Variable = Variable.toString().Replace(Environment.NewLine,"")

Hope it helps!!

Hi @marina.dutta

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

@marina.dutta

First you have to store the
in_TransactionItem(“SubscriptionID”).ToString.Replace(vbCr, “”).Replace(vbLf, “”)

in variable then use

@marina.dutta

str_var = in_Config(“OutputFilePath”).ToString.ReplaceLineEndings("\")

@marina.dutta

Try this

Split=Var.ReplaceLineEndings("")

I hope it helps!!

@marina.dutta

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!!

@marina.dutta

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

@marina.dutta

Try this

Path.Combine(in_Config(“OutputFilePath”).ToString,Now.Date.ToString(“dd-MMM-yyyy”),in_TransactionItem(“SubscriptionID”).ToString.ReplaceLineEndings(“”),in_Config(“NetsuiteExtractedFilename”).ToString)