Embedded New lines in a single cell

[anjanarnair]

Hi,

I have a input data set,it has some embedded new lines.I need to make a proper excel format based on this data set.

Here iam attaching the workflow which have the input text data ,Also iam attaching the expected output excel format.

Any help would be great!

Thanks,

Anjana

[DavidSkaife · Accepted solution]

Hi @anjanarnair 

It's not pretty....but please find attached a workflow that seems to work. I've had to make a few assumptions as to the structure of the data in that the pattern is identical if you add more data, and the headers are static:

[ncrlelia · Accepted solution]

Hi @anjanarnair,

Please see attached my suggestion. Hope it helps.

Cheers,

Lelia

[anjanarnair]

You are right.Worked Fine.

Thank You!

[anjanarnair]

I was able to generate the csv.

Thank You!

[anjanarnair]

Hi @ncrlelia ,

I have a medical report workflow,which is also having embedded lines.It seems like some of the input text data is not need to generate the output.Iam attaching the workflow  along with the Text input  and Expected Csv file here.Could you please have a look into this and please help me to solve this.

Thanks,

Anjana

[ncrlelia · Accepted solution]

Hi @anjanarnair 

Please see attached my suggestion. 

Hope it helps.

Cheers,

Lelia

[anjanarnair · Accepted solution]

Hi @DavidSkaife 

I have a medical report workflow,which is also having embedded lines.It seems like some of the input text data is not need to generate the output.Iam attaching the workflow  along with the Text input  and Expected Csv file here.Could you please have a look into this and please help me to solve this.

Thanks,

Anjana

[DavidSkaife · Accepted solution]

Hi @anjanarnair 

Please find attached, again made a few assumptions with the field names being static but this should be more dynamic as the number of accident months appears to differ per record:

Just out of interest is there any other way of obtaining the data, other than this csv format?

[anjanarnair]

Resolved!

Thank You.