Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Looking for suggestions on preparing some data from network capture

Solved!
mikerjohnson
Level 1
Looking for suggestions on preparing some data from network capture
Essentially need to "slide" fields to the left on certain rows. For example, would like

info.izatcloud.net CNAME d339cgtc8rkl09.cloudfront.net A 99.84.194.34 A 99.84.194.78 A 99.84.194.98 A 99.84.194.2,CNAME,d339cgtc8rkl09.cloudfront.net,A,99.84.194.34,A,99.84.194.78,A,99.84.194.98,A,99.84.194.2,,,,,,,,,,

to become

info.izatcloud.net,A,99.84.194.34,A,99.84.194.78,A,99.84.194.98,A,99.84.194.2,,,,,,,,,,

Thanks for your suggestions!
(edited with better example of data)
1 Solution
Alan_Fusté
Level 3
Level 3
Hi mikerjohnson,

You can use a Prepararion Recipe and there add a Find and replace module. You can also use regular expresion, for example:

Replace: "info.izatcloud.net([A-Za-z0-9_-]*) A " (without "")

By: "info.izatcloud.net A "

Don't forget to change Matching mode to Regular Expresion and if you want to "slide" to the left, maybe is a good idea to use the checkbox "Only perform the first matching replacement" in order to avoid possible errors.

View solution in original post

0 Kudos
1 Reply
Alan_Fusté
Level 3
Level 3
Hi mikerjohnson,

You can use a Prepararion Recipe and there add a Find and replace module. You can also use regular expresion, for example:

Replace: "info.izatcloud.net([A-Za-z0-9_-]*) A " (without "")

By: "info.izatcloud.net A "

Don't forget to change Matching mode to Regular Expresion and if you want to "slide" to the left, maybe is a good idea to use the checkbox "Only perform the first matching replacement" in order to avoid possible errors.
0 Kudos