Skip to Content (Press Enter)
2020-10-10 16-14-30
Piya Singh
32Views
2Comments
Add p tag in string SQL
Question
Mobile
Reactive
Traditional Web
Service
Application Type
Traditional Web, Mobile, Reactive, Service

Hi All,

I have one problem in my data and I want to update by SQL.

Data is like-

[30-01-2022] This is test record. [02-02-2022] This is dummy record.

[30-01-2022] This is test record.

<p>This is dummy data </p>


But I need to update it like this way-

<p>[30-01-2022] This is test record.</p> <p> [02-02-2022] This is dummy record.</p>

<p>[30-01-2022] This is test record.</p>

<p>This is dummy data </p>


I have another way where I can create Action/Timer and fetch this record and do loop and add string update record one by one but its a long process I want do it by SQL Update command.

Please help me out.

Thanks in advance

Piya.

0
0
04 Apr 2022
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Piya,

Why do you want to add  HTML markup to your data? Generally speaking, you always want to separate representation and data. Why not read the data and when need to be presented on a page parse it to include the <p> and <p> html tag for each sentence?

Regards,

Daniel

1
0
04 Apr 2022
Copy Link
2020-10-10 16-14-30
Piya Singh

Hi @Daniël Kuhlmann , 

I have a screen which and download this data to word format by JS .

So p tag is show as bullet points that why i need to update it.

0
0
05 Apr 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.