أريد حذف أو إخفاء حرف من الحقل
M Matin_Murad Member Local time Yesterday, 19:17 Joined Jul 1, 2020 Messages 37 Nov 26, 2020 #1 أريد حذف أو إخفاء حرف من الحقل Attachments deletchar.png 14.7 KB · Views: 75
theDBguy I’m here to help Staff member Local time Yesterday, 19:17 Joined Oct 29, 2018 Messages 21,474 Nov 26, 2020 #2 To remove (hide), you could try using the Replace() function. Oh wait, are you trying to convert the data into numeric values?
To remove (hide), you could try using the Replace() function. Oh wait, are you trying to convert the data into numeric values?
C CJ_London Super Moderator Staff member Local time Today, 03:17 Joined Feb 19, 2013 Messages 16,616 Nov 26, 2020 #3 or the mid function mid(myField,2)
M Matin_Murad Member Local time Yesterday, 19:17 Joined Jul 1, 2020 Messages 37 Nov 26, 2020 #4 theDBguy said: لإزالة (إخفاء) ، يمكنك محاولة استخدام وظيفة Replace (). انتظر ، هل تحاول تحويل البيانات إلى قيم رقمية؟yes Click to expand...
theDBguy said: لإزالة (إخفاء) ، يمكنك محاولة استخدام وظيفة Replace (). انتظر ، هل تحاول تحويل البيانات إلى قيم رقمية؟yes Click to expand...
theDBguy I’m here to help Staff member Local time Yesterday, 19:17 Joined Oct 29, 2018 Messages 21,474 Nov 26, 2020 #6 Matin_Murad said: yes Click to expand... Is there always going to be only one character in the data?
M Matin_Murad Member Local time Yesterday, 19:17 Joined Jul 1, 2020 Messages 37 Nov 26, 2020 #7 theDBguy said: هل سيكون هناك دائمًا حرف واحد فقط في البيانات؟ Click to expand... نعم ، احذف حرفًا واحدًا من البيانات ... حقل لرقم Attachments onevalue (1).accdb 548 KB · Views: 79
theDBguy said: هل سيكون هناك دائمًا حرف واحد فقط في البيانات؟ Click to expand... نعم ، احذف حرفًا واحدًا من البيانات ... حقل لرقم
C CJ_London Super Moderator Staff member Local time Today, 03:17 Joined Feb 19, 2013 Messages 16,616 Nov 26, 2020 #8 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 نوصي باستخدام جوجل تترجم إلى حفظ كل واحد منا الحاجة إلى القيام بشكل منفصل Google Translate Google's service, offered free of charge, instantly translates words, phrases, and web pages between English and over 100 other languages. translate.google.com
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 نوصي باستخدام جوجل تترجم إلى حفظ كل واحد منا الحاجة إلى القيام بشكل منفصل Google Translate Google's service, offered free of charge, instantly translates words, phrases, and web pages between English and over 100 other languages. translate.google.com