Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
eduazzolin
New Member

Nothing happens when I replace " " for "".

I have a text column that I'm trying to convert to int, but for that I need to remove the white spaces between the numbers.

eduazzolin_0-1683207571420.png

I tryied the replace values option but nothing happens:

eduazzolin_1-1683207611151.pngeduazzolin_2-1683207657171.png

 

 

1 ACCEPTED SOLUTION
eduazzolin
New Member

Update: I found the problem. The data came from a website in which the spaces were like " " instead of " ". So i downloaded the html, replaced everything and reimported. 🥲

View solution in original post

1 REPLY 1
eduazzolin
New Member

Update: I found the problem. The data came from a website in which the spaces were like " " instead of " ". So i downloaded the html, replaced everything and reimported. 🥲

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.