How to add <br></br><br></br> after every line in text file

Help Automation Ops
,
1

I have a text file which contains JSon data as below: I want to add



after every line in the text file . How can I achieve this

{
“Order_Form_Discrepancies__c”="
Primary Contact Sudheer Grandhi / Offer Valid Until Jul 10, 2023
Address 123457 Fremont St 12345 test Contact Name Amelia Burke
Contract Value $100,000.00 Usage/Support Related
Services & Fees Details See Attachment 1 (Usage/Support Related)
invoices are Net 30.
Service Duration/Term 12 Months. From Jun 10, 2023 (Start Date) – Jun 9, 2024 (End Date)
Effective Date (“Effective Date”).
AWS Direct Commit Usage Commitment for Databricks on $100,000.00 $100,000.00
SUBTOTAL – Universal Usage Commitment (UUC) $100,000.00
TOTAL – Universal Usage Commitment and associated Support Service above $100,000.00
Documentation. In order to facilitate Customer’s option to procure and/or use then-currently available Databricks Services,
the Agreement is expanded to allow that different architectural models may apply to features Customer elects to use (such
as where computing and/or storage resources are deployed) as further described in the Documentation.
notifies Customer.
SPECIAL TERMS
Services total contract value of at least $778 , Customer may continue to consume any unused portion of the Universal Usage
SCOPE Included. Non-compliance with this SLA is assessed by measuring Unexcused Downtime across the Maximum
Below 99.9% but equal to or above 99.0% 10%"

}

2

Hi @dutta.marina

What is your input and your expected output.

Regards

3

Duplicate / Cross Reference:

4

@Parvathy

I am getting the below error when trying to upload data using PATCH activity. I should upload the JSon file attached. Currently I have attached in docx format but its in text file. i need to upload that file but I am getting below error

image
image1920×1108 155 KB

QuoteJsonData_discrepency.docx (1.3 KB)

5

in json we are using :
{“myKey”:“myValue”}

still we cannot derive the details from your question, what is needed, input …

However keep in mind: when we want to construct a JSON, which have linebreaks inside a string we can express with \n

grafik

6

@ppr
My question is

Suppose if this is my JSON file .How to upload the data as I am getting below error
[
{
“message”: “Unexpected character (‘=’ (code 61)): was expecting a colon to separate field name and value at [line:2, column:31]”,
“errorCode”: “JSON_PARSER_ERROR”
}
]
QuoteJsonData_discrepency.docx (1.3 KB)

QuoteJsonData_discrepency.docx (1.3 KB)

7

we assume you do mean the samples from docx (we cannot open, share it as txt file)

when it is about:

grafik
grafik1071×320 112 KB

then we already told (similar to the returned message):

  • it is JSON we use :

Also you can Validate any JSON in e.g. https://jsonlint.com/

8

remove the line break from the string write to text file then upload the JSON file

image
image790×186 17.7 KB

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.