I have to extract the number starting from 5 and it should be 7 digits

[NavinReddy]

Hi All,

i have to extract the number starting from 5, and it should be 7 digit. please find the number below numbers i have highlighted.

please help me

5834499
58330555833055
5795472
5816725
125816725
583252360
25808423
5794911
58167185822715
5833055
345816735
5829064
4015847681
305794906
5795447

Thanks in Advance,

Niranjan

[Sergey_Shuklin]

Hello!

If I've understood you right.

[tresesco · Accepted solution]

Or, perhaps this?

mid(nm,Index(nm,'5'),7) as p Inline

[NavinReddy]

Hi Shuklin,

Thanks for your reply

From the all the numbers i have to fetch 7 digit number starting from *5.

Thanks

Niranjan

[NavinReddy]

Thank you so much Tresesco, its working fine

[gawalimegha]

Hello Niranjan,

Here is desired output.

Main:

LOAD * Inline

[

numbers

5834499

58330555833055

5795472

5816725

125816725

583252360

25808423

5794911

58167185822715

5833055

345816735

5829064

4015847681

305794906

5795447

];

temp:

LOAD numbers as oldNo,

mid(numbers,Index(numbers,'5'),7) as NewNo

Resident Main;

drop Table Main;