Line break in string

[marina.dutta]

Hi All ,

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

[pravallikapaluri]

Hi @marina.dutta

Use Trim function

Hope it helps!!

[supriya117 (Supriya Allada)]

HI @marina.dutta

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

[mkankatala (Mahesh Kankatala)]

Hi @marina.dutta

Use the below syntex

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

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @marina.dutta

Try this

Variable.Replace(Environment.NewLine, “”)

Variable.Replace(Environment.NewLine, String.Empty)

Variable…Replace(vbCr, “”).Replace(vbLf, “”)

[marina.dutta]

@lrtetala
in_Config(“OutputFilePath”).ToString+now.Date.ToString(“dd-MMM-yyyy”)+“"+in_TransactionItem(“SubscriptionID”).ToString+”".Replace(vbCr, “”).Replace(vbLf, “”) something like this

[lrtetala (Lakshman Reddy)]

@marina.dutta

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

in variable then use

[supriya117 (Supriya Allada)]

@marina.dutta

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

[lrtetala (Lakshman Reddy)]

@marina.dutta

Try this

Split=Var.ReplaceLineEndings("")

I hope it helps!!

[lrtetala (Lakshman Reddy)]

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

[Anil_G (Anil Gorthi)]

@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

[lrtetala (Lakshman Reddy)]

@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)