Embedded new lines

[Nithinpanicker]

Hi everyone,

I have a cell which contains embedded new lines. This cell basically has a summary of all work that has been done on a ticket. This may include communication through chat, emails and updates pertaining to the ticket. This information is extracted from SNOW as a csv file which serves as the input for Alteryx. I need to use these cells from the column to look for certain keywords and phrases for analysis in Alteryx. But when I am outputting the information only the first line is being extracted. How do I make the whole data appear in every cell. 

Thanks and regards,

Nithin

[Nithinpanicker]

@Christina_H 

I believe the error is related to the delimiter as @ShankerV suggested as I can see the data after a "," being excluded. How can I change this setting to include the ",". Since my info contains emails and communications where users may use the comma in their sentences I dont want the information coming after to be excluded

[ShankerV]

Hi @Nithinpanicker 

You are supposed to modify the delimiter here as per your input shared.

But point to be noted, changing this will read the file in messy way.

Many thanks

Shanker V

[Nithinpanicker]

@ShankerV 

Is there a possible workaround for this situation?

[ShankerV]

Hi @Nithinpanicker 

For example, if your data is like this.

A,B,C,D,nobleshanker@gmail.com,shanker@gmail.com

Each , is read as different columns.

Please do the modification in the input file as below

A,B,C,D,nobleshanker@gmail.com;shanker@gmail.com

So the comments column will read as single column.

Logic is the identifier used should be unique, which should not be used in other columns.

Then only delimiter will work correctly.

Many thanks

Shanker V

[ShankerV]

Hi @Nithinpanicker 

As it will be difficult to modify in the .CSV file.

Please save with the unique delimiter while saving the csv file like 

pipe symbol |

or # symbol.

Many thanks

Shanker V

[Nithinpanicker]

Hi @ShankerV 

Changing the delimiter to | or # merges all the columns into one now 😥. 

[binuacs]

@Nithinpanicker try to read your input file with the below configuration, and see you are getting all the records? 

[Nithinpanicker]

@binuacs 

Tried what you suggested but its combined all the other columns into one now.

Is there a way I can remove the commas from the comments and work notes cells before inputting into alteryx?

 

 

[Nithinpanicker]

For better context:

"Comments and work notes" is a column and the data under the column contains a history of emails and chats. So if there is a comma in those cells data gets excluded.

[ShankerV]

Hi @Nithinpanicker 

Changing the delimiter to | or # merges all the columns into one now.

Yes as I said it will mess up the data.

My request was to use the delimiter while saving the .CSV file

Then use the same delimiter when Alteryx Input.

As it will be difficult to modify in the .CSV file.

Please save with the unique delimiter while saving the csv file like 

pipe symbol |

or # symbol.

Many thanks

Shanker V

.