Remove <br> or spaces in a text string

[ER_Fukuda]

I need help removing spaces or new lines in a text string. I’m trying to connect google calendar to Microsoft calendar (it’s coming from a jotform form, they only have google calendar integration, but our company uses Microsoft 365)

I wanted to remove those white lines which are those
since it’s going to format as a new line or space. Thank you!

[Msquare_Automation]

Hi @ER_Fukuda
You can use html to text converter like this:

Inorder to just remove the <br> tag, just use replace function.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support| Book Live Implementation
Visit us here
Youtube Channel

[ER_Fukuda]

Thank you for the quick response @Msquare_Automation

If I do that, can I reformat the text? I want to keep some < br > like after the height & weight < br > etc.

Is that possible?

[Msquare_Automation]

Hi @ER_Fukuda
If you want to keep the other HTML styling intact, it’s best to use the replace function to remove all the <br> tags by replacing them with an empty string. Please note that this will replace all instances of the <br> tags.

[Msquare_Automation]

Hi @ER_Fukuda
If you want to remove the extra newline you can try the following method:
replace function:

Input text:

Output

[ER_Fukuda]

II tried different ways, but still won’t work

[Donald_Mitchell]

You could try splitting your text by <br> then rejoining them with {{newline}}.
By default, the split() function will not keep blank entries so all the duplicate <br> are basically removed then the remaining one is replaced/converted into a single newline.

[Msquare_Automation]

Hi @ER_Fukuda
If you could provide the output bundle from Google Calendar, we’ll be able to assist you further.

[ER_Fukuda]

Here’s the output bundle from google. it has those \ n tags I believe those are the new lines.