Extract 6-digit number string from text fied

[#1]

Dear all,

I have a text field covering various information, such as cost center number, creditor, number, date number and text information.

I want to extract the creditor information. The issue I have is, that the Position of the creditor number within the text field is not consistent and that I have multiple information with numbers. Thus keepchar formula or left/right funktion I tried didn't work properly.

The critieria that would be unique are, that the creditor number has always 6 Digits and can only be between 700000 and 899999.

Can you think of combination of QV-functions that would cover above requirements?

Thanks and best regards,

Tobias

[Kushal_Chawda]

But, can you show us some sample values, i mean entire string value?

[swuehl · Accepted solution]

So what about

MAP:

MAPPING

LOAD

  699999+recno() as F1,

  '\/' & num(699999+recno(),'000000') & '/\' as F2

AutoGenerate 200000;

Table:

LOAD Records,

  TextBetween(MapSubString('MAP',Records), '\/','/\',1) as Number;

LOAD * Inline [

Records

something-123456-Hotman-something-something

something-Hotman-701245-something-XMan

];

[sunny_talwar]

He did provide a sample here -> Re: Extract 6-digit number string from text fied

[sunny_talwar]

Amazing Stefan.

Worked for his sample

MAP:

MAPPING

LOAD

  699999+recno() as F1,

  '\/' & num(699999+recno(),'000000') & '/\' as F2

AutoGenerate 200000;

Table:

LOAD *,

  TextBetween(MapSubString('MAP', FieldName), '\/','/\',1) as Number;

LOAD * Inline [

FieldName

822201 Aufl TP Vision Ambilight

822561 Aufl LG Electro Aktion

Passivierung zum 31.12.2015 808386 M1311420

Passivierung zum 31.12.2015 747150 M2651300

];

[#6]

Thanks a lot. This is great

[Kushal_Chawda]

ek number swuehl‌

[sunny_talwar]

Hindi mein Number 1? Kush

[Kushal_Chawda]

hahaha Yeah sunindia‌

[Janpeer]

This is a great solution and for 6 digits, it works fine for me. But I have the subject for 8 digits and I am not able to manage it. I have numbers from 80000000 to 85000000 in string. They are somtimes in the middle but somtimes also at the end. I was able to extend the solution to 7digits. but if I add on to all mentioned values up to 8 digits, nothing is displayed anymore. Can anybody help?