Create a Function to extraxt a specific secuency of numbers

Vivarafa

Create a Function to extraxt a specific secuency of numbers.JPG

Team ,

Connecting a data from salesforce, the dataset came with this challenge:

Do any want have a idea to extract for this the secuency number " >5192438<"

<a href="https://eomprd.health.ge.com/eom_prd/secured/ordquery.ctrl?hidGONSearch=true%26hidGONSearchStatus=true%26txtGONSearch=5192438%26hidTxtGonSearch=5192438" target="_blank"></a>The solution could be in Magic ETL or Dataflow making use of SQL.I´ll appreciate any help, RAV

GrantSmith

Assuming you're wanting the numerical value out of the hidTxtGonSearch field you can utilize a regular expression in a formula tile in Magic ETL.

REGEXP_REPLACE(`field`, '^.*hidTxtGonSearch=(\d+).*$', '$1')

Ashleigh

@Vivarafa you can also use the split column tile in magic and set it to split on the phrase right before the value, you can use that a couple times on the >< characters until you get your amount. There are also split functions in the formula tile you could use as well.

GrantSmith

Assuming you're wanting the numerical value out of the hidTxtGonSearch field you can utilize a regular expression in a formula tile in Magic ETL.

REGEXP_REPLACE(`field`, '^.*hidTxtGonSearch=(\d+).*$', '$1')

Ashleigh

@Vivarafa you can also use the split column tile in magic and set it to split on the phrase right before the value, you can use that a couple times on the >< characters until you get your amount. There are also split functions in the formula tile you could use as well.

Vivarafa

Ash.JPG

Grant.jpg

@GrantSmith @Ashleigh Thank you both. I´ve test making use both method and worth it. I appreciated your support