تحويل فقرة لكلمات برقم الكود

[ابو جودي]

2 ساعات مضت, girl said:

هدف البرنامج تحليل مجموعة من النصوص من خلال عرضها على قاموس مفردات إنجليزي مبوب.

يعني الجداول المتوقعة :

1- قاموس مفردات إنجليزية مصنف (متوفر).

2- مجموعة من الفقرات والجمل (متوفر)

والفكرة بالأساس كانت الطريقة التي من الممكن مقابلة مفردات القاموس مع كل كلمة من جدول الفقرات والنصوص ، لتحليلها

فكانت الفكرة الاولية هي تحويل هذه النصوص والفقرات إلى كلمات مفردة ، ليمكن مقابلتها مع كلمات مفردات القاموس ... كمرحلة أولى

ثم تحليل النتائج كمرحلة ثانية

هذا هو الموضوع.

 

السلام عليكم ورحمة الله تعالى وبركاته
بعد اذن معلمى القدير واستاذى الجليل ووالدى الحبيب الاستاذ  jjafferr 

لو كان الموضوع يخص التقسيم والترجمة ممكن الاطلاع على هذا المرفق هذه تجربة فى المرفق هى حاصل ونتائج النقاش فى هذا الموضوع 

 

translation_name.rar

[jjafferr]

الظاهر يا اختي اننا لا نتكلم عن نفس الشئ!!

فقد قمت بعمل المطلوب في مشاركاتي السابقة ، ويوجد لديك جدول مؤقت اسمه Table2 ، فما عليك إلا ان تعملي استعلام منه 

 

واذا لم يكن هذا قصدك ، فاعتقد انه من الافضل ان اتوقف انا ، وان يواصل معك الاستاذ رمهان ، فقد ينظر للموضوع من وجهة نظر اخرى

 

جعفر

[girl]

42 دقائق مضت, jjafferr said:

الظاهر يا اختي اننا لا نتكلم عن نفس الشئ!!

فقد قمت بعمل المطلوب في مشاركاتي السابقة ، ويوجد لديك جدول مؤقت اسمه Table2 ، فما عليك إلا ان تعملي استعلام منه 

 

واذا لم يكن هذا قصدك ، فاعتقد انه من الافضل ان اتوقف انا ، وان يواصل معك الاستاذ رمهان ، فقد ينظر للموضوع من وجهة نظر اخرى

 

جعفر

استاذ جعفر ، حضرتك بالفعل عملت المطلوب تماما وبدقة عالية بس انا كنت عايزاه بدل ما يخرج في جدول2 يخرج في استعلام تحديد

واسفة اذا كنت ازعجتك

عموما انا هاحاول اشوف طريقة اخليه يطلع في استعلام بدل جدول عشان حجم الداتا كبير جدا والاحتفاظ بيها في جداول هيسبب مشكلة

 

وشكرا بجد على مجهوداتك

[jjafferr]

هل تريدين ان اصدر البيانات الى الاكسل؟

 

جعفر

[girl]

لا اريد كل المادة على اكسيس :)

[ابو جودي]

11 دقائق مضت, girl said:

لا اريد كل المادة على اكسيس :)

السلام عليكم ورحمة الله وبركاته

هو لو انا فهمت صح وحضرتك عاوزة فصل الكلمات لمقابلتها بالترجمة

هل عند حضرتك  مفردات إنجليزية جاهزة فى جدول خاص بتلك المفردات ؟

[girl]

هذا جزء من تصنيف واحد ضمن عشرات التصنيفات    فالداتا كبيرة جدا

0All

