How to omit new line in print section?

Question

0.00/5 (No votes)

See more:

Output content contains a (\n) new Line, so I can't able to store data in excel? What to do omit the new line in print section?

What I have tried:

for Linkedin_URL in URLs_all_Page:
		driver.get(Linkedin_URL)
		time.sleep(2)

		page_source = driver.page_source
		soup = BeautifulSoup(page_source, "html.parser")

		ExeName = soup.find('dt', {'class':'flex align-items-center'}).find('span', {'class':'profile-topcard-person-entity__name t-24 t-black t-bold'})
		
 -->       soup_ExeName = BeautifulSoup(ExeName.text, 'html.parser')

print(soup_ExeName,"|",soup_PreCompany,"|",soup_NewTitle,"|",soup_Company,"|",soup_tenur)

		   sheet.append([soup_ExeName, soup_PreCompany, soup_NewTitle, soup_Company, soup_tenur])

#---------------------------------------------------------------------------------------#
OutPut:

Masi Amianda
                 | Brandywine Nursing & Rehabilitation Center | Workers Compensation Senior Claim Adjuster | AIG | 
                                10 yrs

Cannot convert 
                    Masi Amianda
                 to Excel

Posted 8-Dec-21 21:12pm

Sriram Krishnamoorthy 2021

Updated 8-Dec-21 22:58pm

Add a Solution

Comments

Sriram Krishnamoorthy 2021 9-Dec-21 6:46am

Thank You! Richard.

soup_ExeName = BeautifulSoup(ExeName.text.replace("\n", ""), 'html.parser')

In this how to replace the excess space after Crystal Myers.

OutPut !

Crystal Myers | Solutions Staffing | Workers Compensation Specialist | Installed Building Products |
1 yr

Richard MacCutchan 9-Dec-21 7:36am

Not sure what you are asking. The replace function can replace any substring in a string with a new value of your choice as described at Built-in Types — Python 3.10.1 documentation[^]. You can also use the 'trim' functions to remove characters from the beginning and/or end of a string.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2021-12-08T22:58:00

Solution 1

You need to use the string replace function to replace the newline with nothing:

Python

soup_ExeName = soup_ExeName.replace("\n", "")

Posted 8-Dec-21 22:58pm

Richard MacCutchan