Create a Function to extraxt a specific secuency of numbers

Vivarafa · 2023-06-14T21:21:38+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

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.

All comments

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')

Grant.jpg

Ash.JPG

Ashleigh

Grant.jpg

Ash.JPG

Vivarafa

Ash.JPG

Grant.jpg

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