Embedded New lines in a single cell

Question

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

Employee workflow.yxmd

employee.xlsx

davidskaife · Accepted Answer

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 Answer

Hi @anjanarnair,

Please see attached my suggestion. Hope it helps.

Cheers,

Lelia

ncrlelia · Accepted Answer

Hi @anjanarnair

Please see attached my suggestion.

Hope it helps.

Cheers,

Lelia

anjanarnair · Accepted Answer

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 Answer

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?