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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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