Fix Full-width Characters

Hi there,

I’m wondering if there’s any way to change the full-width character to the half-width character.
Screen Shot 2022-01-24 at 1.48.24 PM

This happens because Japanese keyboard allows full-width character, but it would be great if I can clean up these types of data.

Thanks,
Akiko

Hi @Akiko, we can format these numbers in a Find and replace rule step. To set this up, you will need to set up multiple rules such that each symbol and a numeric value will get updated from fixed-width to variable-width.

  • Find “-” and replace with “-”
  • Find “1” and replace with “1”
  • Find “2” and replace with “2”

Passing along a snippet that @Ayana_Usui configured for you! Feel free to paste it into your Flow:
parabola:cb:ad06247f-6a68-49c0-ab16-450eea6dea66

Hope that helps!

Hi @daniel, thank you for your quick response! yes, that way totally worked.
and thank you @Ayana_Usui for creating the step for me!

2 Likes