I want to delete or hide a character from the field (1 Viewer)

Matin_Murad

Member
Local time
Today, 14:49
Joined
Jul 1, 2020
Messages
37
أريد حذف أو إخفاء حرف من الحقل
 

Attachments

  • deletchar.png
    deletchar.png
    14.7 KB · Views: 71

theDBguy

I’m here to help
Staff member
Local time
Today, 14:49
Joined
Oct 29, 2018
Messages
21,358
To remove (hide), you could try using the Replace() function.

Oh wait, are you trying to convert the data into numeric values?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 21:49
Joined
Feb 19, 2013
Messages
16,553
or the mid function

mid(myField,2)
 

Matin_Murad

Member
Local time
Today, 14:49
Joined
Jul 1, 2020
Messages
37
هل سيكون هناك دائمًا حرف واحد فقط في البيانات؟
نعم ، احذف حرفًا واحدًا من البيانات ... حقل لرقم
 

Attachments

  • onevalue (1).accdb
    548 KB · Views: 75

CJ_London

Super Moderator
Staff member
Local time
Today, 21:49
Joined
Feb 19, 2013
Messages
16,553
translates to:

Yes, delete one character from the data ... a field for a number

@Matin_Murad recommend you use google translate to save each of us having to do it separately

نوصي باستخدام جوجل تترجم إلى حفظ كل واحد منا الحاجة إلى القيام بشكل منفصل

 

Users who are viewing this thread

Top Bottom