Extracting first occurance of number from String

dhiren · Post by **dhiren** » Mon Sep 26, 2005 3:55 am

Hi All,
We have a requirement to extract the first occurance of number from the Strings.
The example of Strings are
COROMN13, LIMSTO1, ORAOMN5PUY67

For eg, in the following Strings below , i need the following Output:

COROMN13 --> Extract number 13
LIMSTO1 --> Extract number 1
ORAOMN5PUY67 ---> Extract number 5

How do i incorporate this? Is there some function in transformer where i can extract the first occurance of numbers in String?

Please guide with syntax.

Thanks in advance,
Regards,
Dhiren

roy · Post by **roy** » Mon Sep 26, 2005 5:35 am

Hi,
You can go over the rouines, I don't recall seeing one that does this.

You'll need to loop on the string 1 character at a time and test for numeric and build your number if it's more the 1 character long.
you'll need Len(), Loop/For, Substring operator [start position,length]

IHTH,

pnchowdary · Post by **pnchowdary** » Mon Sep 26, 2005 9:29 am

Hi dhiren,

Do you know the maximum size of the numeric value that is embedded in the string?. Can two numbers occur next to each other? If you dont know how big the number can be, it is not possible to extract it.

For Example

COROMN13198POIUT1234

If you dont know the size, what would you expect to be extracted in the above string, 1 or 13 or 13198

dhiren · Post by **dhiren** » Mon Sep 26, 2005 12:03 pm

Thanks for the replies so far.
The maximum length that can occur is unknown.

In this case(COROMN13198POIUT1234) it will be 13198.

Now if i make the Code to answer most likeliest of possibilities, then the numeric string will be last one or two characters.

eg COROMN13 --> extract 13
POIUT1 --> extract 1

Which one (function ) in this case then will be more useful?
Rightmost character extraction using (Right) or usage of Field() etc?

Regards,
Dhiren

pnchowdary · Post by **pnchowdary** » Mon Sep 26, 2005 1:05 pm

Hi dhiren,

Your requirement needs to be more specific, for us to be able to help you more.

Can we assume that the number you want to extract is always at the end of the string?

Now if i make the Code to answer most likeliest of possibilities, then the numeric string will be last one or two characters.

If the character is last 1 or 2 characters, then you can use the right function to always get the last two characters and then use the Oconv function to extract numbers only.

The syntax will be something like this

Code: Select all

Oconv(Right(InLink.InCol,2),"MCN")

ray.wurlod · Post by **ray.wurlod** » Mon Sep 26, 2005 4:37 pm

Oconv() is not available in parallel jobs, except in BASIC Transformer stage.

htrisakti3 · Post by **htrisakti3** » Mon Sep 26, 2005 4:59 pm

create this into a function & call it using your string as argument.. mystring is used for illustration:

Code: Select all

mystring = "ABCD4XXYYZ22Z33"
temp1 = Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ", "                          ", mystring) 
* temp1 is now:"      4     22 33"

temp2=TRIM(temp1)
*temp2 value: "4 22 33" 

temp3=Field(temp2," ",1)
*temp2 value: "4" -- get 1st occurence

Ans = temp3

ray.wurlod · Post by **ray.wurlod** » Mon Sep 26, 2005 8:30 pm

Does that work in parallel jobs?

aartlett · Post by **aartlett** » Tue Sep 27, 2005 12:34 am

Seeing as it's PX couldn't a C function be written to handle it? or even a lex function converted to C, compiled and used in the job?

Functionally the same as the basic code but more efficient.

<<Hey, this makes post 50 ... yippee>>> nearly at 500 points too.

roy · Post by **roy** » Tue Sep 27, 2005 1:10 am

Ray, the code should work using transformer and Stage Variables as far as I can see (Nice Solution

);
You might want to add more things like lower case letters or any other variation that might also be inside the original string which you want to ignore (I wonder will the performance be satisfactory

).

I for one think the original post was quite clear on the requirements for those who asked for more info.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 27, 2005 1:23 am

If you're going to allow BASIC Transformer stage, then the ideal function is

Code: Select all

MatchField(InLink.TheString, "0A0N0X0N0X", 2)

cmmurari · Post by **cmmurari** » Tue Sep 27, 2005 1:41 am

Mr.Ray , Thanks for your Nice Solution

roy · Post by **roy** » Tue Sep 27, 2005 1:44 am

I've tested:

Code: Select all

$ more rtest*.txt
::::::::::::::
rtest.txt
::::::::::::::
ABG3asfgfz1234dfafahgFGSGS
ABGZ567gfz1234dfafahgFGSGS
ABGZasfgfz1234dfafah546SGS
ABGZasfgfz1234dfafahgFGSGS
::::::::::::::
rtest2.txt
::::::::::::::
"3"
"567"
"1234"
"1234"
$

rtest.txt is the source file rtest2.txt is the output file
px transformer with:
sv1 has:

Code: Select all

Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz","                                                   ", DSLink2.c1)

sv2 has:

Code: Select all

Trim(sv1)

output column has:

Code: Select all

Field(sv2," ",1)

Enjoy,

cmmurari · Post by **cmmurari** » Tue Sep 27, 2005 2:05 am

Yes I have tested.
Convert , Trim, and Field BASIC functions working fine in Parallel Transformer Stage.
Field(Trim(Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ", " ", "ABCDEF83743F"))," ",1).

Thanks htrisakti3

dhiren · Post by **dhiren** » Thu Sep 29, 2005 9:32 am

Thanks all those who replied.

This thing worked without the usage of Routine. All i needed is just to use three Stage Variables