Looking for suggestions on preparing some data from network capture
mikerjohnson
Registered Posts: 1 ✭✭✭✭
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)
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)
Tagged:
Best Answer
-
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.