topic Re: How to parse/extract/format a string based a pattern? in Data Engineering

How to parse/extract/format a string based a pattern?

Databrickguy — Sat, 17 Dec 2022 00:40:00 GMT

How to parse, extract or form a string based on a pattern?

SQL server has a function which will format the string based on a pattern. example,

a string is "abcdefgh", the pattern is XX-XX-XXXX,

the the string will be "ab-cd-efgh".

How to archive this with a function?

Re: How to parse/extract/format a string based a pattern?

Aviral-Bhardwaj — Sun, 18 Dec 2022 06:22:39 GMT

Hey @Tim zhang ,

This is silly answer but this can give you some idea

or you can use for loop here,

Thanks

Aviral

Re: How to parse/extract/format a string based a pattern?

Databrickguy — Sun, 18 Dec 2022 22:39:04 GMT

Thanks a lot of your replay @Aviral Bhardwaj

I try to not hard code it and eventually turn it to a function. This is a initial raw code, but it has problem,

val pattern="XX-***-XXXX-***";

val item="abcdefghijkl"

val patternindex=pattern.lastIndexOf("-");

val patternupdated= pattern.substring(0,patternindex);

var lenplus = pattern.indexOf("-")

var fitem=item.patch(lenplus, "-", 0)

val result = patternupdated.split("-")

for ( a

{

val len= a.length()

// Displays output

lenplus = len + lenplus+1

fitem= fitem.patch(lenplus, "-", 0)

println(fitem)

}

The result is wrong,

ab-cd-efghijkl

ab-cd-efg-hijkl

ab-cd-efg-hijk-l

Re: How to parse/extract/format a string based a pattern?

Aviral-Bhardwaj — Mon, 19 Dec 2022 03:03:38 GMT

@Tim zhang ,

thanks for your code, and here is your answer

I asked this question in Stackoverflow and got this answer

Here is the Stackoverflow link- https://stackoverflow.com/questions/74845760/how-to-parse-a-pattern-and-use-it-to-format-a-string-using-the-specified-groups/

Please select my this answer as the best answer,it will be really encouraging

Thanks

Aviral Bhardwaj

Re: How to parse/extract/format a string based a pattern?

Aviral-Bhardwaj — Tue, 20 Dec 2022 01:47:21 GMT

did you get any time to cehck above response @Tim zhang

Re: How to parse/extract/format a string based a pattern?

Databrickguy — Tue, 20 Dec 2022 03:26:43 GMT

yea, it works! Thanks!

Re: How to parse/extract/format a string based a pattern?

Aviral-Bhardwaj — Tue, 20 Dec 2022 04:10:00 GMT

@Tim zhang can you please upvote my answer and make it as best answer,it will be great help