How is your experience with the OutSystems Community?
22
Views
7
Comments
Using normalise function server side
Question

Hi All,

Wanted to remove the latin or any chars and convert the word into normal english,

For ODC,

Ex Bãngalore  Bangalore are same city,

I wanted to to do on server side this logic and do not want to use javascript,

Is there component to check the entered city to return with normalised city 



2026-05-21 04-48-12
Deepa Tiwari

Hi @Preeti zade ,

I wouldn't recommend solving this by manually normalizing every user-entered city name.

A better long-term approach is to maintain a master data model for Country → State/Province → City and avoid free-text entry altogether.

Recommended solution:

  • Create or integrate a master database containing Countries, States, and Cities.

  • Present cities in a searchable dropdown/autocomplete instead of a text input.

  • Store the City ID (or a standard city code) rather than the city name.

  • Display the canonical city name (e.g., "Bangalore"), regardless of what the user initially types.

This approach eliminates issues such as:

  • Bãngalore

  • Bangalóre

  • Bangalore

  • Bengaluru

All can map to the same master record.

If you still need to accept free-text input (e.g., data imports or external integrations), then normalize the input on the server by:

  1. Removing diacritics/accents (Unicode normalization).

  2. Converting to lowercase.

  3. Trimming extra spaces.

  4. Looking up the normalized value against the master city table or an alias table (e.g., "Bengaluru", "Bangalore", "Bãngalore" → CityId = Bangalore).

This provides a scalable and maintainable solution compared to trying to handle every possible character variation manually.

Hope this will help you.
Regards

Deepa Tiwari

UserImage.jpg
Preeti zade

Hello,

Thank you,

but we cant maintain master data,as of now we just need to remove the accents and compare,so if any logic to be checkd on server side,

Regards

2026-01-28 16-57-48
Mihai Melencu
Champion

Hi @Preeti zade ,

You can check this forge component: RemoveDiacritics - Overview (ODC) | OutSystems . 

UserImage.jpg
Preeti zade

Its not supported 

This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the comunity. 

2026-03-13 15-51-13
Samuel Espinoza

This post explain about this kind of components, there're a lot of Forge components that are not "supported" by Outsytems but rather by the community itself. 

https://www.outsystems.com/forums/discussion/102760/clarification-regarding-outsystems-labs/

2026-01-28 16-57-48
Mihai Melencu
Champion

Most Forge components are community-developed and community-maintained, so they are not officially supported by OutSystems. That doesn't mean they are untrustworthy, many are widely used and well maintained.

If you prefer not to use a Forge component, you have two main options:

  • Build a custom .NET extension that performs the normalization server-side, similar to what those components do.
  • Implement the logic directly in OutSystems.

For a pure OutSystems implementation, I would recommend creating an entity (or static entity) that maps diacritic characters to their normalized equivalents.

For example:

 In my example I used a Static Entity, since these mappings are typically fixed. However, a normal entity may be easier to maintain, as it would allow bulk imports and even an admin screen to manage the mappings without republishing the application.

Next, you will need to create a Server Action to normalize the text. 

Iterate through the input string one character at a time using a For or While loop. For each character, check whether it exists as an OriginalCharacter in your mapping entity. If a match is found, append the corresponding NormalizedCharacter to the result; otherwise, append the original character. By repeating this until you reach the end of the string, you'll build the fully normalized text. 

2025-09-25 14-38-22
Lokesh Kumar Yadav

For ODC, you can handle this on the server side by using string normalization to remove accented or special characters. For example, converting “Bãngalore” to “Bangalore”. There is no built-in OutSystems function specifically for this, but you can achieve it using a .NET extension/component or by creating a reusable server action that normalizes Unicode characters. You can also check Forge components related to text normalization or Unicode handling if you want a reusable solution without JavaScript.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.