FlatFile parsing

Hi Experts,

Currently I am having a requirement to parse the following using the flat file which is comma delimited :

abc,def,{“username”:“xyz”,“useridtype”:“CV”,“lastname”:“test”},xxxyyzz,dddeeefff,status

This is just sample one record . If carefully observed we have to consider the content inside flower brackets also containing comma as one record .

Any hints on this highly appreciable .

Thank you.

Regards,
Nischal

Use in FF schema,
Record Parser=delimiter
Record=newline
Field or composite=,

Use extractor type as Nth field while creating the field definition under the record definition in your FF dictionary.

PFA screen of the results.

testFF.jpg

Hi Mahesh,

Thank you for your response . To be more specific we are looking for a solution where entire content which is within the flower bracket should be considered as single string meaning despite it having a comma within it ( it should be treated as a single entity )

Regards,
Nischal

Did you look at my screen shot that was attached earlier, it is ok for you?