F1
Don't get this...keep browsing.
The iPod has so far been one of the most advertised and populated MP3 players so far.
I'm still figuring out why.
features[-2] There isn't much features on the iPod at all, except games.
My friend has this unit while not experience it much, I look at other reviews on this site and tried out the unit at Best Buy, and it's definitely the most overrated gadget in history.
sound[+2] SOUND QUALITY: The iPod's sound quality is pretty good.
The Creative player sounds a bit better, but not anything to worry about.
equalizer[-1] It has an equalizer, but the iRiver H-GB has a lot more presets than the iPod.
bass[+3],treble[+2] The bass is deep and the treble is clear.
battery[-2] DURABILITY: Not good. First problem, if you haven't seen the news recently, the iPods are being recalled for battery problems and not lasting the advertised months.
This is really stupid to me. months for a battery isn't good, actually, it's medicore.
iRiver's battery lasts four to five years.
Replaceable battery[-3] Also, the battery's AREN'T USER REPLACEABLE.
However, the Creative and iRiver players are (Rio's isn't), and they only cost around $ to replace, while iPod charges shipping and technical support.
The iPod's battery, 1.5 years.
Yeah, pretty weak.
flip side[-2] Another thing you should know, the metal on the flip side of the iPod is very tacky, and scratches very easily.
While all MP3 players are easy to scratch, the iPod is the worst of the Creative and iRiver.
case[-2] Also, not liking the gel case.
iRiver's seems a lot more sturdier than the iPod's.
features[-3] FEATURES: Really, there aren't any features, unless you call the games a feature.
FM tuner[-3] There is no FM tuner, while there is no FM tuner on the Creative Zen (on the micro version of the Zen there is a tuner), the iRiver H-GB, the Rio Karma, and the iAudio X5 have FM tuners.
voice recording[-3] There is also no voice recording, something most if not all MP3 players have that the iPod doesn't.
photo viewing[-1] There is no photo viewing option, however, there is a GB photo iPod, but it costs $ more.
There is an alarm and timer, but most MP3 players have this feature.
use[+3] EASE OF USE/DESIGN: The iPod is a very easy to use MP3 player, and if you can't figure this out, you shouldn't even own one.
The Click Wheel is a great design, something no one else came up with (however, the iRiver has a touchpad).
iTunes[-1] I'm probably the only person that dislikes the iTunes software.
I just don't like it, the weird thing is, I don't know why I dislike it.
Maybe because it doesn't have a lot of skins to choose from like WMP, but then again, I dislike WMP as well because it's slow on my computer.
Anyhow, adding music to the player is easy.
BATTERY LIFE: Pretty medicore at hours, the Creative, iAudio, Rio, and iRiver players last longer.
CUSTOMER SERVICE[-3] CUSTOMER SERVICE: Awful. Listen to this one, remember the battery statement I made earlier.
If your battery dies and it's still under warranty, guess what, you're out of luck, because Apple doesn't cover the battery in the iPod warranty.
They have the nerve to charge you $ for a warrantied iPod.
technical service[-3] There technical service isn't helpful either; they just read what's on their website and charge you $ (+ toll fees) to do it.
At least Creative and iRiver's only charge toll fees like most companies.
iPod[-3], sound quality[+2], design[+2] OVERALL: I highly dislike the iPod, even though the sound quality and design is above-average.
Maybe in their 5th generation they'll add features to the iPod. But for now, pleases don't buy this, and buy a Creative Zen or the iRiver H-GB instead.

وده جزء من القاموس

 

word	Pos	Vocabulary	Past	Present	Future	positive	negative	Feeling
persistent	s		0	0	0	1		1
convenient	a		0	0	0	1		1
unquestioned	s
stipulatory	s
agreed upon	s
argumentative	a		0	0	0		1	1
quarrelsome	s	Feelings and Emotions	0	0	0		1	1
untethered	s		0	0	0
disputative	s
disputatious	s
combative	s						1	1
contentious	s		0	0	0		1	1
eristical	s
eristic	s		0	0	0
harnessed	s		0	0	0			1

 

المطلوب تحليل الجمل اللي في جدول 0All

عن طريق تمرير كلمات القاموس عليها من جدول word

مع ارفاق البيانات الأخرى من جدول word في النتائج

[ابو جودي]

22 دقائق مضت, girl said:

هذا جزء من تصنيف واحد ضمن عشرات التصنيفات    فالداتا كبيرة جدا

0All

F1
Don't get this...keep browsing.
The iPod has so far been one of the most advertised and populated MP3 players so far.
I'm still figuring out why.
features[-2] There isn't much features on the iPod at all, except games.
My friend has this unit while not experience it much, I look at other reviews on this site and tried out the unit at Best Buy, and it's definitely the most overrated gadget in history.
sound[+2] SOUND QUALITY: The iPod's sound quality is pretty good.
The Creative player sounds a bit better, but not anything to worry about.
equalizer[-1] It has an equalizer, but the iRiver H-GB has a lot more presets than the iPod.
bass[+3],treble[+2] The bass is deep and the treble is clear.
battery[-2] DURABILITY: Not good. First problem, if you haven't seen the news recently, the iPods are being recalled for battery problems and not lasting the advertised months.
This is really stupid to me. months for a battery isn't good, actually, it's medicore.
iRiver's battery lasts four to five years.
Replaceable battery[-3] Also, the battery's AREN'T USER REPLACEABLE.
However, the Creative and iRiver players are (Rio's isn't), and they only cost around $ to replace, while iPod charges shipping and technical support.
The iPod's battery, 1.5 years.
Yeah, pretty weak.
flip side[-2] Another thing you should know, the metal on the flip side of the iPod is very tacky, and scratches very easily.
While all MP3 players are easy to scratch, the iPod is the worst of the Creative and iRiver.
case[-2] Also, not liking the gel case.
iRiver's seems a lot more sturdier than the iPod's.
features[-3] FEATURES: Really, there aren't any features, unless you call the games a feature.
FM tuner[-3] There is no FM tuner, while there is no FM tuner on the Creative Zen (on the micro version of the Zen there is a tuner), the iRiver H-GB, the Rio Karma, and the iAudio X5 have FM tuners.
voice recording[-3] There is also no voice recording, something most if not all MP3 players have that the iPod doesn't.
photo viewing[-1] There is no photo viewing option, however, there is a GB photo iPod, but it costs $ more.
There is an alarm and timer, but most MP3 players have this feature.
use[+3] EASE OF USE/DESIGN: The iPod is a very easy to use MP3 player, and if you can't figure this out, you shouldn't even own one.
The Click Wheel is a great design, something no one else came up with (however, the iRiver has a touchpad).
iTunes[-1] I'm probably the only person that dislikes the iTunes software.
I just don't like it, the weird thing is, I don't know why I dislike it.
Maybe because it doesn't have a lot of skins to choose from like WMP, but then again, I dislike WMP as well because it's slow on my computer.
Anyhow, adding music to the player is easy.
BATTERY LIFE: Pretty medicore at hours, the Creative, iAudio, Rio, and iRiver players last longer.
CUSTOMER SERVICE[-3] CUSTOMER SERVICE: Awful. Listen to this one, remember the battery statement I made earlier.
If your battery dies and it's still under warranty, guess what, you're out of luck, because Apple doesn't cover the battery in the iPod warranty.
They have the nerve to charge you $ for a warrantied iPod.
technical service[-3] There technical service isn't helpful either; they just read what's on their website and charge you $ (+ toll fees) to do it.
At least Creative and iRiver's only charge toll fees like most companies.
iPod[-3], sound quality[+2], design[+2] OVERALL: I highly dislike the iPod, even though the sound quality and design is above-average.
Maybe in their 5th generation they'll add features to the iPod. But for now, pleases don't buy this, and buy a Creative Zen or the iRiver H-GB instead.

