Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
But, can you show us some sample values, i mean entire string value?
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
];
He did provide a sample here -> Re: Extract 6-digit number string from text fied
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
];
Thanks a lot. This is great
ek number swuehl
Hindi mein Number 1? Kush
hahaha Yeah sunindia
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?