1

كيف يمكن قطع جزء من النص في صيغة تكويد الملفات؟

على غرار دوال ال left,right, substring، في لغة ال SQL كيف يمكن قطع جزء النص في صيغة تكويد الملفات؟

Eldabbas's avatar
9.1k
Eldabbas
asked 2019-03-07 08:45:10 +0200
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

1

The following functions can do that
$left
$right
$mid

Examples:<br/>
Suppose name1 is abcdef
${name1.$left_1} -> a
${name1.$left_2} -> ab

${name1.$right_1} -> f
${name1.$right_2} -> ef
${name1.$right_3} -> def

${name1.$mid_2_1} -> b
${name1.$mid_3_3} -> cde

They behave exactly like SQL Server: left,right, and substring

Eldabbas's avatar
9.1k
Eldabbas
answered 2019-03-07 08:58:21 +0200, updated 2019-03-07 08:58:55 +0200
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer