Hi,
I have a txt file with the following data (24 columns where the last column might be null):
2617|N|N|903|Kupelweiser Wine Tasting with Brand Ambassador Peter Zemmer|Meet the Maker Tasting|Wine||11/20/2014|16:00:00|19:00:00||||In 1878 Fritz Kupelwieser founded a cellar in the prestigious Alto Adige region of Northern Italy that still bears his name. During the 1960’s Kupelwieser began to produce superior white wines in response to demand for elegant whites. Today, Peter Zemmer, the grandson of Fritz, has developed Kupelwieser Winery into one of the top estates in the Trentino-Alto Adige, a region noted for its crisp and elegant wines.|Kupelweiser|Kupelweiser|Italy|Peter|Zemmer|Brand Ambassador|95476750;99842750;95475750;99843750;;;;;;;||
2618|N|N|906|Kupelweiser Wine Tasting with Brand Ambassador Peter Zemmer|Meet the Maker Tasting|Wine||11/21/2014|16:00:00|19:00:00||||In 1878 Fritz Kupelwieser founded a cellar in the prestigious Alto Adige region of Northern Italy that still bears his name. During the 1960’s Kupelwieser began to produce superior white wines in response to demand for elegant whites. Today, Peter Zemmer, the grandson of Fritz, has developed Kupelwieser Winery into one of the top estates in the Trentino-Alto Adige, a region noted for its crisp and elegant wines.|Kupelweiser|Kupelweiser|Italy|Peter|Zemmer|Brand Ambassador|99842750;95475750;95476750;99843750;;;;;;;||
The graph is failing to parse the file with the following error message, (where the 1st and 2nd record are getting concatenated since \n is not recognized):
Unexpected default field delimiter, probably record has too many fields. in record 1, field 24 (“OfficePremiseLocation”), metadata “event”; value: '2617|N|N|903|Kupelweiser Wine Tasting with Brand Ambassador Peter Zemmer|Meet the Maker Tasting|Wine||11/20/2014|16:00:00|19:00:00||||In 1878 Fritz Kupelwieser founded a cellar in the prestigious Alto Adige region of Northern Italy that still bears his name. During the 1960\u0092s Kupelwieser began to produce superior white wines in response to demand for elegant whites. Today, Peter Zemmer, the grandson of Fritz, has developed Kupelwieser Winery into one of the top estates in the Trentino-Alto Adige, a region noted for its crisp and elegant wines.|Kupelweiser|Kupelweiser|Italy|Peter|Zemmer|Brand Ambassador|95476750;99842750;95475750;99843750;;;;;;;||\n2618|N|N|906|Kupelweiser Wine Tasting with Brand Ambassador Peter Zemmer|Meet the Maker Tasting|Wine
The 24th column is having delimiter such as \n whereas the other columns are delimited with |.
I tried all the possibilities for 24th column’s delimiter but it’s still giving me same error.
Even adding a value to the 24th column (instead of having it null) is giving the same error.
Could you please let me know how to solve this issue?
Thanks and regards,
Sarah