Please tell me how to remove half-width and full-width spaces.

Question

Please tell me how to remove half-width and full-width spaces.

NishimuraChinatsu-9854 756

I'd like to use synpase pipeline to check my data.

I'd like to remove any single-byte or double-byte spaces in the data flow.

I don't want to remove the numerical values of the data, only the spaces.

AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2023-02-24T05:21:02.25+00:00

Hi @ ponponpon ,

Just checking in to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

Accepted answer

0 additional answers

Your answer

AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2023-02-24T05:21:02.25+00:00

Hi @ ponponpon ,

Just checking in to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

Answer 1

AnnuKumari-MSFT 34,556 Microsoft Employee Moderator

Hi @NishimuraChinatsu-9854 ,

Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you want to remove the spaces from the source data of your dataflow. Please let me know if that is not the ask here.

You can use trim() function to remove the leading and trailing spaces from a string.

In case your requirement is to remove all the spaces from middle of the string too in a particular column, then use: replace(' ','') or in case you have to perform the same transformation with all the columns then use column pattern with the following expression: regexReplace($$,' ','')

Additional resources: Column patterns in derived column and aggregate

Hope it helps. Please accept the answer if it was helpful and click on Yes for Was the answer helpful survey

NishimuraChinatsu-9854 756 Reputation points

2023-02-24T08:22:00.22+00:00

Is it possible to use half-width and full-width at the same time?
AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2023-02-28T19:08:59.4966667+00:00

ponponpon ,

You can use trim(trim(ABC,' '),' ') .

If it was helpful, kindly accept the answer. Thanks

Share via

Please tell me how to remove half-width and full-width spaces.

0 additional answers

Your answer