وده جزء من القاموس

 

 

word	Pos	Vocabulary	Past	Present	Future	positive	negative	Feeling
persistent	s		0	0	0	1		1
convenient	a		0	0	0	1		1
unquestioned	s
stipulatory	s
agreed upon	s
argumentative	a		0	0	0		1	1
quarrelsome	s	Feelings and Emotions	0	0	0		1	1
untethered	s		0	0	0
disputative	s
disputatious	s
combative	s						1	1
contentious	s		0	0	0		1	1
eristical	s
eristic	s		0	0	0
harnessed	s		0	0	0			1

 

 

المطلوب تحليل الجمل اللي في جدول 0All

عن طريق تمرير كلمات القاموس عليها من جدول word

مع ارفاق البيانات الأخرى من جدول word في النتائج

ممكن لو تكرمتى اول شئ حضرتك ترفقى قاعدة بيانات تحتوى على الجدول word   اللى على حسب فهمى هو قاموس المفردات صح كده

[girl]

Database43.rar

[ابو جودي]

1 دقيقه مضت, girl said:

Database43.rar

طيب تمام 
المفروض بئه ايه اللى هيحصل

هل هيتم ادخال بيانات فى جدول بالعربى

والمفروض ترجمة تلك البيانات بما يقابلها من كلمات الى الانجليزية من الجدول المرفق ؟1

 

[jjafferr]

3 ساعات مضت, girl said:

عموما انا هاحاول اشوف طريقة اخليه يطلع في استعلام بدل جدول عشان حجم الداتا كبير جدا والاحتفاظ بيها في جداول هيسبب مشكلة

 

3 ساعات مضت, girl said:

لا اريد كل المادة على اكسيس :)

طيب في طريقة اخرى:

نعمل ملف mdb خارجي مؤقت في نفس مجلد البرنامج،

ونصدر الكلمات اليه ،

ونعمل في برنامجك استعلام يأخذ البيانات هذا من الملف الخارجي ، وبالطريقة هذه ، لن يكون هناك ضغط على برنامجك!!

 

هل تصلح لك هذه الطريقة؟

 

جعفر

[رمهان]

اعزائي

وجهة نظر : بما نه تم المطلوب من قبل الاستاذ جعفر وعن طريق جدول والاخت تريده باستعلام !! مالمشكلة ان يكون الجدول مصدر للاستعلام حتى ويمكن اخفاء الجدول . بل ان هناك حاجة للجدول ولربطه مع جدول القاموس لنظهر باستعلام به بيانات من الجدولين . 

فكرة حل : لدي فكرة ولكن يستعصي علي تنفيذها في الوقت الراهن لانه يبي لها قعدة وانا مشغول جدا ولكن يمكن يسعفني الاستاذ جعفر او احد الاخوة بتفنفيذها وهي كالتالي :

استبدال الفراغ بجملة استعلام توحيد بحيث ان كل فراغ سيحل محله جملة التوحيد لكل كلمة وهنا سيتم انشاء جمل توحيد حسب الفراغات وطبعا بمساعدة الدالة replace

اتوقع يمكن من خلال الكود انشاء نص الاستعلام التوحيد لكل كلمة ولكن هنا سيكون حروف الاستعلام كثيرة وحتما سيتعدى الحد المسموح به في الاكسس . ففكرة استبدال الفراغات بجمل توحيد مناسبة ولكن كيف ثم كيف التنفيذ

تحياتي

تم تعديل ديسمبر 4, 2016 بواسطه رمهان

[girl]

اشكر جميع الزملاء على مشاركتهم الفعالة وساكتفي بما قدمه الاستاذ جعفر وسأحاول اخراج النتيجة في استعلام تحديد بدلا من الجدول ، والا فاسضطر له

* الاستاذ ابو جودي البرنامج ليس للترجمة ولكن لتحليل جمل باللغة الانجليزية عن طريق تمريرها على قاموس بنفس اللغة