Created 08-18-2016 12:28 PM
I have a file which has a bunch ^@ in it. I would like to remove these to clean up the file. I was going to use ReplaceTExt in nifi but I cant figure out the correct regex for this, any help would be appreciated. Thanks
Created 08-18-2016 01:17 PM
That sounds like it could be a visual representation of a range of different control characters in the file. One thing to do would be to use a regex like [^\d\w] to greedily replace the non-ascii and non-digit characters.
Created 08-18-2016 01:17 PM
That sounds like it could be a visual representation of a range of different control characters in the file. One thing to do would be to use a regex like [^\d\w] to greedily replace the non-ascii and non-digit characters.
Created 08-18-2016 06:31 PM
If you want to keep only numbers and alphas, you can use something like this:
[^0-9a-zA-Z]+
If you want also to keep some special characters like {}, you can use something like this:
[^0-9a-zA-Z{}]+
Obviously, you can add other special characters to the above regex
The following matches any non-alphanumeric characters:
[^\w\d]
Try this interactive tutorial: http://regexone.com/