nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Austin Duncan <adun...@pyaanalytics.com>
Subject Re: Replace Text
Date Wed, 08 Nov 2017 14:43:42 GMT
I am using executeSQL thanks thats perfect.

On Wed, Nov 8, 2017 at 9:32 AM, Matt Burgess <mattyb149@apache.org> wrote:

> Austin,
>
> If your data is not coming from something like ExecuteSQL (which Bryan
> mentioned) but you are defining a schema for it, there are a couple of
> options. First, what format is your data in? If CSV, you can configure
> a CSVReader to use your schema and ignore the header, effectively
> renaming the fields. That reader can be used in any downstream
> record-aware processor (don't bother using ConvertRecord to read and
> write to the same format, it is unnecessary).  If your data is in
> JSON, you can use the JoltTransformJSON processor to rename the
> fields. If your data is in XML, you can use TransformXML to rename the
> fields. If it is in some other format, please describe and we can get
> it figured out.
>
> Regards,
> Matt
>
>
> On Wed, Nov 8, 2017 at 9:21 AM, Bryan Bende <bbende@gmail.com> wrote:
> > Austin,
> >
> > Are you referring to Avro schemas created by ExecuteSQL?
> >
> > If so, there was a property added called "Normalize Table/Column
> > Names" which will convert non-compatible characters for you.
> >
> > -Bryan
> >
> >
> >
> > On Wed, Nov 8, 2017 at 9:10 AM, Austin Duncan <aduncan@pyaanalytics.com>
> wrote:
> >> So avro schemas dont allow spaces. Is there a way for me to replace
> >> underscores with spaces efficiently? Right now I am using a bunch of
> replace
> >> text processors to replace the strings that contain underscores with
> strings
> >> with spaces. Is there a better way of doing this? It works now because
> my
> >> tables are not very big but i imagine there will be a situation in
> which I
> >> will have a table with a lot of columns that I would want to replace.
> >>
> >> --
> >> Austin Duncan
> >> Researcher
> >>
> >> PYA Analytics
> >> 2220 Sutherland Avenue
> >> Knoxville, TN 37919
> >> 423-260-4172
>



-- 
​Austin Duncan
*​Researcher​*

PYA Analytics
2220 Sutherland Avenue
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
Knoxville, TN 37919
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
423-260-4172
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
<%28865%29%20684-2828>

Mime
View raw message